422,904 Members | 991 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 422,904 IT Pros & Developers. It's quick & easy.

Read excel file exactly same as formatted

100+
P: 114
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
Jun 1 '15 #1
Share this Question
Share on Google+
2 Replies


computerfox
100+
P: 278
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!
Jun 2 '15 #2

100+
P: 114
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.
Jul 7 '15 #3

Post your reply

Sign in to post your reply or Sign up for a free account.