Excel XLSX export issue

Dear Sir/Madam,

We have successfully integrated the export to excel function and the grid exports successfully, but there is an issue which we dont know how we can resolve and appreciate your assistance.

A string column that begins with 0 such as “000024213” doesnt show the zero’s in excel, this issue in excel would’ve been resolved by adding a quotation mark or ’ in the begining of the field. However we do not want to change the content in the mysql which shows “000024213” however also show the zeros in the excel.

Any ideas please?


This is the known issue but unfortunately it cannot be fixed as this is the default behavior of excel.