Heavily formatted excel file

Topics: Developer Forum, User Forum
Jun 5, 2008 at 10:31 AM
Hi,

Thanks for reading. I have a heavily formatted excel file (2003) i need to open, edit and save. I have used the Excel5 reader and writer, but keep getting the following error message on the browser

"Notice: iconv() [function.iconv]: Detected an illegal character in input string in C:\xampp\htdocs\lims\empty_folder1\excel3\Classes\PHPExcel\Writer\Excel5\Worksheet.php on line 1553"

The file is saved, but all original formatting is removed from excel file. I would be really grateful for any help, advice or direction, thanks.

Regards,

Coordinator
Jun 5, 2008 at 8:02 PM
Unfortunately, formatting is currently not supported by the Excel5 reader.
Jun 11, 2008 at 3:49 PM
If it's possible, just save the Excel5 file as an Excel2007 workbook (using MS's compatability pack). PHPExcel could then open it up while still retaining the formatting.
Developer
Aug 18, 2008 at 4:15 AM
Update: Please note that a good deal of style support has been added for the Excel5 reader in the latest source code.