site Search:


 
    All Forums Hot Topics Gallery






how-to block ads


 
Search Topic:
Share Topic
Posting?
Post a:
Post a:
Links: ·How To Get Noticed ·Web Monks FAQ ·Webhosting FAQ ·Posting Code ·How To Post ·Webhosting forum
AuthorAll Replies


johnnyboyct

join:2003-06-11
New Britain, CT
Reviews:
·Comcast

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
Miamisburg, OH
kudos:3

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
New Britain, CT
Reviews:
·Comcast

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
Miamisburg, OH
kudos:3

I presume that "can't" is because of looming year-end festivities?


Monday, 13-Feb 02:15:22 Terms of Use & Privacy | feedback | contact | Hosting by nac.net - DSL,Hosting & Co-lo
over 12.5 years online! © 1999-2012 dslreports.com.
Most commented news this week
Hot Topics