Ask Your Question
0

Convert CSV to XLS and Define Column Widths

asked 2015-09-10 01:24:46 +0100

m00tpoint gravatar image

Using the headless CLI syntax, I'm able to get multiple CSV files as tabs in a single XLS file, which is great. Unfortunately, the columns in the resulting file are not sized appropriately. Is there some way at the CLI to define the widths of the columns?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2015-09-10 23:34:29 +0100

erAck gravatar image

No.

But what are you referring with "not sized appropriately"?

edit flag offensive delete link more

Comments

The columns are either too narrow for the data or way too wide. There are carriage returns in some of the cells to make the contents more human readable; that may be some or all of the reason. Would be nice to have a CLI/scriptable way to statically define the column widths in the file. Appreciate the reply here; I'll keep working the problem.

m00tpoint gravatar imagem00tpoint ( 2015-09-11 22:00:56 +0100 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2015-09-10 01:24:46 +0100

Seen: 256 times

Last updated: Sep 10 '15