I need a tool that will convert a .xlsx spreadsheet to text (or CSV would be ok).

xls2txt does not appear to be able to handle this format.

I tried xlsx2csv and it complained that my input format was not .xlsx, and I'm sure it is.

I wanted to install gnumeric RPM package to get at the ssconvert utility but there were many missing dependencies.

I need something that runs within a Linux shellscript, so an external utility like Google won't do the trick.

Do I have any other options? My OS is RHEL 5.7.

Thanks,
Sanford Stein
CyberTools Inc.

I'm pretty sure that [Open|Libre]Office can save to csv format. If it's an option, MSOffice certainly can.

What Pixellany said (export as csv from within the tool); also, how did you
If you are using RHEL, use the yum cmd, not rpm... yum automatically handles dependencies for you.

Chris and Pixellany,

Thanks for your responses.

I have tried 'yum install gnumeric' and 'yum install ssconvert' and both report that no such package is available.

Is Open Office available for RHEL as a yum package?

SS

# yum install gnumeric

gnumeric is in the EPEL.repo https://fedoraproject.org/wiki/EPEL
" Extra Packages for Enterprise Linux "
>> http://ftp.crc.dk/fedora-epel/5/i386...5-4.noarch.rpm

# yum install openoffice.org-base : You get version 3.1.1


.

Both 'yum install gnumeric' and 'yum install openoffice.org-base' give me "No package available".

I downloaded the EPEL rpm and attempted to install it and got:

# rpm -i epel-release-5-4.noarch.rpm
warning: epel-release-5-4.noarch.rpm: Header V3 DSA signature: NOKEY, key ID 217521f6
#

So I need some kind of key to install this package?

Thanks,
Sanford Stein
CyberTools Inc.

No. A warning is information. Not an error.
Can be ignored for the package "epel-release-5-4.noarch.rpm"

By trial and error, I finally stumbled on the correct command:

yum install gnumeric.i386

and this gave me the ssconvert utility that I needed.

Respectfully, knudfl, I don't think the rpm install of epel-release-5-4-noarch worked. In any case, it did not install gunmeric or ssconvert.

Thanks to everyone for your responses.

The package "epel-release-5-4-noarch" is mainly a text file:
/etc/yum.repos.d/epel.repo , which allows you to do :

# yum install <epel-packages>

There are about 4,000 EPEL packages for EL5.

.