code to transfer data from mysql to excel sheet

Reply

•
•
Join Date: Dec 2007
Posts: 8
Reputation: Raghu D is an unknown quantity at this point 
Solved Threads: 0
Raghu D Raghu D is offline Offline
Newbie Poster

code to transfer data from mysql to excel sheet

 
0
  #1
Dec 19th, 2007
hi !
i m new to IT.i want to know ,how the data from a mysql database can be sent to excel sheet...............kindly help me..............thanks
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2007
Posts: 3,761
Reputation: nav33n is a jewel in the rough nav33n is a jewel in the rough nav33n is a jewel in the rough 
Solved Threads: 332
Moderator
Featured Poster
nav33n's Avatar
nav33n nav33n is offline Offline
Senior Poster

Re: code to transfer data from mysql to excel sheet

 
0
  #2
Dec 19th, 2007
If you have phpmyadmin, click on the "export" tab. Select "Microsoft Excel 2000", check the "Save as file" option. Then click on "Go".
Ignorance is definitely not bliss!

*PM asking for help will be ignored*
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2007
Posts: 8
Reputation: Raghu D is an unknown quantity at this point 
Solved Threads: 0
Raghu D Raghu D is offline Offline
Newbie Poster

Re: code to transfer data from mysql to excel sheet

 
0
  #3
Dec 21st, 2007
•
•
•
•
Originally Posted by nav33n View Post
If you have phpmyadmin, click on the "export" tab. Select "Microsoft Excel 2000", check the "Save as file" option. Then click on "Go".

actually,i want to transfer the datas from mysql to jsp when "search" button is clicked.Then if the user likes to take a printout,he should click "print" button.At this moment,the data in the database has to be sent to an excel sheet.Then the user can take print from excel sheet.I completed the first task.I didn't get the idea to perform the second task.....kindly help me...........thank u.........
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Other Threads in the MySQL Forum
Thread Tools Search this Thread



Tag cloud for MySQL
1 agplv3 alfresco api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright court crm data database design developer development distinct dui eliminate email enter enterprise error eudora facebook form foss gnu government gpl greenit groupware hiring hyperic images innerjoins insert ip joebrockmeier join keyword keywords kickfire laptop law legal license licensing linux maintenance managing mariadb matchingcolumns metron microsoft microsoftexchange montywidenius multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opengovernment opensource operand oracle penelope php query referencedesign reorderingcolumns results resultset saas search select sharepoint simpledb sourcecode spotify statement sugarcrm syntax techsupport thunderbird transparency update virtualization
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC