|
 
theedj
Right Back At-Cha
Premium
join:2002-12-12
Calgary
clubs: | Re: PHP read excel template? I've never found anything PHP related that can directly handle input from an XLS...I've also had to convert to a CSV. If you're looking to make the template web based, wouldn't it be easier to recreate it online? | |
|
johnnyboyct
join:2003-06-11
Newington, CT
 ·Cox HSI
| Ive found some stuff that works to read or write, but nothing that works well both ways. We have a few REALLY complex sheets and so far the only thing I can do is save it as xml, then customize the xml with data from the app. Its a pain in the ass though.
--
Connecticut Web Design and Development | |
|
 | Shark_615
join:2006-01-17
Pickering, ON
| Re: PHP read excel template? If you are running PHP on a Windows server I believe you can open excel docs naively using COM or something. Its slow and horrible but would probably work.
Outside of that improbably setup there really isn't a way and I have researched it a bit. | |
|
| |
johnnyboyct
join:2003-06-11
Newington, CT | Re: PHP read excel template? Hmmm, any links describing the com thing? I have no clue what to google. | |
|
yock
TFTC
Premium
join:2000-11-21
Fairfield, OH | Let me see if I understand. You have an Excel spreadsheet that you with to open as a web page, modify, and save the modifications back to a web page? You're esentially using Excel as the data back-end for a web application? | |
|
|
|
yock
TFTC
Premium
join:2000-11-21
Fairfield, OH
| Re: PHP read excel template? Excel spreadsheets are limited to 65,535 lines, but I get your point. In all honesty, Excel shouldn't be levereged in this way. Though it is technically capable, it isn't designed for highly complex and/or mission critical financial calculations. I've seen entire accounting departments running on Excel/VBA solutions, but that doesn't make it right.
If you're already producing the input data for this application, why not implement a web application that replaces this spreadsheet entirely? | |
|
| |
johnnyboyct
join:2003-06-11
Newington, CT
·Cox HSI
| Re: PHP read excel template? Well thats the goal, and Ive done 4 of 5 sheets, but the last sheet is a nightmare. Ive recreated 80% of it with ajax and JS, but really its overkill. They cant address the real issues atm so I end up recreating a flawed spreadsheet...
--
Connecticut Web Design and Development | |
|
| | |
yock
TFTC
Premium
join:2000-11-21
Fairfield, OH | Re: PHP read excel template? I presume that "can't" is because of looming year-end festivities? | |
|
|
|
|
|
