hi,
Can anyone let me know ,
Is there any way to export to excel from complete dataset without using the webdatagrid.
Thanks in Advance
Hi avilkoomar_1202,
Thank you for posting in the community.
You can use the Infragistics.Excel library in order to create a workbook using a dataset. A complete guide on how this can be achieved is available at:
http://help.infragistics.com/NetAdvantage/ASPNET/2011.2/CLR4.0/?page=ExcelEngine_Populating_a_Worksheet_from_a_DataSet.html
Please let me know if this helps.
Hi Petar Ivanov,
Thanks for your quick relpy,
i have gone to the link that you have provided me. i need to save the workbook with save as dialog ,i.e providing the user to select a location to save the file.but i have find the save as in the workbook .
Can you provide the information to save a file with "Save as" dialog.
Or
Is there any way to save the workbook using the excelexporter
Thanks In Advance.
Hi anilkoomar_1202,
It is possible to donwload the workbook you have created using the ExcelExporter by using a dummy grid. For instance:
Thanks for your answer .Its works for me.
Regards,
Anil
Hi Anil,
Please feel free to contact me if you have any questions regarding this matter.
Thank you for your reply.
The exporter does not feature an "Export Completed" javascript event as the postback generated by the "export" button for instance creates the download dialog window and the original page is not updated (i.e. no response is sent to it). Therefore I would suggest considering other approaches to approximate the status of exporting (by noting for instnance its start by handling the clientside click of the export button).
Please feel free to contact me if I can be of further assistance regarding this matter.
Can u let me know how to call a java script when the excelexpoter completed.i havent find any event for exporter .
Glad to help. Please feel free to contact me if you have any questions regarding this matter.