hii guys i was looking forward to creating an excel sheet .. the entries of which shouldf be the data in the database..i already have the data in the database .. juz wanna transfer n display them on the excel sheet... i dont wanna look beyond php for tis task!!!!! please help me out..
nostalgia149 0 Newbie Poster
Recommended Answers
Jump to PostThis questions seems to be asked on a regular basis. I have a little routine that can write an Excel spreadsheet (desktop_write) but if you don't even want to write a program use phpMyAdmin and export to excel.
Jump to PostSorry, your problem isn't clear. If you use either of these approaches, you will get the data in the spreadsheet. If you don't want to actually create a spreadsheet and just want to display a spreadsheet-like screen display of the data, then you are probably looking at using some Ajax. …
All 6 Replies
ajit1984 0 Newbie Poster
You can use mysql database and load them directly to excel..simple and easy way..
chrishea 182 Nearly a Posting Virtuoso
This questions seems to be asked on a regular basis. I have a little routine that can write an Excel spreadsheet (desktop_write) but if you don't even want to write a program use phpMyAdmin and export to excel.
nostalgia149 0 Newbie Poster
i have tried both the two things that u told but all i need as the output is that the data shud appear on the spreadsheet...
chrishea 182 Nearly a Posting Virtuoso
Sorry, your problem isn't clear. If you use either of these approaches, you will get the data in the spreadsheet. If you don't want to actually create a spreadsheet and just want to display a spreadsheet-like screen display of the data, then you are probably looking at using some Ajax. In that case, have a look at jquery
http://www.flexigrid.info/
nostalgia149 0 Newbie Poster
hi chrishea.. actually wht i wanted was that the details of the database should appear in a tabular formwith the rows and columns... is it possible only using php codings..
chrishea 182 Nearly a Posting Virtuoso
Your very first sentence in the first post was
"i was looking forward to creating an excel sheet".
That's why it took a number of posts to get down to what you really need.
If all you want to do is to display (not change) then you can certainly do that with PHP. If you want to generalize it you can query MySQL for the column names and use that to determine how many columns you need and to put the names at the top of each column. Then you can successively read each row and fill in the values. What you will have is a low-end version of phpMySQL browse. As long as you aren't looking for any of the spreadsheet-like features such as colors, calculations or update then no problem.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.