Excel to HTML formatting

Topics: User Forum
Feb 26, 2010 at 12:25 AM
Edited Feb 26, 2010 at 12:51 AM

First I want to say this is an amazing project.  I stumbled upon it and already it's been very exciting to play with.

I have a file that contains three sheets, which have various types of formatting and number formatting.  The worksheet with simple formatting gets output as HTML perfectly.

However, the other two sheets get a little garbled.  To me, they do not look like they have much going on with the formatting but for some reason it doens't turn out right.  Text gets wrapped at weird places, some numbers show up with an asterisk for some reason, and the cells set with number format to "accounting" do not show up correclty.  If I could get over these hurdles I would be extremely happy and our compnay would certainly benefit.

I can upload a dummy Excel file somewhere if somebody could help me I would be very grateful.

Thank you.


Just wanted to add, ver 1.7.2 of PHPExcel, PHP 5.2, Excel 2007. If there is anything else I can provide please let me know.

Mar 2, 2010 at 4:52 AM

With some macros I managed to get some of the formatting correct.  However, now I'm at a point I'm not sure if the problem is my macro or PHPExcel.

http://imgur.com/kTVN2.jpg - Here is how the cells look in Excel

http://imgur.com/xsCFl.jpg - Here is how it looks in HTML.  Some of the numbers seem to get process correctly.


What I'm trying to achieve is a no decimal, no currency symbol accounting format. 

Mar 16, 2010 at 9:13 AM

Can you upload the Excel file, e.g. here so we can look at it ?


Mar 17, 2010 at 1:37 AM

Thanks!  I uploaded the file.