I needed the capability to convert Microsoft Excel spreadsheets sent to my
email account on a Linux system to a form I could work with on that system.
The spreadsheets contain just email addresses that I need to put into
a text file for a mailing list on the Linux email server. I wanted something
simple and straightforward to use. I didn't need a lot of bells and whistles,
just the capability to convert the data in the .xls spreadsheet file to
a text or
Antixls is a small Perl script that can display the information in a spreadsheet in a number of modes, including in ASCII art format, "linear" (unformatted), CSV, and linearly with cell indices, which is the default mode. The antixls Perl program provides a wrapper for Kawai Takanori's Spreadsheet::ParseExcel module.
Help on using the script can be viewed by typing antixls --help.
Usage: antixls [options...] excelfile1 [excelfile2 ...]
--help This help information
--version Show version information
--formatted Display sheets in ASCII-art table
--linear Display sheets in "linear" (unformatted) mode
--csv Display sheets in CSV mode
--indexed Display sheets linearly with cell indices (default)
I wanted to convert the membership spreadsheet to text or CSV format. I found that converting to CSV format with antixls worked, since afterwards I only needed to remove the comma at the end of each line with vi to put the email addresses in the text format I needed of one addres per line. Linear (unformatted) mode would also have worked well. As examples of the output from the program, below I've included the output in the formats the program can use for output. I placed the commands that produced the output above the output. The actual email addresses have, of course, been altered.
./antixls-0.1b.perl --csv Members.xls >Members.csv
./antixls-0.1b.perl --formatted Members.xls >Members.txt
Sheet: 2005_All_Members ================================================================================ |OfficeE-mail | |email@example.com | |1701A@dunbararm.com | |1769B@dunbararm.com | |firstname.lastname@example.org | |email@example.com | |firstname.lastname@example.org |
./antixls-0.1b.perl --indexed Members.xls >Members.indexed
Sheet: 2005_All_Members (0, 0) OfficeE-mail (1, 0) email@example.com (2, 0) 1701A@dunbararm.com (3, 0) 1769B@dunbararm.com (4, 0) firstname.lastname@example.org (5, 0) email@example.com (6, 0) firstname.lastname@example.org
./antixls-0.1b.perl --linear Members.xls >Members.linear
Sheet: 2005_All_Members OfficeE-mail email@example.com 1701A@dunbararm.com 1769B@dunbararm.com firstname.lastname@example.org email@example.com firstname.lastname@example.org