WebExcelExporter1.DataExportMode = DataExportMode.AllDataInDataSource WebExcelExporter1.ExportMode = ExportMode.InBrowser WebExcelExporter1.WorkbookFormat = Infragistics.Documents.Excel.WorkbookFormat.Excel2007 WebExcelExporter1.DownloadName = "Report" & DateTime.Now.ToString("_HHmmss_MMddyyy") & ".xlsx" The format of the Excel file is 2007; however, the extension appended to the download name is .xls We can open the file in Excel 2007 after removing the .xls extension.
Hello,
I was not able to see the behavior you described in our online sample on the below link:
http://www.infragistics.com/products/aspnet/sample/data-grid/excel-exporter
To test the behavior you described I selected “Excel 2007 Format” radio button from the Format group. It show the ExportedData.xslx file when I click on the “Export” button. In order to look in to this provide me with the version of NetAdvantage product you are using so I may look in to this.
I hope this helps.
NetAdvantage 2012.2 ASP.NET CLR 4.0
Version: 12.2.20122.2075
I was able to see the behavior you described. After doing further research, I have attached the issue with our developers in our tracking system, with an issue ID of # 137770. This development issue will be assigned to a developer to research for a fix, workaround, or other resolution. I will update this forum thread once I have any update from development on this.
Hi
I have a related issue to this. I get the same extension of .xls when exporting, but can also confirm that the file format itself appears to be.xls not .xlsx as it should be. I'm also using CLR 4.0, latest release (Version=12.2.20122.2054).
I get the following error when exporting more than 65536 rows. This should work if the format was .xlsx?
The maximum number of rows in an excel worksheet with the current format is: 65536
Below is sample snippet of code I'm using (VB.Net)
Dim wb As New Infragistics.Documents.Excel.Workbook wb.Worksheets.Add("Data") With WebExcelExporter1 .DownloadName = "My Excel Download" .DataExportMode = DataExportMode.AllDataInDataSource .ExportMode = ExportMode.Download .WorkbookFormat = Infragistics.Documents.Excel.WorkbookFormat.Excel2007 .EnableStylesExport = False .DisableCellValueFormatting = True .Export(ExportGrid, wb.Worksheets("Data")) End With
Are there any workarounds you can suggest? You mention that Excel 2007 format works in your sample. Is this because it's a different CLR to 4.0?
Not sure if it will make a difference; but, I am on version 12.2.20122.2075 (you are on 2054).
The one difference I see is when creating a workbook we specify the workbook format:
Dim SearchResultsWorkbook As New Infragistics.Documents.Excel.Workbook(Infragistics.Documents.Excel.WorkbookFormat.Excel2007)
As far as our original issue, we are still waiting for a new release; however, we wrote a workaround were we save the file first, rename the extension and then download that file with the corrected extension.