10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all i am very new to shell scripting and need some help from you to learn
1)i have some log files that gets generated on daily basis example: i have abc_2017_01_30_1.log ,2017_01_30_2.log like wise so i want to zip this 4 logs which are created on same date into one zip folder.
2)Post zipping... (1 Reply)
Discussion started by: b.saipriyanka
1 Replies
2. UNIX for Beginners Questions & Answers
Hi all i am very new to shell scripting and need some help from you to learn
1)i have some log files that gets generated on daily basis example: i have abc_2017_01_30_1.log ,2017_01_30_2.log like wise so i want to zip this 4 logs which are created on same date into one zip folder.
2)Post zipping... (2 Replies)
Discussion started by: b.saipriyanka
2 Replies
3. Shell Programming and Scripting
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies
4. Shell Programming and Scripting
Hi
I have a requirement in unix shell where I need to zip multiple files on server to one single .zip file. I dont see zip command in AIX and gzip command not doing completely what I want.
One I do .zip file, I should be able to unzip in my local Computer.
Here is example what I want... (9 Replies)
Discussion started by: RAMA PULI
9 Replies
5. Shell Programming and Scripting
We need to redirect the output of a query to .csv file each containing a specified number of lines.Then we should zip these files and send as attachment using mutt command.
We tried using
split -l 500 query_output.txt outputfile
Since we are not sure about the exact number of files... (0 Replies)
Discussion started by: Jassz
0 Replies
6. Shell Programming and Scripting
I am getting an xls file in the dir errorpath. I would like to zip it. Kindly help me on this.
The code is as below.
sqllst=$errorpath/$run_pgm.${date_stamp}".xls" sqlstatus=$errorpath/$run_pgm"."${date_stamp}".sqlstatus" sqlscript=$binpath"/im_rpt.sql" (2 Replies)
Discussion started by: Nithin
2 Replies
7. AIX
I have to zip many pdf files and the size of zip file must not exceed 200 MB. When size is more than 200 MB then multiple zip files needs to be created.
How we can achieve this in UNIX?
I have tried ZIP utility but it takes a lot of time when we add individual pdfs by looping through a... (1 Reply)
Discussion started by: tom007
1 Replies
8. UNIX for Advanced & Expert Users
Hi All,
Currently i am using below script to attach excel and email from a Unix script.
uuencode ASC.xls|mailx -m -s "ABCD_subject`TZ=CST+24 date +%d-%b-%y`" email@email.com
Can anyone give me or help me in zipping excel and sending that email as the excel is very heavy.
Thanks, (14 Replies)
Discussion started by: Nithin
14 Replies
9. Shell Programming and Scripting
Hi,
I am trying to find a way to read an excel work book with multiple worksheets.
And write each worksheet into a new excel file using perl. My environment is Unix.
For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies
10. UNIX for Dummies Questions & Answers
Hello,
I am trying to return the name of the resulting file from a .zip archive file using unix unzip command.
unzip c07212007.cef7081.zip
Archive: c07212007.cef7081.zip
SecureZIP for z/OS by PKWARE
inflating: CEP/CEM7080/PPVBILL/PASS/G0063V00
I used the following command to unzip in... (5 Replies)
Discussion started by: oracledev
5 Replies
Bio::SeqIO::excel(3pm) User Contributed Perl Documentation Bio::SeqIO::excel(3pm)
NAME
Bio::SeqIO::excel - sequence input/output stream from a
MSExcel-formatted table
SYNOPSIS
#It is probably best not to use this object directly, but
#rather go through the SeqIO handler system. Go:
$stream = Bio::SeqIO->new(-file => $filename, -format => 'excel');
while ( my $seq = $stream->next_seq() ) {
# do something with $seq
}
DESCRIPTION
This class transforms records in a MS Excel workbook file into Bio::Seq objects. It is derived from the table format module and merely
defines additional properties and overrides the way to get data from the file and advance to the next record.
The module permits specifying which columns hold which type of annotation. The semantics of certain attributes, if present, are pre-
defined, e.g., accession number and sequence. Additional attributes may be added to the annotation bundle. See Bio::SeqIO::table for a
complete list of parameters and capabilities.
You may also specify the worksheet from which to obtain the data, and after finishing one worksheet you may change the name to keep reading
from another worksheet (in the same file).
This module depends on Spreadsheet::ParseExcel to parse the underlying Excel file.
FEEDBACK
Mailing Lists
User feedback is an integral part of the evolution of this and other Bioperl modules. Send your comments and suggestions preferably to one
of the Bioperl mailing lists. Your participation is much appreciated.
bioperl-l@bioperl.org - General discussion
http://bioperl.org/wiki/Mailing_lists - About the mailing lists
Support
Please direct usage questions or support issues to the mailing list:
bioperl-l@bioperl.org
rather than to the module maintainer directly. Many experienced and reponsive experts will be able look at the problem and quickly address
it. Please include a thorough description of the problem with code and data examples if at all possible.
Reporting Bugs
Report bugs to the Bioperl bug tracking system to help us keep track the bugs and their resolution.
Bug reports can be submitted via email or the web:
https://redmine.open-bio.org/projects/bioperl/
AUTHOR - Hilmar Lapp
Email hlapp at gmx.net
APPENDIX
The rest of the documentation details each of the object methods. Internal methods are usually preceded with a _
new
Title : new
Usage : $stream = Bio::SeqIO->new(-file => $filename, -format => 'excel')
Function: Returns a new seqstream
Returns : A Bio::SeqIO stream for a MS Excel format
Args : Supports the same named parameters as Bio::SeqIO::table,
except -delim, which obviously does not apply to a binary
format. In addition, the following parameters are supported.
-worksheet the name of the worksheet holding the table;
if unspecified the first worksheet will be
used
worksheet
Title : worksheet
Usage : $obj->worksheet($newval)
Function: Get/set the name of the worksheet holding the table. The
worksheet name may also be a numeric index.
You may change the value during parsing at any time in
order to start reading from a different worksheet (in the
same file).
Example :
Returns : value of worksheet (a scalar)
Args : on set, new value (a scalar or undef, optional)
close
Title : close
Usage :
Function: Close and/or release the resources used by this parser instance.
We override this here in order to free up the worksheet and
other related objects.
Example :
Returns :
Args :
Internal methods
All methods with a leading underscore are not meant to be part of the 'official' API. They are for use by this module only, consider them
private unless you are a developer trying to modify this module.
_worksheet
Title : _worksheet
Usage : $obj->_worksheet($newval)
Function: Get/set the worksheet object to be used for accessing cells.
Example :
Returns : value of _worksheet (a Spreadsheet::ParseExcel::Worksheet object)
Args : on set, new value (a Spreadsheet::ParseExcel::Worksheet
object or undef, optional)
_next_record
Title : _next_record
Usage :
Function: Navigates the underlying file to the next record.
We override this here in order to adapt navigation to data
in an Excel worksheet.
Example :
Returns : TRUE if the navigation was successful and FALSE
otherwise. Unsuccessful navigation will usually be treated
as an end-of-file condition.
Args :
_get_row_values
Title : _get_row_values
Usage :
Function: Get the values for the current line (or row) as an array in
the order of columns.
We override this here in order to adapt access to column
values to data contained in an Excel worksheet.
Example :
Returns : An array of column values for the current row.
Args :
perl v5.14.2 2012-03-02 Bio::SeqIO::excel(3pm)
