List:General Discussion« Previous MessageNext Message »
From:J.R. Bullington Date:September 1 2005 10:12pm
Subject:RE: Populate values in an Excel sheet from MySQL
View as plain text  
Here's a little heads-up, as you will need some XML coding to make it "look
right".

PLEASE NOTE: I'm an ASP programmer, so PHP is a little foreign to me. You
will need to do some conversion.

Here is the way to do it:

1) Define your recordset and connection strings.
2) Write PHP strings to add ContentType (or similar call) =
"application/vnd.ms-excel"
3) (optional) Write PHP echo strings for adding XML tags. (You can find
these at http://msdn.microsoft.com, although I'll be damned if I can find
them now. Ask for them and I will get them from my other computer and send
them on.)


4) In the <body> of your webpage, put the following snippet:

<body>
<table width="100%">
<thead>
	<tr>
		<td>Col 1</td>
		<td>Col 2</td>
		...
		<td>Col end</td>
	</tr>
</thead>
<tbody>
<?PHP Open the records, pull the set 
	'do the loop
	movefirst
		while not eof
?>
	<tr>
		<td><? PHP DATA 1 ?></td>
		<td><? PHP DATA 2 ?></td>
		...
		<td><? PHP DATA end ?></td>
	</tr>
<?PHP Next in loop
Wend
Close
?>
</tbody>
</table>
</body>
</html>



I hope this helps a little!

J.R.

PS - Shawn FYI, if you copy and paste a tab into the replace with in
notepad, you can do it that way...


-----Original Message-----
From: Nick Jones [mailto:nickj6282@stripped] 
Sent: Thursday, September 01, 2005 3:19 PM
To: mysql@stripped
Subject: RE: Populate values in an Excel sheet from MySQL



--- "J.R. Bullington" <bullijr@stripped> wrote:

> Automatically populate??
> 
> Not that _I_ know of, but of course there are those on this list that 
> know much more than I.
> 
> I do know that you can export the values into tab delimited format and 
> then import it into Excel.
> 
> I think that you may want to do this via ASP or PHP.
> It would make life a
> lot easier.
> 
> J.R.

PHP would definitely be the way to go on this. I'm working on a web
application running on our AS/400 here running Apache, PHP, and MySQL to
automate our schedule forms that we fill out daily around here.
Everything I've got so far is running through PHP/MySQL so if I can find a
way to do this in PHP I'm definitely going to try. I'll google around for
awhile and see what I come up with. MS Knowledge Base has proven to be less
than useful so far in my endeavor.

Also, thanks to James for his suggestion on using the ODBC query directly
from Excel. This will get us started for the time being, and give me some
leeway so I can work on doing this in PHP.

Thanks to you both!
-Nick


		
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs 
 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
Thread
• Populate values in an Excel sheet from MySQLNick Jones1 Sep
  • RE: Populate values in an Excel sheet from MySQLJ.R. Bullington1 Sep
    • RE: Populate values in an Excel sheet from MySQLNick Jones1 Sep
      • RE: Populate values in an Excel sheet from MySQLSGreen1 Sep
      • Re: Populate values in an Excel sheet from MySQLPartha Dutta1 Sep
        • Re: Populate values in an Excel sheet from MySQLNick Jones1 Sep
      • RE: Populate values in an Excel sheet from MySQLJ.R. Bullington1 Sep
  • Re: Populate values in an Excel sheet from MySQLJamesDR1 Sep
    • how to design junction table?Siegfried Heintze3 Sep
      • Re: how to design junction table?Gleb Paharenko5 Sep
• RE: Populate values in an Excel sheet from MySQLArjan Hulshoff2 Sep
  • Re: Populate values in an Excel sheet from MySQLinferno2 Sep
    • Re: Populate values in an Excel sheet from MySQL [SOLVED]Nick Jones3 Sep