The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Special Forums > UNIX and Linux Applications
Google UNIX.COM


UNIX and Linux Applications Questions involving software not covered by other forum go here. This includes Databases and Middleware.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
How to handle Microsoft Excel in Linux Scripting envisage Shell Programming and Scripting 2 02-04-2008 10:17 AM
reading data from excel using shell script tiger99 Shell Programming and Scripting 11 01-05-2008 09:35 PM
reading/ writing to sockets rein Shell Programming and Scripting 1 09-20-2007 05:57 PM
Reading and Writing file on LAN lucky001 High Level Programming 3 03-30-2007 11:16 AM
Reading and Writing Files ? tracydp UNIX for Dummies Questions & Answers 3 08-30-2006 07:24 AM

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 10-07-2007
Registered User
 

Join Date: Oct 2007
Posts: 5
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
Reading and Writing from Excel using Unix scripting

Hi All,

I want to read and write into Excel files.

I want my script to generate the required output directly in the Excel format.

Is it possible through unix scripting or shall I have to use some other language for this purpose?

Waiting for your suggestion.

Thanks in Advance.

AshishK
Reply With Quote
Forum Sponsor
  #2 (permalink)  
Old 10-08-2007
sysgate's Avatar
Unix based
 

Join Date: Nov 2006
Location: /root
Posts: 1,073
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
If you "cat" an .xls file, you will notice that unix understand it as binary file, and you won't see relevant content. Instead, you can rely on "comma separated value format" and alter such file. Otherwise, you can use Excel's macros, thus putting yourself in need of writing on Visual basic.
Reply With Quote
  #3 (permalink)  
Old 10-08-2007
Registered User
 

Join Date: Sep 2006
Posts: 1,402
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
Some libraries you can use:
1) if you know Perl, you can look here for some guidance.
2) If you know Python, you can look here
Reply With Quote
  #4 (permalink)  
Old 11-08-2007
SAV SAV is offline
Registered User
 

Join Date: Nov 2007
Location: Russia, Nizhniy Novgorod
Posts: 3
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
if you know Java, you can look here
Reply With Quote
Google UNIX.COM
Reply

Thread Tools
Display Modes




All times are GMT -7. The time now is 04:39 AM.


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

Content Relevant URLs by vBSEO 3.2.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101