Read an excel file in a shell script
Aknot
-
olivier -
olivier -
Bonjour,
Is it possible to extract a specific cell from an Excel file to use in a shell script?
I see two solutions:
- either there are commands that allow extracting a cell from the command line (maybe an Open Office command)
- or by knowing the formatting of an .xls file, we might be able to extract that cell using grep, cat, tr, etc.
Does anyone have a starting point or better yet, the solution?
Thank you.
Is it possible to extract a specific cell from an Excel file to use in a shell script?
I see two solutions:
- either there are commands that allow extracting a cell from the command line (maybe an Open Office command)
- or by knowing the formatting of an .xls file, we might be able to extract that cell using grep, cat, tr, etc.
Does anyone have a starting point or better yet, the solution?
Thank you.
1 answer
A solution:
the file should not be in .xls format as the format is unparseable (neologism?).
which is not the case for the SYLK format (*.slk)
give it a try with an Excel file saved in this format!
this format is readable as a text file with a specific format!
it's up to you to break it down (good luck...)
example of the data part starting with pac C
C;Y1;X1;K"li1co1"
C;Y2;K"li2co2"
C;X2;K"li2co2"
C;Y3;X3;K"li3co3"
between brackets, we find the data of a cell with its X and Y coordinates
which are sometimes omitted...
the file should not be in .xls format as the format is unparseable (neologism?).
which is not the case for the SYLK format (*.slk)
give it a try with an Excel file saved in this format!
this format is readable as a text file with a specific format!
it's up to you to break it down (good luck...)
example of the data part starting with pac C
C;Y1;X1;K"li1co1"
C;Y2;K"li2co2"
C;X2;K"li2co2"
C;Y3;X3;K"li3co3"
between brackets, we find the data of a cell with its X and Y coordinates
which are sometimes omitted...