txt2xls

From: Michele Simionato (michele.simionato_at_gmail.com)
Date: 08/31/04 

Date: 31 Aug 2004 05:01:20 -0700

In would like to convert very simple text files into .xls
files and I need some help.

Here is the format of a typical file:

# begin table.txt

This should go in the first row,
first column.

This should go in the first row,
second column.

====

This should go in the second row,
first column.

This should go in the second row,
second column.

====

This should go in the third row,
first column.

This should go in the third row,
second column.

# end table.txt

"====" separates different rows, whereas different colums are separated
by an empty line. table.txt should be converted into a table.xls
file containing a 3x2 table like this:

   ================================ ================================
   This should go in the first row, This should go in the first row,
   first column. second column.
   -------------------------------- --------------------------------
   This should go in the second row, This should go in the second row,
   first column. second column.
   -------------------------------- --------------------------------
   This should go in the third row, This should go in the third row,
   first column. second column.
   ================================ ================================

I use OpenOffice on Linux, but I have no experience at all about the .xls
format, so I would welcome help/pointers and especially snippets of code ;)
TIA,

                  Michele Simionato

Relevant Pages

  • Re: txt2xls
    ... > This should go in the first row, ... > first column. ... > This should go in the second row, ... > This should go in the third row, ...
    (comp.lang.python)
  • Re: Averaging previous cells
    ... (remove nothere from the email address if mailing direct) ... > the second row and the first row, the third row will be the average of ... > the first second and third row. ...
    (microsoft.public.excel)
  • Re: Murphy for Matrices
    ... first row 1,2,3,4 ... second row 1,2,4,8 ... third row 2,3,5,7 ... fourth will be totally random, just to be safe 1,-1,0,1 ...
    (sci.math)
  • Fill Handle Capabilities
    ... In the first row I ... typed C1, second row C2, third row C3, etc. ... Does Word have fill handle capabilities? ...
    (microsoft.public.word.docmanagement)
  • Re: Combining information from rows
    ... do you always have the key in first column? ... in the second row, and his affiliation is in the third row. ...
    (microsoft.public.excel.worksheet.functions)