PDA

View Full Version : converting text to MS Excel



epb613
August 24th, 2005, 03:28 PM
I wanna write a program that will input data from a user and output it to an Excel spreadsheet file. Does anyone know how to do this? Thanks in advance.

macgyver2
August 24th, 2005, 04:15 PM
I wanna write a program that will input data from a user and output it to an Excel spreadsheet file. Does anyone know how to do this? Thanks in advance.
Excel can handle comma-separated-value (csv) format which isn't hard to do in any language.

cwaldbieser
August 25th, 2005, 02:44 AM
I wanna write a program that will input data from a user and output it to an Excel spreadsheet file. Does anyone know how to do this? Thanks in advance.
If you know some perl, this link might help: http://www-128.ibm.com/developerworks/linux/library/l-pexcel/

davmac
August 25th, 2005, 06:05 PM
Good suggestions already, but as an alternative, how about an OpenOffice macro? Load of info and samples at http://www.ooomacros.org/dev.php.

HTH,

Dave MacLeod

dmccarney
August 26th, 2005, 02:14 AM
ASP does it very very easily, just make an html table and populate it with information from ASP and set the response type to an Excel object. I've had to use it for websites at work before.