class Program
{
    static void Main(string[] args)
    {
        // Create a new empty workbook in a new workbook set.
        SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook();
        // Get a reference to the first worksheet.
        SpreadsheetGear.IWorksheet worksheet = workbook.Worksheets["Sheet1"];
        // Get a reference to the top left cell of Sheet1.
        SpreadsheetGear.IRange a1 = worksheet.Cells["A1"];
        // Set a formula.
        a1.Formula = "=24901.55 / PI()";
        // Output the result of the formula.
        System.Console.WriteLine("The diameter of the earth is " + a1.Value.ToString() + " miles.");
    }
}