PHP_XLSXWriter | Lightweight XLSX Excel Spreadsheet Writer in PHP | Data Visualization library

I try to create with PHP_XLSXWriter an excel file having 2 header (text) lines and numeric values in the following lines. I manage to create from php a file having 1 header line with expected types and styles for heder line and following data lines. This can be open in excel correctly. When I insert from php a second header line (text) with writeSheetRow method, excel displays an warning/error message and suggests to repair the file. When I accept the file to be repaired, file content is then ok (header (2 lines) and numeric data). After saving the file, there is no more warning message when opening the file. Does anybody knows a way to proceed in order to avoid the initiel warning message? Thanks.

More details: The issue is due to the fact that comumns types are defined when writing the header (row 1, with writeSheetHeader method). This determine the column's types of all following lines (from row 2 to ..). In my case row 2 is not a data line. It contains only strings that are second header line. This cause the problem because there is a conflict between the type defined in the header (numeric) and the actual values in the line (sring).

I can't figure out how to set columns width with PHP_XLSXWriter.

I tryed :

SimpleXLSX can not read excel file that generated using PHP_XLSXWriter.

Code of XLSXWriter:

I use PHP_XLSXWriter class to export xlsx from mysql

I am using the PHP_XLSXWriter code to generate an XLSX file. The file is being generated fine, and it open in Excel fine, but I'm using this file to upload to the DHL server to generate shipping orders. Problem is, their service is complaining about an invalid row. The data in that row is actually perfectly fine, and Excel can read it like I mentioned. However, as a test, what I did was I saved the PHP generated spreadsheet as a separate file, which thus made Microsoft Excel save as it's own format. When I uploaded the Microsoft sheet to the DHL server, it then accepted it without any issues.

After doing a hex compare of the two, they were completely different, which has made me believe that the PHP generated XLSX file is using the OpenOffice or LibreOffice format which DHL hasn't utilised.

Is there any way to fix this issue? One idea I have is to just ditch the PHP XLSXWriter functionality and just save the data as a raw text file with tab seperated data (which DHL also accepts).

Here is a short example of the primary function in my code:

$filename = "test.xlsx"; header('Access-Control-Allow-Origin: mysite.com'); header('Content-disposition: attachment; filename="'.XLSXWriter::sanitize_filename($filename).'"'); header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); header('Content-Transfer-Encoding: binary'); header('Cache-Control: must-revalidate'); header('Pragma: public');

I'm using php xlsx writer (https://github.com/mk-j/PHP_XLSXWriter) to create my excel file and try to figure out how to force excel to make a line break.

My source data contains html tags (
) and i want to replace them with the correct formular. The replace function is working but i need how the string needs to be formated to force the break.

The line wrap option at format cells is enabled for the column as shown in the picture below (excel is installed german at the moment - please don't hate me for that)

What i tried so far is using CHAR(10) and CHAR(13) - altough CHAR(13) should be for mac and i am on windows.

I tried the following inputs to get my line break working. Also i tried all of the combinations with \n and \r\n instead of CHAR(10) and CHAR(13)