I am using a php library for exporting MySQL data into Excel. One of the columns having 12 digits does not show the 12 digit number (because of excel). Every time I have to format a cell and select a number to view the full 12 digit number. How can I do this programmatically while writing Excel?
1 Answers
You should set autosize so your cells will automatically adjust the width according to the size of data. I'm not sure which library you are using but this can be helpful if you are using PHPSpreadsheet.
https://stackoverflow.com/a/62203840/18078120
If you are using PHPExcel then this might help
Related