Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Location
    Bay Area -USA
    Posts
    1,738

    Export to Excel Class?

    Does anyone have a good class that can export information in a database to excel?

    That would be so sweet.
    <<< Please see Forum Guidelines for signature setup. >>>

  2. #2
    Join Date
    Oct 2003
    Posts
    124
    Just create a comma or tab delimited text file and rename the extention to .xls. As long as you don't have any embeddged calculations then it will work fine. It's so easy you don't even need a class. Just write your header and then loop through the database records and match each field to the headers.

  3. #3
    Join Date
    Jul 2003
    Location
    Kuwait
    Posts
    5,099
    Does anyone have a good class that can export information in a database to excel?

    That would be so sweet.
    Hrmm ... how about Spreadsheet_Excel_Writer from the fine folks at PEAR.

    In order to understand recursion, one must first understand recursion.
    If you feel like it, you can read my blog
    Signal > Noise

  4. #4
    Hi,

    You could also use MS-Excel Stream Handler - do a search on google.

    Glosk

Posting Permissions

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