wexcelx 

Name

wexcelx : Merge data into an Excel 2007-2010 report template (xlsx,xlsm)

Syntax

Usage   : Usage   : wexcelx <template.xlsx> <sheet> <pos> <data>

Options :

Version : Mon Jan  6 18:34:22 JST 2014

Description

Pastes field-formatted data into the Excel worksheet template and

creates an Excel file.

Example 1

The following Excel file "file.xls" exists:

  |A    B       C

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

1 |a1

2 |     b2

3 |     b3      c3

4 |             c4

5 |

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

sheet1/

~~~~~~

We prepare the following data:

$ cat data

1 @ 3

@ BC DE

@ represents null data.

By executing the following commands, you create "out.xlsx".

$ wexcelx ./file.xls 1 B2 ./data > out.xlsx

OR

$ cat data | wexcelx ./file.xls 1 B2 - > out.xlsx

If you open "out.xlsx", it looks like this:

  |A    B   C  D

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

1 |a1

2 |     1       3

3 |         BC  DE

4 |             c4

5 |

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

sheet1/

~~~~~~

Example 2

You can also specify the worksheet name.

$ wexcelx ./file.xls sheet1 B2  ./data > out.xlsx #Success!

Caution

Number data with heading "0" is assumed to be "string" type.

"0" itself is assumed to be "number" type.

Data with heading "+" is assumed to be "string" type.

Data with heading "-" is assumed to be "number" type.

Data with heading "'" is assumed to be "string" type.

In this case the heading "'" is stripped automatically.

Warning

If you paste data into a cell that contains a formula, the

worksheet will not be created properly.

Do not input functions into sells where data will be pasted.

Installation Information

wexcelx is a shell script. Internally, it calls wexcelx-core,

which is a program written in C.

wexcelx and wexcelx-core are stored in "/home/TOOL".