I am trying to find a way to export my igGrid to excel, pdf, etc. I have found some examples, but they are all for MVC, I am using asp.net. Any suggestions on how to get that done. I would like the grid to be exported as is with the same formatting as my grid. The datasource of the grid is json.
Thanks,
Saevar
Hi saevar,Thank you for posting in the community.I assume that you have referred to the following sample:http://samples.infragistics.com/jquery/infragistics-excel/create-excel-worksheetIn the above example, the exported Workbook is created manually using the datasource of the igGrid. Note that currently there is no exporter for the igGrid and the ASP.NET Excel engine can be used to create workbooks manually with the grid's data.
Similarly if you have an igGrid in a regular WebForm, you will need to create a workbook using the data bound to your grid (in this case your json). Useful guides for creating and customizing Workbooks can be found at:http://help.infragistics.com/NetAdvantage/jQuery/Current/CLR4.0?page=ExcelEngine_Using_the_Infragistics_Excel_Engine.htmlPlease let me know if you have any questions.
Hi saevar,
Please feel free to contact me if you have any further questions.
your reply helped me. i will just do it based on a data source. I did post another question in regards to adding images and links to the grids.
http://forums.infragistics.com/forums/p/64385/325828.aspx#325828
thanks
Sy
Hi Peter,
Due to project requirement, I am using ASP. I am also trying to find a way to export my igGrid to excel, pdf, etc. Any suggestions on how to get that done? I am searching online documents but cannot find any examples. Thanks
Patrick
Hi bcsite,
Thank you for posting in the community.
As I have mentioned above, the igGrid does not currently have its own exporter. Therefore I suggest that you use the Infragistics Excel and Document engines in order to export your data directly. More information on creating excel spreadsheets and reports using these can be found at:
http://help.infragistics.com/NetAdvantage/ASPNET/2011.2/CLR4.0/?page=DocumentEngine_Writing_Reports.html
http://help.infragistics.com/NetAdvantage/ASPNET/2011.2/CLR4.0/?page=ExcelEngine_Using_the_Infragistics_Excel_Engine.html
Please let me know if you have any questions.