Is it possible? Currently, I am inserting data to a CSV file using PHP via the fputcsv() function. When opened in Excel, it works fine. The problem is that all the columns are of the default size. Is there a way to autofit the column width and possibly modify the formatting of the data(font size,color,alignment) in the cells as well?
martin11ph -3 Junior Poster in Training
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
Not while you are using a CSV file. If you use a tool such as PHPExcel, which can generate a real Excel file, then it is possible.
martin11ph -3 Junior Poster in Training
I was afraid of that. Thank you for answering. I have already downloaded PHPExcel and am going to study it for now. Gonna leave the thread open in case there are other suggestions. :)
martin11ph -3 Junior Poster in Training
Oh well I realized PHPExcel is good and useful. I'll just close and suggest it for people who want the same done.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.