The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Google UNIX.COM


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts 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 01:50 AM
S-227: Vulnerabilities in Microsoft Excel (MS08-014) iBot Security Advisories (RSS) 0 03-14-2008 11:10 AM
Microsoft Security Advisory (921365): Vulnerability in Excel Could Allow Remote Code iBot Security Advisories (RSS) - Microsoft 0 12-24-2007 07:00 AM
Microsoft Security Advisory (917077): Vulnerability in the way HTML Objects Handle Un iBot Security Advisories (RSS) - Microsoft 0 12-24-2007 07:00 AM
Reading and Writing from Excel using Unix scripting AshishK UNIX and Linux Applications 3 11-08-2007 11:49 PM

Reply
 
Submit Tools LinkBack Thread Tools Search this Thread Display Modes
  #1  
Old 02-04-2008
Registered User
 

Join Date: Feb 2008
Posts: 1
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
Reply With Quote
Forum Sponsor
  #2  
Old 02-04-2008
Registered User
 

Join Date: May 2006
Posts: 101
save as csv and use awk/perl/sh whatever you know to change the columns
Reply With Quote
  #3  
Old 02-04-2008
Registered User
 

Join Date: Feb 2007
Location: Pune, Dehradun (INDIA), Michigan(US)
Posts: 187
Quote:
Originally Posted by envisage View Post
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
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.
Reply With Quote
Google The UNIX and Linux Forums
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes




All times are GMT -7. The time now is 06:55 AM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008. All Rights Reserved.Ad Management by RedTyger Visit The Complex Event Processing Blog

Content Relevant URLs by vBSEO 3.2.0