Dates formatted as general in exported file

[B]

When I'm exporting a file that has dates, the format is coming across as general instead date.  When I inspect the column data deserialized from the model object it is indeed showing a date format, it just doesn't seem to be applied when the workbook is created.  Any suggestions?

[Nikolay Demirev]

Hello B Smith,

The RadSpreadStreamProcessing exports only the data which is given. It does not "understand" that it is a Date value in order to apply a number format. In order to export cell values formatted as Date, you have to set the cell format too. Here is an example:

using (FileStream stream = File.Open(fileName, FileMode.OpenOrCreate))
{
    using (IWorkbookExporter workbook = SpreadExporter.CreateWorkbookExporter(documentFormat, stream))
    {
        using (IWorksheetExporter worksheet = workbook.CreateWorksheetExporter("Date"))
        {
            using (IRowExporter row = worksheet.CreateRowExporter())
            {
                using (ICellExporter cell = row.CreateCellExporter())
                {
                    cell.SetValue(DateTime.Now);
                    cell.SetFormat(new SpreadCellFormat() { NumberFormat = "m/d/yyyy" });
                }
            }
        }

    }
}

I hope the provided information was helpful.

Regards,
Nikolay Demirev
Progress Telerik