class Program
{
    static void Main(string[] args)
    {
        // Create a new empty workbook set with the current thread's culture info.
        SpreadsheetGear.IWorkbookSet workbookSet
            = SpreadsheetGear.Factory.GetWorkbookSet(System.Globalization.CultureInfo.CurrentCulture);
        // Create a new empty workbook in the workbook set.
        SpreadsheetGear.IWorkbook workbook = workbookSet.Workbooks.Add();
        // 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.");
    }
}