Ex: out of range of valid values. Parameter 'LastColumn'

[Rollergod]

Hello. I`m trying to do something like this:

Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];

for (int i = 1; i < 260; i++)
{
sheet.SetValue(1, i, i.ToString());
}

and has this - Unhandled exception. System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values. (Parameter 'LastColumn')

i`m using free version of FreeSpire.XLS. Do I have any restrictions on columns?

[Rollergod]

Okey , i just have read a documentation and saw that i have a restriction - max 256 columns.. Sad

[Triste.Dai]

Hi,

Thanks for your inquiry.
This is the limitation of our products, free Spire.XLS is limited to 5 sheets per workbook and 200 rows per sheet. This limitation is enforced during reading or writing XLS or PDF files. If your file exceeds the limitation, please upgrade to our latest commercial version (Spire.XLS_13.5.0). We are willing to provide a temporary license (one month free) to help you remove the restrictions and evaluate our commercial version better. If you need it, just let us know.

Best regards,
Triste
E-iceblue support team