Hi Amber,
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.ResetRowColumn(row,
column);
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.
Thanks,
Sridhar.S