PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Moderator: General Moderators
itsmani1
Forum Regular
Posts: 791 Joined: Mon Sep 29, 2003 2:26 am
Location: Islamabad Pakistan
Contact:
Post
by itsmani1 » Tue Sep 12, 2006 2:56 am
haya..
i want to use excel with php as database can i do so? if i can please tell me how is it possible.
thanks
volka
DevNet Evangelist
Posts: 8391 Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger
Post
by volka » Tue Sep 12, 2006 3:05 am
excel is a
spreadsheet app, not a
database .
Last edited by
volka on Tue Sep 12, 2006 3:06 am, edited 1 time in total.
bob_the _builder
Forum Contributor
Posts: 131 Joined: Sat Aug 28, 2004 12:25 am
Post
by bob_the _builder » Tue Sep 12, 2006 3:06 am
Hi,
Im not aware if you can do that, but u can certinally save your excel doc as csv (comma separated values) and then parse that file thru php.
hth
onion2k
Jedi Mod
Posts: 5263 Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com
Post
by onion2k » Tue Sep 12, 2006 4:54 am
Yes you can. You'll need to use an ODBC connection.
itsmani1
Forum Regular
Posts: 791 Joined: Mon Sep 29, 2003 2:26 am
Location: Islamabad Pakistan
Contact:
Post
by itsmani1 » Wed Sep 13, 2006 4:07 am
How can i read excel file row wise? means i want to read first row and then 2nd row and then 3rd row
Thanks
onion2k
Jedi Mod
Posts: 5263 Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com
Post
by onion2k » Wed Sep 13, 2006 5:39 am
itsmani1 wrote: How can i read excel file row wise? means i want to read first row and then 2nd row and then 3rd row
Using odbc_fetch_row() (or odbc_fetch_object(), odbc_fetch_into(), etc).