Damn Small Linux (DSL) Forums
Welcome, Guest. Please login or register.
May 30, 2023, 01:18:17 AM

Login with username, password and session length
News
The new DSL forums are now open.
Stats
11609 Posts in 311 Topics by 291 Members
Latest Member: mik3ca
Search:     Advanced search
* Home Help Search Login Register
Get The Official Damn Small Linux Book. Great VPS hosting provided by Tektonic

+  Damn Small Linux (DSL) Forums
|-+  MyDSL Extensions
| |-+  Apps
| | |-+  get values of specific cell in spreadsheet		 « previous next »
Pages: [1] Print
Author Topic: get values of specific cell in spreadsheet  (Read 11325 times)
jcdq
Newbie
*
Posts: 41


View Profile
« 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?
Logged
fatmac
Newbie
*
Posts: 32



View Profile
« Reply #1 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.
Logged
Linux since 1999
A good general beginners book for Linux :- http://rute.2038bug.com/index.html.gz (http://rute.2038bug.com/index.html.gz)
A good Debian read :- http://debian-handbook.info/get/now/ (http://debian-handbook.info/get/now/)
jcdq
Newbie
*
Posts: 41


View Profile
« Reply #2 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! Grin
Logged
Pages: [1] Print 
« previous next »
Jump to:  

Powered by SMF 1.1.20 | SMF © 2013, Simple Machines
Mercury design by Bloc