Re: txt2xls

From: Benjamin Niemann (b.niemann_at_betternet.de)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 14:19:58 +0200

Perhaps this could help you:
http://sourceforge.net/projects/pyxlwriter/

Michele Simionato wrote:

> 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

  • 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)