Pandolfo Posted November 21, 2006 Share Posted November 21, 2006 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 More sharing options...
Caesar Posted November 21, 2006 Share Posted November 21, 2006 You may want to rethink the method they are using in regards to the spreadsheets. Even if they have diferent data, a uniform system/format would not only benefit your clients, it would make the code that much easier to code...and likely, much more efficient in it's execution. Link to comment https://forums.phpfreaks.com/topic/27992-php-and-excel/#findComment-128055 Share on other sites More sharing options...
Pandolfo Posted November 21, 2006 Author Share Posted November 21, 2006 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 More sharing options...
Pandolfo Posted November 22, 2006 Author Share Posted November 22, 2006 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.