created excel cuts Rows number

[cowenDkrug]

Support,

OS: Windows 10 Enterprise
: .Net framework 4.7.2

We have licensed Spire.XLS Pro Edition Version:9.7 and when we generate the xls file by using the Spire.XLS in console .net application: using code below:
wk.SaveToFile(targetFileName, Spire.Xls.FileFormat.Version2016);
the generated file has only 65535 rows out of 77405 Is there an limitation to 65535 rows for our version ?


but when we use the the same code in .net web application using the code below:
System.IO.MemoryStream stream = new System.IO.MemoryStream();
wk.SaveToStream(stream, Spire.Xls.FileFormat.Version2016);
Byte[] binaryDataArray = stream.ToArray();

Response.ClearHeaders();
Response.BufferOutput = true;
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Buffer = true;
Response.ContentType = "application/excel;";
Response.AddHeader("content-disposition", $"attachment;filename=DirectBillingReport_{DateTime.Now.Date}.xlsx");
Response.BinaryWrite(bynaryDataArray);
Response.End();

it generates rows number correctly.

[Ula.wang]

Hi，

Thank you for your inquiry.
Please kindly note that our product strictly follow Microsoft specifications. When saving your test document in .xls format, the line limit of every sheet is 65535, and when saving it in .xlsx format, the line limit of every sheet is 1048576. Therefore, please confirm whether result document is saved in .xls format in the console project.
If the message above doesn't help you, please offer the following information to help us do further investigation. Thank you in advance.
1)Your input test file, you can attach here or send it to us via email ([email protected]).
2) Your full test code that can reproduce your issue.
3) Application type, such as Console App, .NET Framework 4.8.
4) Your test environment, such as OS info (E.g. Windows 7, 64-bit).

Sincerely,
Ula
E-iceblue support team

[Ula.wang]

Hello,

Did you solve your problem?
Please feel free to us if you have any problem.

Best Regards,
Ula
E-iceblue support team