logo
Apache Lounge
Webmasters

 


About

Forum Index Downloads Search Register Log in  RSS Apache Lounge
 



Keep Server Online

If you find the Apache Lounge, the downloads and overall help useful, please express your satisfaction with a donation.

or

Bitcoin

A donation makes a contribution towards the costs, the time and effort that's going in this site and building.

Thank You! Steffen

Apache Lounge is not sponsored.

Your donations will help to keep this site alive and well, and continuing building binaries.



Extracting data from an Excel Document???

 
Post new topic   Reply to topic    Apache Forum Index -> Coding & Scripting Corner



View previous topic :: View next topic  
Author Message
kr33



Joined: 19 Sep 2006
Posts: 64
Location: South Africa

PostPosted: Mon 02 Oct '06 14:06    Post subject: Extracting data from an Excel Document??? Reply with quote

Hi Guys,

Is there any way to extract data(values from certain cells in a certain sheet) from an excel document? Thereafter using the extracted values, generate a bar graph to display on a webpage using PHP?

Or any other ways of achieving what i mentioned above? Preferably in PHP
since its a server-sode scripting language and data will be displayed on a users web browser without having to install any additional web components.

ANY HELP WILL BE MUCH APPRECIATED!!!!

Thanks

Quote:
Every man has to go through hell...to reach his paradise
Back to top
sb.net



Joined: 22 Sep 2006
Posts: 120
Location: USA

PostPosted: Mon 02 Oct '06 23:33    Post subject: Reply with quote

You could do it in XML with XSLT.
Back to top
James Blond
Moderator


Joined: 19 Jan 2006
Posts: 6255
Location: Germany, Next to Hamburg

PostPosted: Tue 03 Oct '06 0:19    Post subject: Reply with quote

Haven't test it yet
http://sourceforge.net/projects/phpexcelreader
Back to top
kr33



Joined: 19 Sep 2006
Posts: 64
Location: South Africa

PostPosted: Tue 03 Oct '06 9:29    Post subject: Reply with quote

Thanks guys

Much Appreciated, I need all the help I can get with this, coz i'm developing a website that needs data to be extracted from a excel document and a graph drawn up using the data in it.

Thanks again

Ciao
Back to top
Brian



Joined: 21 Oct 2005
Posts: 209
Location: Puyallup, WA USA

PostPosted: Tue 03 Oct '06 22:04    Post subject: Reply with quote

Is it possible to export the xls as cvs?

If this is the case then parsing just got really easy Smile
Back to top
Jorge



Joined: 12 Mar 2006
Posts: 376
Location: Belgium

PostPosted: Wed 04 Oct '06 10:31    Post subject: Reply with quote

Brian wrote:
Is it possible to export the xls as cvs?

If this is the case then parsing just got really easy Smile


It should be, atleast it works the other way around lol
Back to top


Post new topic   Reply to topic    Apache Forum Index -> Coding & Scripting Corner
Page 1 of 1