PHP RSS PHP RSS

Form to Excel

Reply

•
•
Join Date: Jul 2009
Posts: 34
Reputation: NoID is an unknown quantity at this point 
Solved Threads: 0
NoID NoID is offline Offline
Light Poster

Form to Excel

 
0
  #1
Jul 24th, 2009
Hello Guys,

I would like to know if its possible to have a form with four felds which when i press submit it stores the details to database and then excel or directly to excel, iv been searching around, and couldnt find much information, so would apericiate so help. Or if someone could give me a link to a tutorial.

Thank you
Reply With Quote Quick reply to this message  
•
•
Join Date: Oct 2006
Posts: 957
Reputation: ardav will become famous soon enough ardav will become famous soon enough 
Solved Threads: 126
ardav's Avatar
ardav ardav is offline Offline
Posting Shark

Re: Form to Excel

 
0
  #2
Jul 24th, 2009
somebody on daniweb recently did a thing with php/excel with COM. I think you need to be running IIS, but I may be wrong. Search the last 4 days for posts on this.
"...the woods would be a very silent place if no birds sang except for the best"
All opinions count.
F'enw i yw Mr. Blaidd. Byddwch yn ofalus - dwi'n cnoi.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jan 2009
Posts: 1,321
Reputation: almostbob has a spectacular aura about almostbob has a spectacular aura about 
Solved Threads: 161
almostbob's Avatar
almostbob almostbob is offline Offline
Nearly a Posting Virtuoso

Re: Form to Excel

 
0
  #3
Jul 24th, 2009
if only the data is important, the structure of the file constant,
mysql/php export the data as csv which excel can import and read as data
without fussing with .xls format
if the structure of the file is important, for calculated fields, a 'blank' .xls for download and then import the same comma separated values into it

If you need a lockdown .xls file try http://www.phpclasses.org/browse/package/3995.html
Failure is not an option It's included free
If at first you dont succeed, join the club
Of course its always in the last place you look, you dont keep looking after you find it

Please mark solved problems, solved
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2009
Posts: 34
Reputation: NoID is an unknown quantity at this point 
Solved Threads: 0
NoID NoID is offline Offline
Light Poster

Re: Form to Excel

 
0
  #4
Jul 24th, 2009
Thank you guys for the help so far, i have been able to click on export and then "Microst Excel 2000" which has done what i want, but when i try to mail merge it just gives me an error, can someone please help, please note that i have found a tutorial but its not exactly what i want to thank you so far.
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2007
Posts: 596
Reputation: buddylee17 has a spectacular aura about buddylee17 has a spectacular aura about 
Solved Threads: 125
buddylee17's Avatar
buddylee17 buddylee17 is offline Offline
Posting Pro

Re: Form to Excel

 
0
  #5
Jul 24th, 2009
http://www.dreamincode.net/forums/showtopic10132.htm
This tutorial is easy to follow and will teach you how to write a tab delimited text file with a xls extension in php. It uses basic php text file functions such as fopen and fwrite.
Lost time is never found again.
- Benjamin Franklin
Reply With Quote Quick reply to this message  
•
•
Join Date: Sep 2008
Posts: 212
Reputation: chrishea is an unknown quantity at this point 
Solved Threads: 32
chrishea's Avatar
chrishea chrishea is online now Online
Posting Whiz in Training

Re: Form to Excel

 
0
  #6
Jul 24th, 2009
I think that you can use my little desktop_write routine to produce your excel file.

http://innovationsdesign.net/wb_2.7/.../downloads.php
Chris
See my list of PHP development tools at:
InnovationsDesign.net
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2009
Posts: 31
Reputation: ctyokley is an unknown quantity at this point 
Solved Threads: 0
ctyokley ctyokley is offline Offline
Light Poster

Re: Form to Excel

 
0
  #7
Jul 24th, 2009
Are you wanting to do it via a website or inside excel itself?
I know that if you press some alt and function key or somethign, you can insert vb6 code inside excel. This also includes created forms. If done correctly you can load the form and it inserts the code inside the table.-- how its done, i couldnt' tell you
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2009
Posts: 34
Reputation: NoID is an unknown quantity at this point 
Solved Threads: 0
NoID NoID is offline Offline
Light Poster

Re: Form to Excel

 
0
  #8
Jul 25th, 2009
Hello Guys.

Thank you for replying back, what i need is 3 fields which are

Name
Age
Location

And when i fill this in, it stores the data to mysql database, which i know how to do,


But then i want to go to convertphptoexcel.php which then converts all the feilds and information to excel so i can download the file and open it so i can do mailmerge.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jan 2009
Posts: 1,321
Reputation: almostbob has a spectacular aura about almostbob has a spectacular aura about 
Solved Threads: 161
almostbob's Avatar
almostbob almostbob is offline Offline
Nearly a Posting Virtuoso

Re: Form to Excel

 
0
  #9
Jul 25th, 2009
•
•
•
•
Originally Posted by NoID View Post
Hello Guys.

Thank you for replying back, what i need is 3 fields which are

Name
Age
Location

And when i fill this in, it stores the data to mysql database, which i know how to do,


But then i want to go to convertphptoexcel.php which then converts all the feilds and information to excel so i can download the file and open it so i can do mailmerge.
If its just for mail merge
output the query that gets the information as comma separated
php Syntax (Toggle Plain Text) 
  1. /* select query for each selected row define file open file for writing*/ {
  2. fput ($file,'/"'.$Name.'/",/"'.$Age'/",/"'.$Location'/"');
  3. }
  4. /* fclose rest of query set file for download*/
every mail merge can handle csv, an excel spreadsheet is unneccessary for the task,
like swatting a fly with an a-bomb

edit. do those "/" point the right way?
Last edited by almostbob; Jul 25th, 2009 at 6:52 am.
Failure is not an option It's included free
If at first you dont succeed, join the club
Of course its always in the last place you look, you dont keep looking after you find it

Please mark solved problems, solved
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:
•
•
•
•



Similar Threads
Other Threads in the PHP Forum
Thread Tools Search this Thread



301 apache api array autosuggest beginner binary broken cakephp checkbox class cms code compression cron curl data database date display dropdownlist dynamic echo email eregi error execution file files folder form forms function functions google href htaccess html httppost if...loop image include insert ip javascript joomla jquery key library limit link links login mail md5 menu mlm multiple mysql mysql_real_escape_string oop paypal pdf pdfdownload php phpvotingscript problem query radio random recursion remote screen script search searchbox server session sessions sms sorting source space sql syntax system table tutorial update upload url validator variable video volume votedown web website youtube zend
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC