| Author |
|
kr33
Joined: 19 Sep 2006
Posts: 64
Location: South Africa
|
 Posted: Mon 02 Oct '06 14:06 Post subject: Extracting data from an Excel Document??? |
 |
|
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
|
| Posted: Mon 02 Oct '06 23:33 Post subject: |
|
|
| You could do it in XML with XSLT. |
|
| Back to top |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7371
Location: Germany, Next to Hamburg
|
|
| Back to top |
|
kr33
Joined: 19 Sep 2006
Posts: 64
Location: South Africa
|
| Posted: Tue 03 Oct '06 9:29 Post subject: |
|
|
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
|
| Posted: Tue 03 Oct '06 22:04 Post subject: |
|
|
Is it possible to export the xls as cvs?
If this is the case then parsing just got really easy  |
|
| Back to top |
|
Jorge
Joined: 12 Mar 2006
Posts: 376
Location: Belgium
|
| Posted: Wed 04 Oct '06 10:31 Post subject: |
|
|
| Brian wrote: | Is it possible to export the xls as cvs?
If this is the case then parsing just got really easy |
It should be, atleast it works the other way around lol |
|
| Back to top |
|
