How to handle Microsoft Excel in Linux Scripting

Shell Programming and Scripting
1

Hi,

I am having a Excel sheets with 4 columns and 50 rows.
I need a script which check Date columns in excel sheet and then replace few cells with the random number (based on a date check operator).

I then need the excel sheet back to my window system, where is Linux is the remote system.

Thanks

2

save as csv and use awk/perl/sh whatever you know to change the columns

3

hey,

$ cat /tmp/file.txt
NAME ID YEAR
abc 25 1995
ced 34 1977
ttt 43 1983

Create a csv file,which can be opened up in XL,

awk '{print $1","$2","$3}' < /tmp/file.txt > /tmp/file.csv

cat /tmp/file.csv
NAME,ID,YEAR
abc,25,1995
ced,34,1977
ttt,43,1983

Thanks.:b: