Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Prakash
1810
Using Infragistics Workbook to write the data to Excel
posted

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.