Home / ubuntu / Questions / 1269256
Accepted
UnKNOWn
Asked: 2020-08-23 09:02:47 +0800 CST

How to get the data from Libre Office Calc and use it in a bash script?

  • 772

I am Using Ubuntu 20.04.1

I have Libre Office Calc. with two columns working.
I do edit these two columns weekly once..

A   987654320
B   987654321
C   987654322
D   987654323
E   987654324
F   987654325
G   987654326

I need to write a bash script that gets the data from the above two columns and make a text file like below as an example..

BEGIN:VCARD
VERSION:3.0
FN:$(content of column1, row1)
N:$(content of column1,row1)
TEL;TYPE=cell:$(content of column2, row1)
END:VCARD

BEGIN:VCARD
VERSION:3.0
FN:$(content of column1, row2)
N:$(content of column1,row2)
TEL;TYPE=cell:$(content of column2, row2)
END:VCARD

and so on till it finds the content at last existing row
scripts bash libreoffice

1 Answers

  1. Best Answer

    We can get the needed result with two-step process:

    1. we convert spreadsheet to file.txt (really CSV):

      localc --headless --convert-to txt:"Text - txt - csv (StarCalc)" file.ods

    2. use some AWK scripting:

      awk -F, '{
print "BEGIN:VCARD"
print "VERSION:3.0"
print "FN:"$1
print "N:"$1
print "TEL;TYPE=cell:"$2
print "END:VCARD"
print ""
}' file.txt
    • 6