Read excel file exactly same as formatted

[deepaks85]

Dear All,

I want to have a php code to read an excel file exactly thee same as it has formatted (including border, colors, font size, column width, row height, merged rows and columns etc.). The idea is to whatever I make changes in excel it should reflect exactly the same in the browser.

I searched a lot in google but not able to find any solution which gives me the exact solution. Can you please help me in this as I need this for my next project.

Thanks a lot in advance.
Deepak Saxena

[computerfox]

So... you want to rebuild the Excel component of Office 365?
You do know that Microsoft had TEAMS working on that application, right?
Here's the "basic" steps you'd have to take:

1) Rename the Excel file to a zip
2) Unzip the folder
3) Find the xml file that has the content
4) Parse through the xml
5) Decode the formatting.
6) Then you need to find the images if you have images embedded

I'm also sure that the worksheets are stored as separate xml files so you would have to repeat the steps several times.


And then you have to make sure that the browser doesn't download the Excel file

Good luck!

[deepaks85]

Hello I am using https://code.google.com/p/php-excel-reader/ as a library which helps and solved my issue. The only problem is I am not getting any text with Strikethrough text formatting.

Can you please help me in this.

Many Thanks in advance.