Hello,
I am exporting a XamDataGrid to excel and am getting an exception with this text:
"The maximum number of columns in an excel worksheet with the current format is: 256"
What does "the current format" mean? How can I remove this limit?
Thanks,
Dave
That is correct. The Office 2003 Excel and previous versions only supported up to 256 columns. The Office 2007 format supports over 16,000. So the exception referring to format is in regards to the WorkbookFormat you are using - this comes from either the overload of the Export method you use or the format you used when you created the Workbook. Note the DataPresenterExcelExporter also has the option to simply ignore/truncate the data instead of throwing an exception. This is exposed via the FileLimitBehavior on the ExportOptions class - which is a parameter to some overloads of the Export method.
This is an Excel limit, not a XamDataGrid limit.