![]() |
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Microsoft Security Advisory (947563): Vulnerability in Microsoft Excel Could Allow Re | iBot | Security Advisories (RSS) - Microsoft | 0 | 04-06-2008 04:50 AM |
| S-227: Vulnerabilities in Microsoft Excel (MS08-014) | iBot | Security Advisories (RSS) | 0 | 03-14-2008 02:10 PM |
| Microsoft Security Advisory (921365): Vulnerability in Excel Could Allow Remote Code | iBot | Security Advisories (RSS) - Microsoft | 0 | 12-24-2007 10:00 AM |
| Microsoft Security Advisory (917077): Vulnerability in the way HTML Objects Handle Un | iBot | Security Advisories (RSS) - Microsoft | 0 | 12-24-2007 10:00 AM |
| Reading and Writing from Excel using Unix scripting | AshishK | UNIX and Linux Applications | 3 | 11-09-2007 02:49 AM |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
||||
|
How to handle Microsoft Excel in Linux Scripting
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 |
|
||||
|
Quote:
$ 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. |
| Sponsored Links | ||
|
|