Problem with multiple sheets in one XLS file

mk-j / PHP_XLSXWriter

Lightweight XLSX Excel Spreadsheet Writer in PHP

MIT License

1.84k stars 665 forks source link

Problem with multiple sheets in one XLS file #364

Open bartsoft opened 2 months ago

bartsoft commented 2 months ago

I have Excel with many sheets. When I create max. 240 pieces, it is ok, when there are more - Excel reports information that it is damaged - please help?

sayid commented 2 months ago

您好，我已经收到您的信件，将尽快回复您。

bartsoft commented 2 months ago

Raport2024-09-16_stacja_2_ON_21.xlsx - OK Raport2024-09-16_stacja_1_ON_71.xlsx -problem

bartsoft commented 2 months ago

I solved the problem. The bull appears in Polish Excel when there is an Integer in the column and the value is above 999, then the sign 1,000 appears and in Poland this is the part after the decimal point, so Excel signals an error - I changed it to String.