Copying data from excel file

Tags
excel, file, shell scripts

 
Thread Tools Search this Thread
# 1  
Old 01-29-2009
Copying data from excel file

Hii friends,

I am a newbie to unix/shell scripting and got stuck in implementing a functionality.Dear experts,kindly spare some time to bring me out of dark pit Smilie..
My requirement is somewhat wierd,let me explain what i have and what i need to do...
1) there are several excel workbooks containing multible sheets.say a workbook named test with multiple sheets namely test.1,test.2,test.3....
2) i need to write a shell script that reads the first column of a specified sheet say test.2 and copy it in the first column of a new excel workbook.
3)Then step no. 2 needs to be repeated for other workbooks from where data needs to be copied.

Write now i can just copy data from a workbook having single sheet using the command
cut -f1 -d"," < inputfile | paste -s -d","> destination file

Kindly advise Smilie
# 2  
Old 02-04-2009
Thanks to google, I found this excellent tutorial: Cultured Perl: Reading and writing Excel files with Perl

It uses perl and a module for writing and reading Excel spreadsheets. You'll need to download the module from "CPAN.org". Good luck.

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
Formatting data to put it in the excel file rahul2662 Shell Programming and Scripting 11 09-23-2015 12:25 PM
Script to generate Excel file or to SQL output data to Excel format/tabular format dani1234 Shell Programming and Scripting 6 09-14-2014 02:49 PM
Data formatting in CSV file to EXCEL etldev Shell Programming and Scripting 6 07-23-2014 11:36 AM
Shell Script for copying text file to Excel Sheet hershey Shell Programming and Scripting 1 04-19-2014 08:01 AM
Copying part of a data file into another latsyrc UNIX for Dummies Questions & Answers 8 07-08-2013 07:38 AM
Copying data from one file server to another br1an Solaris 2 05-21-2013 08:36 PM
put data in excel file using shell script kanus UNIX for Advanced & Expert Users 1 06-21-2011 12:19 PM
how to put data using shell script to a excel file siri_886 Shell Programming and Scripting 1 12-22-2010 05:10 AM
Doubt in C programming (copying data from one file to another) Lyric Programming 5 10-12-2010 03:56 PM
urgent<parsing data from a excel file> sayee Shell Programming and Scripting 5 10-31-2009 10:14 PM
store the table data in excel file govindts Shell Programming and Scripting 11 03-11-2009 04:37 PM
how to copy data to to excel file tucs_123 Shell Programming and Scripting 7 12-29-2008 06:24 AM
Help on email data file as excel from unix!! sparan_peddu Shell Programming and Scripting 1 10-19-2008 03:08 AM