Damn Small Linux (DSL) Forums

MyDSL Extensions => Apps => Topic started by: jcdq on November 07, 2014, 11:54:27 PM



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