Results 1 to 5 of 5

Thread: converting text to MS Excel

  1. #1
    Join Date
    Apr 2005
    Beans
    94

    converting text to MS Excel

    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.

  2. #2
    Join Date
    Jul 2005
    Location
    Metro DC area, United States
    Beans
    Hidden!

    Re: converting text to MS Excel

    Quote Originally Posted by epb613
    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.

  3. #3
    Join Date
    Oct 2004
    Location
    Pennsylvania
    Beans
    1,698

    Re: converting text to MS Excel

    Quote Originally Posted by epb613
    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/developerwork...rary/l-pexcel/

  4. #4
    Join Date
    Oct 2004
    Location
    53.337,-3.095
    Beans
    363
    Distro
    Ubuntu 9.10 Karmic Koala

    Re: converting text to MS Excel

    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

  5. #5
    Join Date
    May 2005
    Beans
    41

    Re: converting text to MS Excel

    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.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •