Jump to content

PHP and Excel


Pandolfo

Recommended Posts

Hey everyone,

I am working on a site which includes a page where users can login and view their account balances. The accountants have created an excel spreadsheet for each organization which lists all transactions and other financial data. Unfortunatley, the format of each spreadsheet is slightly different, and often subject to change. I'm trying to find the best way to generate a php script which will parse the spreadsheet and crank out a reasonably good html version of the excel sheet (read-only). If anyone has any ideas about how to best do this, please let me know.

Thanks,

Sam
Link to comment
https://forums.phpfreaks.com/topic/27992-php-and-excel/
Share on other sites

Regarding the re-design of the spreadsheets, i couldn't agree more. I wish that it were possible to standardize everything. But, that would be the tail wagging the proverbial dog.  Has anyone tried PHP-ExcelReader?
[url=http://sourceforge.net/projects/phpexcelreader/]http://sourceforge.net/projects/phpexcelreader/[/url]

It looks promising, but i haven't been able to make it work yet. Any ideas at all would be great.
Thanks,

Sam
Link to comment
https://forums.phpfreaks.com/topic/27992-php-and-excel/#findComment-128069
Share on other sites

I think i may have found what i needed. ExcelXML is a series of scripts (a class really) which displays excel files as html. It works well for basic spreadsheets, and perhaps with a bit of work it may solve the issue completely. I thought someone else might find it useful. A link to the site is listed below. Kudos to the author.

[url=http://xml.h12.ru/]http://xml.h12.ru/[/url]

Thanks!
Link to comment
https://forums.phpfreaks.com/topic/27992-php-and-excel/#findComment-128817
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.