Comments on: Export MySQL Data to Excel using PHP 8 https://www.codexworld.com/export-data-to-excel-in-php/ Web & Mobile App Development Company Wed, 08 Oct 2025 10:00:49 +0000 hourly 1 By: Marco https://www.codexworld.com/export-data-to-excel-in-php/comment-page-1/#comment-260477 Tue, 12 Nov 2024 13:55:54 +0000 https://www.codexworld.com/?p=567#comment-260477 Hi, my question is similar to Philip Beekman’s one: the Class seems to be capable of formatting the cells in many ways.
E.G. I wanted to align a cell content to the right, and I managed to do it, but only after digging in the Class (which I am not good at usually).
Is there any comprehensive documentation summarizing all these possibilities with examples?
The code shown in the YT video tutorial outputs wonderfully formatted cells with proper widths and alignments, but I can’t see any explicit info about how to get that result in the HTML. What (and where) am I missing? 🙂
Thanks!

]]> By: Philip Beekman https://www.codexworld.com/export-data-to-excel-in-php/comment-page-1/#comment-260330 Sun, 10 Nov 2024 00:43:09 +0000 https://www.codexworld.com/?p=567#comment-260330 Your script is nice and works well. Thank you.

Is it possible to add WrapText to a cell or column? It looks like your code is prepaared to do this, Could you give an example?

]]> By: Alessio https://www.codexworld.com/export-data-to-excel-in-php/comment-page-1/#comment-254222 Thu, 27 Jun 2024 06:27:06 +0000 https://www.codexworld.com/?p=567#comment-254222 Hello.
Very well PHPXLSXGENERATOR,
but is possible to orientation page in LANDSCAPE?
Thanks.

Alessio

]]> By: Johan Markus https://www.codexworld.com/export-data-to-excel-in-php/comment-page-1/#comment-248656 Thu, 07 Mar 2024 15:30:27 +0000 https://www.codexworld.com/?p=567#comment-248656 Great script, for excel file writing without any complexity, this script is the best, no dependencies, it just works, and also works great with UTF-8!
Congratulations and thank you!

]]> By: Marco https://www.codexworld.com/export-data-to-excel-in-php/comment-page-1/#comment-242053 Tue, 21 Nov 2023 11:42:22 +0000 https://www.codexworld.com/?p=567#comment-242053 Your class is the FIRST thing that -actually- worked for me, seamlessly dealing with html links and utf-8. So mine is just a BIG “thank you!”

]]> By: dawilly gene https://www.codexworld.com/export-data-to-excel-in-php/comment-page-1/#comment-239683 Fri, 15 Sep 2023 12:35:03 +0000 https://www.codexworld.com/?p=567#comment-239683 Thank you so much for this

]]> By: titus https://www.codexworld.com/export-data-to-excel-in-php/comment-page-1/#comment-239514 Mon, 11 Sep 2023 10:19:05 +0000 https://www.codexworld.com/?p=567#comment-239514 How to white space pre line in excel when export ( data in textarea) please?

]]> By: Siva https://www.codexworld.com/export-data-to-excel-in-php/comment-page-1/#comment-223190 Tue, 29 Nov 2022 04:59:12 +0000 https://www.codexworld.com/?p=567#comment-223190 I am unable to export file extension as .xlsx , it only working to .xls format. Can you please suggest what are changes required to export file as .xlsx format. Thanks in advance

]]> By: alexpiz https://www.codexworld.com/export-data-to-excel-in-php/comment-page-1/#comment-222082 Wed, 16 Nov 2022 04:47:12 +0000 https://www.codexworld.com/?p=567#comment-222082 hi,the code worked for me, but the problems is data limitation, how can i force the code to download all data

]]> By: Ricardo S. https://www.codexworld.com/export-data-to-excel-in-php/comment-page-1/#comment-211309 Mon, 03 Oct 2022 09:25:57 +0000 https://www.codexworld.com/?p=567#comment-211309 Hello,

the export in german xls kills or change the ÖÄÜß to it shows like àhow can i change this to get the öäü back in xls.

]]>