Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
2325
Turning off formulas for excelexport
posted

In my ultragrids I have options for exporting to excel using the UltragridExcelExporter.   When I export I do not want the formulas to be exported, just the cell data.  How can I do this? 

Currently this is the code I am using to export my grids:

                var filePath = Application.StartupPath + "\\Export-" + Guid.NewGuid().ToString() + ".xls";
                var wkBook = new Workbook();
                wkBook.Worksheets.Add("Margins");
                excelExporter.Export(grdMain, wkBook, 0, 0);
                excelExporter.Export(grdSupp, wkBook, 75, 1);
                wkBook.Save(filePath);
                System.Diagnostics.Process.Start(filePath);

Thanks!

  • 2325
    Verified Answer
    Offline posted

    Found the answer... ExportFormulas = false;

    I thought I had deleted this thread, but I guess I did not.