johnnyboyct
join:2003-06-11
Newington, CT
 ·Cox HSI
| reply to johnnyboyct
Re: PHP read excel template?
Not really,
Right now, they use a spreedsheet for this big long project process that consists of about 5 tabs. My app does 4 of 5.
But there's a ton of calculations on the next tab of the sheet that the web app doesn't do.
Id like to read the file with formatting, and calcs, and just fill in the blanks. The only way I have found so far is to:
in excel output the sheet as XML
Regenerate that xml with my blanks filled in
But its like 100000 lines 
--
Connecticut Web Design and Development |
|
yock
TFTC
Premium
join:2000-11-21
Fairfield, OH
| 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
| 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 | I presume that "can't" is because of looming year-end festivities? |
|
