Re: Decimating Excel files

2007-02-06 Thread Stephen Eilert
On Feb 5, 11:42 pm, "John Machin" <[EMAIL PROTECTED]> wrote: > On Feb 6, 1:19 pm, gonzlobo <[EMAIL PROTECTED]> wrote: > > > I tried to open the file with Kate, trust me, it's an Excel file. > > Who or what is Kate? In what sense is trying to open it any evidence > that it's an Excel file? Did you *

Re: Decimating Excel files

2007-02-05 Thread Gabriel Genellina
En Mon, 05 Feb 2007 22:31:30 -0300, John Machin <[EMAIL PROTECTED]> escribió: > On Feb 6, 10:46 am, "Gabriel Genellina" <[EMAIL PROTECTED]> wrote: >> I'd try the "xlrd" package - it is capable of reading Excel files on any >> platform. > > Thanks for the plug, Gabriel. However xlrd is not the pa

Re: Decimating Excel files

2007-02-05 Thread John Machin
On Feb 6, 1:19 pm, gonzlobo <[EMAIL PROTECTED]> wrote: > I tried to open the file with Kate, trust me, it's an Excel file. Who or what is Kate? In what sense is trying to open it any evidence that it's an Excel file? Did you *succeed* in opening the file "with Kate"? What is the problem that the

Re: Decimating Excel files

2007-02-05 Thread gonzlobo
I tried to open the file with Kate, trust me, it's an Excel file. I'm using xlrd, it works beautifully (although come to think of it, I haven't tried writing to an .xls file yet... hmmm) > To clear up the doubts, I'd suggest that the OP do something like this > at the Python interactive prompt: >

Re: Decimating Excel files

2007-02-05 Thread John Machin
On Feb 6, 12:27 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > On Feb 5, 5:46 pm, "Gabriel Genellina" <[EMAIL PROTECTED]> wrote: > > > > > En Sat, 03 Feb 2007 18:52:10 -0300, [EMAIL PROTECTED] > > <[EMAIL PROTECTED]> escribió: > > > > On Feb 3, 1:43?pm, gonzlobo <[EMAIL PROTECTED]> wrote: > >

Re: Decimating Excel files

2007-02-05 Thread John Machin
On Feb 6, 10:46 am, "Gabriel Genellina" <[EMAIL PROTECTED]> wrote: > En Sat, 03 Feb 2007 18:52:10 -0300, [EMAIL PROTECTED] > <[EMAIL PROTECTED]> escribió: > > > On Feb 3, 1:43?pm, gonzlobo <[EMAIL PROTECTED]> wrote: > >> We have a data acquisition program that saves its output to Excel's > >> .xls

Re: Decimating Excel files

2007-02-05 Thread [EMAIL PROTECTED]
On Feb 5, 5:46 pm, "Gabriel Genellina" <[EMAIL PROTECTED]> wrote: > En Sat, 03 Feb 2007 18:52:10 -0300, [EMAIL PROTECTED] > <[EMAIL PROTECTED]> escribió: > > > On Feb 3, 1:43?pm, gonzlobo <[EMAIL PROTECTED]> wrote: > >> We have a data acquisition program that saves its output to Excel's > >> .xls

Re: Decimating Excel files

2007-02-05 Thread Gabriel Genellina
En Sat, 03 Feb 2007 18:52:10 -0300, [EMAIL PROTECTED] <[EMAIL PROTECTED]> escribió: > On Feb 3, 1:43?pm, gonzlobo <[EMAIL PROTECTED]> wrote: >> We have a data acquisition program that saves its output to Excel's >> .xls format. Unfortunately, the programmer was too stupid to write >> files the

Re: Decimating Excel files

2007-02-05 Thread Arnd
On 5 Feb., 10:53, greg <[EMAIL PROTECTED]> wrote: > Interesting. But does this mean that "duplicating" is > actually from the wrong root? by definition: roots are never wrong ;) But indeed, you're right, one has to look at the root (eg connected verb) to understand the Numeralia they used: The nu

Re: Decimating Excel files

2007-02-05 Thread greg
Arnd wrote: > Good observation, but as we have numbers of type Cardinalia, > Ordinalia, Distributiva & Multiplicativa in Latin I would prefer > secundating or secondating. (Bisimating or bicimating would multiply > the lines by a factor 2) Interesting. But does this mean that "duplicating" is act

Re: Decimating Excel files

2007-02-04 Thread gonzlobo
Excellent suggestion. I'm going with xlrd! Thanks > I've had good luck with xlrd. It does not require using COM, Excel, or even > Windows! > http://www.lexicon.net/sjmachin/xlrd.htm > Robert Kern -- http://mail.python.org/mailman/listinfo/python-list

Re: Decimating Excel files

2007-02-04 Thread Arnd
> Every other line would be bicimating or something, > wouldn't it? Good observation, but as we have numbers of type Cardinalia, Ordinalia, Distributiva & Multiplicativa in Latin I would prefer secundating or secondating. (Bisimating or bicimating would multiply the lines by a factor 2) ;) Arnd

Re: Decimating Excel files

2007-02-04 Thread jean-michel bain-cornu
Hi, > We have a data acquisition program that saves its output to Excel's > ..xls format. Unfortunately, the programmer was too stupid to write > files the average user can read. > > I'd like some advice on how to go about: > 1. Reading a large Excel file and chop it into many Excel files (with >

Re: Decimating Excel files

2007-02-03 Thread Robert Kern
gonzlobo wrote: > No, I don't want to destroy them (funny how the word 'decimate' has > changed definition over the years) :). > > We have a data acquisition program that saves its output to Excel's > .xls format. Unfortunately, the programmer was too stupid to write > files the average user can r

Re: Decimating Excel files

2007-02-03 Thread Paddy
On Feb 3, 7:43 pm, gonzlobo <[EMAIL PROTECTED]> wrote: > No, I don't want to destroy them (funny how the word 'decimate' has > changed definition over the years) :). > > We have a data acquisition program that saves its output to Excel's > .xls format. Unfortunately, the programmer was too stupid t

Re: Decimating Excel files

2007-02-03 Thread gonzlobo
Yeah, it definitely an Excel file (so says Kate). > Is the file format really native Excel, or is a CSV or TSV file? I've > seen apps (one is a data acquisition program, as a matter of fact) > that create "Excel" files that are just CSV or TSV files. Try opening > the file with a text editor to se

Re: Decimating Excel files

2007-02-03 Thread Phil Schmidt
gonzlobo wrote: > We have a data acquisition program that saves its output to Excel's > .xls format. Unfortunately, the programmer was too stupid to write > files the average user can read. > > I'd like some advice on how to go about: > 1. Reading a large Excel file and chop it into many Excel fil

Re: Decimating Excel files

2007-02-03 Thread greg
gonzlobo wrote: > 2. Decimate an Excel file & write... say every other line (user > selectable)... to a new file. Every other line would be bicimating or something, wouldn't it? -- Greg -- http://mail.python.org/mailman/listinfo/python-list

Re: Decimating Excel files

2007-02-03 Thread gonzlobo
Thanks, but I was looking for a python solution. > Excel has VBA and can do this easily. One thing about > Excel's VBA is that it already understands Excel. -- http://mail.python.org/mailman/listinfo/python-list

Re: Decimating Excel files

2007-02-03 Thread [EMAIL PROTECTED]
On Feb 3, 1:43?pm, gonzlobo <[EMAIL PROTECTED]> wrote: > No, I don't want to destroy them (funny how the word 'decimate' has > changed definition over the years) :). > > We have a data acquisition program that saves its output to Excel's > .xls format. Unfortunately, the programmer was too stupid t

Decimating Excel files

2007-02-03 Thread gonzlobo
No, I don't want to destroy them (funny how the word 'decimate' has changed definition over the years) :). We have a data acquisition program that saves its output to Excel's .xls format. Unfortunately, the programmer was too stupid to write files the average user can read. I'd like some advice o