How to handle Microsoft Excel in Linux Scripting

[envisage]

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

[Thrillhouse]

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

What format is the spreadsheet in? If it's in csv, you can easily do something like this with native Perl (or any other scripting language for that matter) but if it's in one of Microsoft's other proprietary formats it won't be as easy but you can try a Perl module. Take a look at this one.