Copying data from excel file


Login or Register to Reply

 
Thread Tools Search this Thread
# 1  
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  
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.
Login or Register to Reply

|
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
Hello, I have a file with the below contents : Policy Name: Backup_bkp Policy Type: Catalog_bkp Active: yes Effective date: 08/07/2013 02:02:12 Mult. Data Streams: no Client Encrypt: no Checkpoint: no Policy Priority: ...... Shell Programming and Scripting
11
Shell Programming and Scripting
Script to generate Excel file or to SQL output data to Excel format/tabular format
dani1234
Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM...... Shell Programming and Scripting
6
Shell Programming and Scripting
Shell Script for copying text file to Excel Sheet
hershey
Hi, I want to write a program to copy a log file to Excel sheet. Excel sheet has four columns MethodName , Code , Description, Details and Time. I want to pick these info from text file and put it in excel sheet. here is how the text file looks - 04.17.2014 08:06:12,697...... Shell Programming and Scripting
1
Shell Programming and Scripting
store the table data in excel file
govindts
Hello - I have a below table and i want to extract the data into excel sheet and send to different location. Here is the table structure... SQL> desc t_i1_exportdocs Name Null? Type ----------------------------------------- --------...... Shell Programming and Scripting
11
Shell Programming and Scripting
how to copy data to to excel file
tucs_123
Hi, Can any one tell me how to copy data using shell script to a excel file from text file to other columns of excel file,leaving first column unaffected i.e it should not overwrite data in first column. Say my text file data is: 15-dec-2008 15-dec-2009 16-dec-2008 16-dec-2009 ...... Shell Programming and Scripting
7
Shell Programming and Scripting