I just upgraded to Infragistics 2010 vol 2. Our users use to be able to right click on a web grid, select the Export to Excel menu item and then see the data export to excel.
After the update when I right click on the grid, select export to excel I get the following message in Excel:
This Web query returned no data. To modify the query, click OK, click the name of the external data range in the name box on the formula bar, and then click Edit Query on the External Data toolbar.
The above message is an excel message that wants me to modify the fomula in cell 1A. Cell 1A simply has the text value: ExternalData_1
Anyone have any ideas?
Wow, must have really stumped the masters... It's a basic question, can we LABEL the sheet names using the WebExcelExporter or not? Is it always this hard to get answers from you guys?
Hi Duane, I have a question about using the WebExcelExporter with a number of WebDataGrid controls;
namely, how can we ensure that the table names for each of the grids GETS exported with the data (the column names do well coming out by default, but we still want the table names that are being shown in the 'tabs' (using ultrawebtab ctl) to Display for the Sheet Names in the exported file..
Possible? (we don't want to save the excel files to the server, as in the "Workbook.Save" function, but let the users download to THEIR machines via the webpage)
Thanks
Hello,
Do you have any further questions on using the WebExcelExporter with the WebDataGrid control?
Let me know if you have any questions with this matter. Thank you.
Sincerely,Duane HoytDeveloper Support Engineer, MCTSInfragisticshttp://ko.infragistics.com/support
You can use the WebExcelExporter, this should be supported for the WebDataGrid. More information can be reached here: http://help.infragistics.com/Doc/ASPNET/2010.3/CLR4.0/?page=WebExcelExporter_Using_WebExcelExporter.html.
Sincerely,Duane HoytDeveloper Support Engineer, MCTSInfragisticshttps://ko.infragistics.com/support
Hi, yes I do understand there are different options for exporting data to excel. We do use the infragistics excel export stuff successfully in some of our grids. This is not the problem and we understand the issue after a bit more research on our side.
We have lots of grids where we do not need to hook in full infragistics export support and instead rely on Internet Explorer's native ability to export any html table to excel. If you right click on any html table in IE you will see the "Export to Excel" option on the right click popup. This is where the problem exists.
Older version of the UtraWebGrid generated client side html that was compatible with the native IE export function. The client side html generated by the latest release of the UltraWebGrid does not allow this IE native feature to get at the data.
Is it possible your team will be able to put our a hotfix for this problem?