Hi,
I'm using Fedora Core 6 Linux. I have this Excel file that I would
like to save to CSV. The problem in the version of Excel I have on my
WinXP machine (2003) is that I can only see 65536 rows and there are
many more than that.
This is a strange request to post to a Unix group, but I've been
surprised before and maybe there's a script out there that does
something like this.
Thanks for your advice, - Dave
On 1/29/2008 6:02 PM, laredotornado wrote:
> Hi,
>
> I'm using Fedora Core 6 Linux. I have this Excel file that I would
> like to save to CSV. The problem in the version of Excel I have on my
> WinXP machine (2003) is that I can only see 65536 rows and there are
> many more than that.
>
> This is a strange request to post to a Unix group, but I've been
> surprised before and maybe there's a script out there that does
> something like this.
>
> Thanks for your advice, - Dave
What is your question?
Ed.
On Tue, 29 Jan 2008 16:02:27 -0800, laredotornado wrote:
> Hi,
>
> I'm using Fedora Core 6 Linux. I have this Excel file that I would like
> to save to CSV. The problem in the version of Excel I have on my WinXP
> machine (2003) is that I can only see 65536 rows and there are many more
> than that.
>
> This is a strange request to post to a Unix group, but I've been
> surprised before and maybe there's a script out there that does
> something like this.
>
> Thanks for your advice, - Dave
You might try saving to CSV from another spreadsheet application like
openoffice calc or gnumeric.
Or if you don't have a huge number of rows, you could save the first 64k
rows, delete the first 64k rows, save the next 64k rows, delete the next
64k rows...
Also, you may be able to convert from excel to openoffice calc's native
format; I believe there are tools for parsing that.
On Jan 29, 9:44=A0pm, Ed Morton
> On 1/29/2008 6:02 PM,laredotornadowrote:
>
> > Hi,
>
> > I'm using Fedora Core 6 Linux. =A0I have this Excel file that I would
> > like to save to CSV. =A0The problem in the version of Excel I have on my=
> > WinXP machine (2003) is that I can only see 65536 rows and there are
> > many more than that.
>
> > This is a strange request to post to a Unix group, but I've been
> > surprised before and maybe there's a script out there that does
> > something like this.
>
> > Thanks for your advice, - Dave
>
> What is your question?
>
> =A0 =A0 =A0 =A0 Ed.
Since I can't use Excel 2003 to view all my rows, is there a way in
Unix to convert my Excel file to CSV?
Dan has a good suggestion witih going the OpenOffice route. I may try
this. - Dave
On 1/29/2008 11:05 PM, laredotornado wrote:
> On Jan 29, 9:44 pm, Ed Morton
>
>>On 1/29/2008 6:02 PM,laredotornadowrote:
>>
>>
>>>Hi,
>>
>>>I'm using Fedora Core 6 Linux. I have this Excel file that I would
>>>like to save to CSV. The problem in the version of Excel I have on my
>>>WinXP machine (2003) is that I can only see 65536 rows and there are
>>>many more than that.
>>
>>>This is a strange request to post to a Unix group, but I've been
>>>surprised before and maybe there's a script out there that does
>>>something like this.
>>
>>>Thanks for your advice, - Dave
>>
>>What is your question?
>>
>> Ed.
>
>
> Since I can't use Excel 2003 to view all my rows, is there a way in
> Unix to convert my Excel file to CSV?
You could try xls2txt (http://wizard.ae.krakow.pl/~jb/xls2txt/). I haven't tried
it myself, just saw it mentioned somewhere, some time...
Ed.
laredotornado
> Since I can't use Excel 2003 to view all my rows, is there a way in
> Unix to convert my Excel file to CSV?
How do you want to "view" your data? If you want to use Excel, then
you have problems because of it's limits. You could split it up into
different files, and let Excel look at pieces of the entire data.
If you want to analyze the data, there are many good programs that can
be used. AWK or perl for instance for the number crunching.
I use grace for 2D plotting.