10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all
I am new to shell scripting. I need to read the 1st column and last of the excel file in linux environment.
Can some one help me with examples (3 Replies)
Discussion started by: Vigneshj28
3 Replies
2. Shell Programming and Scripting
So I have a file1.txt that is tab delimited:
e.g.
FIELD1 FIELD2 FIELD3 FIELD4 FIELD5
9545641 123 "Neighbor and Labrador,Canada" 54895 'CANADA'
9456465 456 "Neighbor and Labrador,Canada" 54893 'CANADA'
8746512 789 "Neighbor and... (11 Replies)
Discussion started by: dan139
11 Replies
3. Shell Programming and Scripting
Hi All,
I want to read an excel file.
PFA excel, I want to read the cloumn from A to G and the V to AH
starting from Row number 3.
Please help me on this. (7 Replies)
Discussion started by: Abhisrajput
7 Replies
4. Shell Programming and Scripting
I am writing one shell script in which there is one Java program call.
I want to stop execution of shell script ahead of java program if the java program returns 1 .
How to read that value of java program from OS ? (3 Replies)
Discussion started by: ParthThakkar
3 Replies
5. Shell Programming and Scripting
There is a perl scriptwhich will read Excel sheet and create one file(.v) .
Excel sheet:::
A B C D
1 cpu_dailog 2 3 4
Perl will create the file(.v) like thsi :::
assert (cpu_dailog_iso ==2) ;
assert (cpu_dailog_reset ==3);
assert (cpu_dailog_idle... (3 Replies)
Discussion started by: naaj_ila
3 Replies
6. Shell Programming and Scripting
Hi
Need urgent help (2 Replies)
Discussion started by: premp26
2 Replies
7. Programming
i am having a ms excel file which contains 2 columns, I first column i added words, and in second column meaning to the word in the first column. I want to create a dictionary for mobile like nokia or any java based application running mobile. How it can be created as i, dont know the java... (1 Reply)
Discussion started by: Anna Hussie
1 Replies
8. Programming
Dear Folks,
Is there anyone know how to do the group and ungroup cells feature of MS Excel through java.
Please help.
Please find the attachment.I want the code to do something like this. (0 Replies)
Discussion started by: dinesh1985
0 Replies
9. Shell Programming and Scripting
Hi all
I am new to shell scripting.
I need to write a shell script that reads each row of an USER_ID colume in a excel file.
the excel has around 10000 rows of data.
Can someone gives me some example or advice what's best way to do this
thanks (11 Replies)
Discussion started by: tiger99
11 Replies
10. UNIX and Linux Applications
Hi All,
I want to read and write into Excel files.
I want my script to generate the required output directly in the Excel format.
Is it possible through unix scripting or shall I have to use some other language for this purpose?
Waiting for your suggestion.
Thanks in Advance.
... (3 Replies)
Discussion started by: AshishK
3 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)