|103459||May 4,2012 01:46 AM||May 14,2012 04:33 AM||Windows Forms||5|
Thank you so much for the update.
Essential XlsIO, does not support to write the array of values to an Entire row without the loop. However, while looping through the cells we have an optimal method "IMigrantRange interface" for writing the strings with better performance.
We have given below the sample code snippet for the same.
Code Snippet [C#]:
IMigrantRange migrantRange = sheet.MigrantRange;
// Writing Data.
for (int row = 1; row <= rowCount; row++)
for (int column = 1; column <= colCount; column++)
// Writing values.
migrantRange.Text = "Test";
Please try the above code snippet and let us know if this helps you.
Also, please go through the following online documentation link for improving the performance while creating the excel reports.
Please let me know if you require any further clarifications.
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.