02-26-2009
Multiple excel files processing on unix
Hi all,
I am faced with a rather unusual problem regarding interaction between NT and UNIX. I am using an ETL (Extract-Transform-Load) tool on unix that has the capability to read .xls files. So, when I FTP an excel (.xls) file from a windows server to unix and attempt to read it with this tool, it works. But, my project requirements state that there might be multiple files to be processed together. I tried to cat multiple xls files into a single xls file on unix and tried to read it using the tool, but it does not work; probably because unix does not recognize this format. So, my problem is, I am not able to merge multiple excel files into a single readable file on unix.
I have a feeling this cannot be done. But I wanted the experienced folks on this forum to confirm the same. I would greatly appreciate any assistance I can receive on this. If any part of my question is not clear, please let me know and I ll explain.
Thanks!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
There is this requirement to create multiple work sheets in an MS Excel file through UNIX.
We normally can create one work sheet in unix by either tab or comma delimiting and appending .xls or .csv to the file name, but can we create multiple work sheets.
Regards,
Puspendu (1 Reply)
Discussion started by: puspendu
1 Replies
2. Shell Programming and Scripting
Hello Everyone,
I am new to scripting and confused with how to do this efficiently. I am trying to use AWK to do this.
I have a lot of files in a folder which has the data of my throughput measurements in two columns i.e. Serial # and Throughput. like this
177.994 847.9
178.996 ... (1 Reply)
Discussion started by: hakim
1 Replies
3. Shell Programming and Scripting
Hi,
I am using Solaris 8. My script outputs 4 .csv files. Currently I am SFTPing the files and creating a new excel file with the 4 files as sheets.
Can anyone suggest ways to do this in UNIX ?
Thanks,
David. (2 Replies)
Discussion started by: libin4u2000
2 Replies
4. UNIX for Dummies Questions & Answers
Helllo UNIX Forum :)
Since I am posting on this board, yes, I am new to UNIX!
I read a copy of "UNIX made easy" from 1990, which felt like a making a "computer-science time jump" backwards ;)
So, basically I have some sort of understanding what the basic concept is.
Problem Description:... (6 Replies)
Discussion started by: Kasimir
6 Replies
5. Shell Programming and Scripting
I have five directories, dir1 to dir5
for each directory, I have all same number-named folders. There are four types of folders, {1..10}, {20..30}, { 40..50}, {60..70}
Now for each types of folder, I will do the same thing, here is the code
for i in {1..5}
do
cd dir$i
mkdir temp1
for... (5 Replies)
Discussion started by: ksgreen
5 Replies
6. Shell Programming and Scripting
Hi,
I have one requirement, create separate files (".csv") from one excel file(xlsx) with multiple sheets. These ".csv" files are my source files. So anybody please suggest me the process.
Thanks in Advance.
Regards,
Harris (3 Replies)
Discussion started by: harris
3 Replies
7. Shell Programming and Scripting
hai i need my single awk script to act on 4 trace files of ns2 and to calculate througput and it should print result from each trace file in a single trace file. i tried with the following code but it doesnt work awk -f awkscript inputfile1 inputfile2 inputfile3 inputfile4>outputfile ... (4 Replies)
Discussion started by: sarathyy
4 Replies
8. Shell Programming and Scripting
I have requirement to write two CSV files to one single excel with multiple sheets.
Data present in the two files should sit in excel as different sheets.
How can we achieve this using shell script?
1.csv 2. csv
1,2,3,4 5,6,7,8
XXXXX YYYYY
Res.excel
1.csv data... (1 Reply)
Discussion started by: duplicate
1 Replies
9. Shell Programming and Scripting
Hello
I have a program cfxfrwb which is designed to remove headers from reports files.
The cfxfrwb is located in the following directory /u01/efin/v40/live/bin
I run the program against a single report file in the temp directory and it does it's job../cfxfrwb... (2 Replies)
Discussion started by: captainrhodes
2 Replies
10. Shell Programming and Scripting
Hello
I posted on here a while ago about processing multiple files within a script.
See original post below:
I have a program cfxfrwb which is designed to remove headers from reports files.
The cfxfrwb is located in the following directory /u01/efin/v40/live/bin
I run the program against... (8 Replies)
Discussion started by: captainrhodes
8 Replies
LEARN ABOUT DEBIAN
spreadsheet::parseexcel::simple
Spreadsheet::ParseExcel::Simple(3pm) User Contributed Perl Documentation Spreadsheet::ParseExcel::Simple(3pm)
NAME
Spreadsheet::ParseExcel::Simple - A simple interface to Excel data
SYNOPSIS
my $xls = Spreadsheet::ParseExcel::Simple->read('spreadsheet.xls');
foreach my $sheet ($xls->sheets) {
while ($sheet->has_data) {
my @data = $sheet->next_row;
}
}
DESCRIPTION
This provides an abstraction to the Spreadsheet::ParseExcel module for simple reading of values.
You simply loop over the sheets, and fetch rows to arrays.
For anything more complex, you probably want to use Spreadsheet::ParseExcel directly.
BOOK METHODS
read
my $xls = Spreadsheet::ParseExcel::Simple->read('spreadsheet.xls');
This opens the spreadsheet specified for you. Returns undef if we cannot read the book.
sheets
@sheets = $xls->sheets;
Each spreadsheet can contain one or more worksheets. This fetches them all back. You can then iterate over them, or jump straight to the
one you wish to play with.
book
my $book = $xls->book;
The Spreadsheet::ParseExcel object we are working with. You can use this if you need to manipulate it in ways that this interface doesn't
allow.
SHEET METHODS
These methods can be called on each sheet returned from $xls->sheets:
has_data
if ($sheet->has_data) { ... }
This lets us know if there are more rows in this sheet that we haven't read yet. This allows us to differentiate between an empty row, and
the end of the sheet.
next_row
my @data = $sheet->next_row;
Fetch the next row of data back.
sheet
my $obj = $sheet->sheet;
The underlying Spreadsheet::ParseExcel object for the worksheet. You can use this if you need to manipulate it in ways that this interface
doesn't allow (e.g. asking it for the sheet's name).
AUTHOR
Tony Bowden
BUGS and QUERIES
Please direct all correspondence regarding this module to:
bug-Spreadsheet-ParseExcel-Simple@rt.cpan.org
COPYRIGHT AND LICENSE
Copyright (C) 2001-2005 Tony Bowden.
This program is free software; you can redistribute it and/or modify it under
the terms of the GNU General Public License; either version 2 of the License,
or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
FOR A PARTICULAR PURPOSE.
SEE ALSO
Spreadsheet::ParseExcel.
perl v5.8.8 2008-03-12 Spreadsheet::ParseExcel::Simple(3pm)