Hi,
I'm facing one weird issue in export excel functionality in XamGrid 10.3, when I do export to excel with new file name, it is saving immediately; but when I replace an existing file then it is taking lot of time to show "Do you want replace" pop up and then it is saving in normal time.
can I know why "Do you want to replace existing file" file popup taking lot of time??
regards,
Kthatik
This post should probably be in the Excel forum.
This post will be move there.
can anyone guide me on this topic, it is taking lot of time making "Export to Excel" functionality unusable, is it a problem with Silverlight or XamGrid?
kthatik.
You didn't mention but it is recommended that you use the SaveFileDialog object when saving a excel file, instead of using the Workbook save method.
This link will help you create the dialog.
http://help.infragistics.com/NetAdvantage/Silverlight/2010.3/CLR4.0/?page=SL_Saving_to_Excel.html
Let me know how you are accomplishing the save.
Thanks for the reply,
Yes, I'm using SaveFileDialog like below:
SaveFileDialog dialog = new SaveFileDialog { Filter = "Excel files|*.xls", DefaultExt = "xls" }; //bool? showDialog = dialog.ShowDialog(); if (dialog.ShowDialog() == true) { Workbook dataWorkbook = new Workbook();
I put a breakpoint also to see where it is taking time, dialog.ShowDialog is taking lot of time when you try to overwrite an existing file; i.e to show normal Windows alert popup to confirm replacing file or not, it is strange but could not find any solution/alternative, I can't ask my users to save everytime into a new file.
thanks,
kthatik
I tried running our samples locally for NetAdvantage Silverlight 2010 Vol. 3, selecting first the Excel samples and then "Exporting to Excel a large set of data".
I ran it twice, creating an xls dataset and then replacing the same dataset. I really saw no delay before the confirmation to replace the file or not popped up.
Could you try the same sample and let me know if you see any delay?