How to split multiple worksheets into multiple files?

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Shell script for dealing with XLS file with multiple tabs/worksheets

Hey Guys , Recently working on a requirement , i had to deal with XLS file with multiple tabs and the requirement was as below : 1. Convert one XLS file with multiple tabs to multiple CSV files. -- As i was working on MAC , so it was quite easy through APPLESCRIPT to deal with this.But...

2. UNIX for Dummies Questions & Answers

Split and Rename multiple files

3. Shell Programming and Scripting

Split a .csv File into Multiple Files

Hi guys, I have a requirement where i need to split a .csv file into multiple files. Say for example i have data.csv file and i have splitted that into multiple files based on some conditions i.e first file should have 100, last file 50 and other files 1000 each. Am passing the values in...

4. Shell Programming and Scripting

Split file in unix into multiple files

Hi Gurus I have to split the incoming source file into multiple file. File contains some unwanted XML tags also . Files looks like some XML tags FILEHEADERABC 12 -- --- ---- EOF some xml tags xxxFILEHEADERABC 13 -- --- ---- EOF I have to ignore XML tags and only split file...

5. Shell Programming and Scripting

split file into multiple files

Hi, I have a file of the following syntax that has around 120K records that are tab separated. input.txt abc def klm 20 76 . + . klm_mango unix_00000001; abc def klm 83 84 . + . klm_mango unix_0000103; abc def klm 415 439 . + . klm_mango unix_00001043; I am looking for an awk oneliner...

6. Shell Programming and Scripting

Split file into multiple files

Hi I have a file that has multiple sequences; the sequence name is the line starting with '>'. It looks like below: infile.txt: >HE_ER tttggtgccttgactcggattgggggacctcccttgggagatcaatcccctgtcctcctgctctttgctc cgtgaaaaggatccacctatgacctctagtcctcagacccaccagcccaaggaacatctcaccaatttca >M7B_Ho_sap...

7. Shell Programming and Scripting

Split a file into multiple files

Hi, i have a file like this: 1|2|3|4|5| 1|2|8|4|6| Trailer1||||| 1|2|3| Trailer2||| 3|4|5|6| 3|4|5|7| 3|4|5|8| Trailer2||| I want to generate 3 files out of this based on the trailer record. Trailer record string can be different for each file or it may be same for one or two. No...

8. UNIX for Dummies Questions & Answers

split a file into multiple files

Hi All, I have a file ABC.txt and I need to split this file on every 250 rows. And the file name should be ABC1.txt , ABC2.txt and so on. I tried with split command split -l 250 <filename> '<filename>' but the file name returned was ABC.txtaa ABC.txtab. Please...

9. Shell Programming and Scripting

Split a file into multiple files

I have a file ehich has multiple create statements as create abc 123 one two create xyz 456 four five create nnn 666 six four I want to separte each create statement in seperate files

10. UNIX for Advanced & Expert Users

Creating multiple worksheets in CSV file

Hello, I've been tasked with sending 3 types of data (file size, row count, and file name) to a csv file every month for various vendors. I have been asked to put this in one csv or xls file with each vendor being a different tab (or worksheet). Until now, we have been finding and emailing...

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)

Shell Programming and Scripting