Export to excel 2007

80 Views

Hi,

i've create a report that I need to export in excel 2007.

If I export the report to Excel 2003 it works correctly.

If I export the report to Excel 2007-2010 (format ExcelWorkbook) it works but it lose the format style.

It's my mistake or is impossible to export a report automatically to excel 2007-2010?

I use CR for Visual Studio 2010 and CR Runtime 13.0.1.

Thks for your help.

Sacha

This is my code

var exlOption = new ExcelFormatOptions { ShowGridLines = true };

rpt.ExportOptions.ExportFormatType = ExportFormatType.Excel;

rpt.ExportOptions.FormatOptions = exlOption;

rpt.ExportToDisk(ExportFormatType.Excel, fileName); //it work correctly for Excel 2003

//ExportFormatType.ExcelWorkbook (if I try to export for Excel 2007-2010

rpt.Close();

rpt.Dispose();