rexcelx 

Name

rexcelx : Converts an Excel file to text

Syntax

Usage   : rexcelx <sheet> [<from> <to>] <file.xlsx>

Version : Thu Jul 11 10:36:58 JST 2013

Description

Outputs the specified range of the specified sheet of an Excel file

as a text-based table.

Empty cells are padded with "@" and spaces converted to "_".

Example

Assume the following Excel file "file.xlsx".

  |A B C

===============================

1 |

2 |a2

3 | b3

4 | b4 c4

5 | c5

6 |

7 |

8 |

9 | b9

10| b10

==============================

sheet1/

~~~~~~

Example 1

Output the first sheet of file.xlsx

$ rexcelx 1 file.xlsx

a2 @ @

@ b3 @

@ b4 c4

@ @ c5

@ @ @

@ @ @

@ @ @

@ b9 @

@ b10 @

Example 2

Output range A3 to C5 of the first sheet of file.xlsx

$ rexcelx 1 A3 C5 file.xlsx

@ b3 @

@ b4 c4

@ @ c5

Example 3

Output all cells to the right and below B4 of the first sheet of file.xlsx

$ rexcelx 1 B4 -- file.xlsx

b4 c4

@ c5

@ @

@ @

@ @

b9 @

b10 @

Example 4

Output column C of the first sheet of file.xlsx

$ rexcelx 1 C- C- file.xlsx

c4

c5

Warning

Dates and times are not output as strings, but as floating point numbers with the

date in the integer part and the time in the decimal part.

You can convert this number using different commands.

If you use rexcelx to read an Excel file that was written with wexcelx and was never

opened in Excel, then dates will be output as strings.

Option

-h --help: Displays usage and version.

Installation Information

rexcelx is a shell script. Internally it calls two programs "rexcelx-core"

and "rexcelx-map" that are written in C.

rexcelx, rexcelx-map and rexcelx-core are stored in "/home/TOOL".