Hi,in XamGrid I want to export the data to excel;in your control XamDataGrid I can use the DataPresenterExcelExporter-Class.Is there a way to use the DataPresenterExcelExporter-Class in XamGrid?Thanks voks
Hi voks,
Because of the underlying differences between the XamGrid and XamDataGrid, the DataPresenterExcelExporter can only be used with the XamDataGrid.
I think this link will be very helpful. It explains how you can export the XamGrid to Excel.http://help.infragistics.com/Help/NetAdvantage/Silverlight/2011.2/CLR4.0/html/SL_Exporting_xamGrid_Data_to_Excel.html
A few things to note. The link points to the Silverlight documentation but the code used to export the grid is the same for WPF as well. Make sure you include the WPF versions of the assemblies mentioned on the page as well as add InfragisticsWPF4.DataManager.v11.2.dll to the list.
Let me know if you have any questions on this.
Do you require further assistance on this?
i also have a problem with the export to excel. i simply want to export my whole xamdatagrid to excel like in this tutorial
http://www.youtube.com/watch?v=dtn9oa_Yz_0:
but in this code:
string fileName = @"C:\Temp\tmp.xlsx"; DataPresenterExcelExporter exporter = (DataPresenterExcelExporter) this.Resources["excelExporter"]; ExportOptions options = new ExportOptions(); options.FileLimitBehaviour = FileLimitBehaviour.ThrowException;
xporter.Export(grid,filename,WorkbookFormat.Excel2007, options); System.Diagnostics.Process p = new Process(); p.StartInfo.FileName = fileName; p.Start();
i got a NullReferenceException but i don´t get where and why this happens.
all of my objects are set....
what am i doing wrong?
regards
Cloud
Hi Cloud,
On which line is the NullReferenceException occuring? The debugger should tell you where the exception occurs.
The only reason I can see from the code you provided that would cause an exception is the line where you set the DataPresenterExcelExporter equal to the exporter you pull from the Resources collection. That line will return null if it can't find the item you're looking for.
xporter.Export(grid,filename,WorkbookFormat.Excel2007, options);
in this line i get my error...
but it´s not always a NullReferenceException sometimes it is AccessViolenceException...
there i set my DatePresenterExcelReporter.
<Window.Resources> <igExcelExporter:DataPresenterExcelExporter x:Key="excelExporter"></igExcelExporter:DataPresenterExcelExporter> </Window.Resources>.
But it stillt doesn´t work if i use a new instance of the DataPresenterExcelExporter....
How many rows and columns are you trying to export? I'll create a sample to test this. Also which version of NetAdvantage are you using? 11.2? 12.1? 12.2?
not very much... about 20 columns and 20 rows i guess... that´s always different...
i´m using 12.1
I've attached a working sample that exports a grid of 20 columns and 20 rows. Can you run this sample on your machine and let me know if the issue still exists.
Also can you provide the stack trace for the exception you currently have in your project? Please provide the InnerException details as well.