writing excel problems

Topics: Developer Forum
Jun 14, 2012 at 7:07 AM

I am having problem to write excel sheet which have columns more then 256. Please help me to find the solutions.

Jun 14, 2012 at 7:35 AM

A BIFF (.xls) file is limited to 256 columns in MS Excel (up to column IV), the limit for OfficeOpenXML files is a lot higher. These are MS Excel restrictions, so the PHPExcel Writer applies that restriction when you save a file.

Jun 14, 2012 at 9:26 AM
Edited Jun 14, 2012 at 10:18 AM

thanks, But is there any solution to write using excel 2007.

Jun 14, 2012 at 3:45 PM
Edited Jun 14, 2012 at 3:45 PM

If you need to write a workbook containing for than 256 columns then you must use the Excel2007 Writer: this is the writer that creates OfficeOpenXML files rather than BIFF files