knut2 / xlsx2latex Goto Github PK

Set column width to maximum size of the columns.

Problem: This needs a precalcuation to find the largest cell.

Should be easy to implement.

Use require 'roo-xls' and load excel file via Roo::Excel instead of Roo::Excelx.

Adds an additional dependency which may be unneeded if only xlsx is used.

New option -w for width:

xlsx2latex file -w 20

Each column will be 20 characters long

xlsx2latex file -w auto

Each column will be as long as the largest cell

Create a CTAN-entry with

• exe
• readme

No need to add the gem, it is already available at rubygems.
But the gem and the installation should be mentioned.

Examples:

• booktabs
• \hline

Should be possible without bigger problems.

Roo can handle * OpenOffice * Excelx * LibreOffice * CSV

Example:

xlsx2latex source -colA 10s 

Format column A as %10s.

Make no \textbf, \emph for columns.

Use only selected columns for conversion.

Possible interface:

xlsx2latex source --columns A,C,H,F

Defines also a sequence