How to insert csv in second column only for an horizontal layout

[Javier Bazan]

Another one Larry. Hope I can explain it properly.

I have the following template spreadsheet I want to use to insert text from a csv:

Name;$VALUE
Last Name;$VALUE
Hobby;$VALUE
[...]

There are no headers, I just need to insert the data at column "B2:B5" since column "A2:A5" is the one that explain what the value means. I wont use the rest of the columns either, its sort of an horizontal layout spreadheet.

Is csv2odf capable of doing that and if not can this feature be added once you have some free time? :)

Cheers and thanks again for your support.
Best regards,

[Larry Jordan]

You can do it with the -o option. If I understand, you need to insert one data column into the second template column. The option -o ",1" should do it. That translates to "no data for first column, first data column to second template column."

[Javier Bazan]

Good stuff Larry, I wouldn't have realized about that syntax on the -o flag. I will try now and see if it works. Thanks !!

[Javier Bazan]

Ok so just tried and it worked with v2.06 but it overwrited column's A text with the value I had at A2. I also lost the grey color I had at column A.

This is my template:

http://tinypic.com/view.php?pic=sey6pv&s=9

This is the command I ran:

/csv2odf-2.06/csv2odf -o ",1" test.csv template.xlsx test.xlsx

This is the resulting xlsx:

http://tinypic.com/view.php?pic=2u43mgy&s=9

Any ideas?
Thanks!

[Javier Bazan]

Hey larry, not sure whether u saw my last message on this topic. Just checking :)

Thank you!

[Larry Jordan]

Oops, I did miss that message. I had forgotten the details of the -o option, I remember now it copies the cells on the line where it gets the formatting. That is used to copy formulas.

I think the program is not going to do what you need. Would it be possible to include the labels in the csv file?