Title: get values of specific cell in spreadsheet Post by: jcdq on November 07, 2014, 11:54:27 PM Hello, friends:
I have some .xls files. I want to get the value of specific cell, F1 (for example) of all the files and print the results as .csv, .txt. or .gnumeric. Could it be posible with scripts? Title: Re: get values of specific cell in spreadsheet Post by: fatmac on November 09, 2014, 09:40:46 AM Likely you could use an awk script, see man awk. However, I think gnumeric may be able to import your files to work on.
Title: Re: get values of specific cell in spreadsheet Post by: jcdq on November 10, 2014, 03:32:56 AM Thank you, Fatmac!
I read the manual and the page: http://stackoverflow.com/questions/1506521/select-row-and-element-in-awk and you really answer my question! ;D
Powered by SMF 1.1.20 |
SMF © 2013, Simple Machines
|