Workbook newWorkBook = new Workbook();
worksheet1 = newWorkBook.Worksheets.Add("Sheet1");
worksheet1.Rows[1].Cells[1].Value = "testdssdg";
string testPath = "C://Test.xls";
newWorkBook.Save(testPath);
I am trying to write the Data to Excel int my WCF Layer. My data is huge so I dont want to return the huge data into client(ie Silverlight layer), Instead I want to write the data into excel file. But whenever I am trying to Save the Excel file it is throwing an exception
The type initializer for 'MS.Internal.JoltHelper' threw an exception.
Can you please let me know how to fix this issue.
Hello Prakash,
I tested Exporting to Excel with domain data source, and I have not seen any issues with it. Your code seems to be fine. I am attaching a sample that demonstrates excel export functionality you may use to recreate the issue. Please feel free to modify the sample as you need, and if you reproduce the issue re-attach it here, and I will review it.
Thank you,Sam
Hi,
I have attached my sample here. Can you please check and let me know whats the problem.
Thanks