Hi,
I had to do the same thing on a project and the problem was that if
you use CSV you will not be able to make a formated excel document.
I am using now *Spreadsheet_Excel_Writer
</package/Spreadsheet_Excel_Writer> (
*http://pear.php.net/package/Spreadsheet_Excel_Writer ) and it does
everything I need, including formating the page for printing, color,
bold and boarder on cells and the best part is that it's no really hard
to use.
If you change your mind and want to generate that from perl you also
have some PEAR packages for that, but I've sticked to PHP and with this
the problem was solved and I generate my data on access, custom build
depending on the select.
Best regards,
Cristi Stoica
Arjan Hulshoff wrote:
>Hello Nick,
>
>This you can do with the MySQL ODBC Driver installed
>(http://dev.mysql.com/downloads/connector/odbc/3.51.html). Further more
>you need to activate Microsoft ActiveX Data Objects in the references.
>You can use the following code:
>
><--Begin Code-->
>Dim cn As ADODB.Connection
>Dim rs As ADODB.RecordSet
>
>Set cn = New ADODB.Connection
>Set rs = New ADODB.RecordSet
>
>cn.ConnectionString = "DRIVER={MySQL ODBC 3.51
>Driver};SERVER=data.domain.com;PORT=3306;DATABASE=myDatabase;USER=myUser
>name;PASSWORD=myPassword;OPTION=3;"
>cn.Open
>
>sSQL = "SELECT * FROM database"
>
>rs.Open sSQL, cn
>
>If Not rs.BOF Then rs.MoveFirst
>Do While Not rs.EOF
> Cells(1, 1) = rs.Fields(<index>) ' This line you can
>adjust with your own code
> rs.MoveNext
>Loop
>
>On Error Resume Next ' This is my solution to make sure that the
>recordset is always closed, _
> without the errorhandling there
>occurs an error when you use a query _
> that doesn't return results
>('INSERT' e.g.). If there is a better way _
> to close the connection, then
>let me know.
>If rs.State = adStateOpen Then rs.Close
>On Error Goto 0
>cn.Close
>
>Set rs = Nothing
>Set cn = nothing
><--End Code-->>
>
>HTH,
>Arjan.
>
>-----Original Message-----
>From: Nick Jones [mailto:nickj6282@stripped]
>Sent: Thursday, September 01, 2005 08:23 PM
>To: mysql@stripped
>Subject: Populate values in an Excel sheet from MySQL
>
>Does anyone know if it is possible to populate values into an Excel
>spreadsheet from a MySQL database? Can I do this directly in Excel or do
>I need to create an external program to do the work (i.e. in VB).
>
>Thanks
>-Nick
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam? Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:
>http://lists.mysql.com/mysql?unsub=1
>
>
>
>
>
