Results 1 to 4 of 4

Thread: excel into txt

  1. #1
    Join Date
    Nov 2004
    Posts
    35

    Unanswered: excel into txt

    ps: i know i am a bit out of topic.
    i had taken a record out from my db and put it into excel format. now i have sent the file into a unix environment.
    my problem is i have problem reading the excel file as unix don't read .xls.
    so is there any way or tools to convert it into txt form in unix?
    if no how about in windows converting from excel into txt?
    thanks

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    use Excel and store it either as csv or whatever sounds appropriate
    or use open office to convert it

  3. #3
    Join Date
    Nov 2004
    Posts
    35
    it there any tools that do it without much manual work? cos my job are mainly for batch processing. thanks

  4. #4
    Join Date
    Apr 2004
    Location
    Boston, MA
    Posts
    325
    Try catdoc's brother, xls2csv :

    http://www.45.free.net/~vitus/ice/catdoc/

    Also:
    doing it natively on UNIX might be hard.
    I believe perl provide Excell related module:
    Spreadsheet::Writeexcel


    Also I'd suggest browsing USENET [and/or google]:

    http://groups.google.com/groups?hl=e...e+Search&meta=

Posting Permissions

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