Sponsored Content
Top Forums Shell Programming and Scripting Perl script to extract second column from a xls Post 302446088 by durden_tyler on Tuesday 17th of August 2010 04:50:06 PM
Old 08-17-2010
Try out the Win32::OLE Perl module at CPAN.

Win32::OLE - search.cpan.org

Values in the 2nd column would be: $sheet->Cells($row,2)->{Value}

tyler_durden
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to extract output from a script to .xls file

Hi, I am running a script, the output of which is needed to be filled in .xls file. I am doing this manually now, i mean I am writing the output of the script to Excel file manually. How to redirect the output of the script to .xls file? Please help me out!!! Thanks much, Scriptlearner. (6 Replies)
Discussion started by: scriptlearner
6 Replies

2. Shell Programming and Scripting

extract values from column with Perl

Hi everybody I have some problems with PERL programming. I have a file with two columns, both with numeric values. I have to extract the values > 50 from the 2nd columns and sum them among them. The I have to sum the respective values in the first column on the same line and, at the end, I... (6 Replies)
Discussion started by: m_elena
6 Replies

3. Shell Programming and Scripting

Reading a column from xls file using perl

Hi Everyone! I have a problem in reading a specific column from .xls file using perl language and then manipulating on given criteria. Detailed Description of the problem:: I have one .xls file, in which i have to populate two columns based on Period_date column which is in same file. My... (1 Reply)
Discussion started by: kvth
1 Replies

4. Shell Programming and Scripting

Extract first column from second line in perl

Hello Gurus I have a source file which has the first line as header and the rest are the records I need to extract the first column from the second line to extract a value I/P ... (7 Replies)
Discussion started by: Pratik4891
7 Replies

5. Shell Programming and Scripting

Perl script to get info from specific rows & columns (.xls file)

Hi all, I want to read some specific rows & columns in the .xls file with my script to get the data to be manipulated. Now, I can read the .xls file correctly & i can go to the specific sheet that I want but i have a problem to specify the specific rows & columns. I mean, I want to get the info... (0 Replies)
Discussion started by: Yohannita
0 Replies

6. Shell Programming and Scripting

Perl script to Convert XLSX or XLS files to CSV file

Hi All, I've got in a situation where I need to convert .xlsx or .xls formatted files into simple text file or .csv file. I've found many options but doing this using PERL script is the best way I believe.I'm in AIX box. Perl code should have 2 params while running. i.e perl... (1 Reply)
Discussion started by: manab86
1 Replies

7. Shell Programming and Scripting

Perl regexp to extract first and second column

Hi, I am trying with the below Perl one-liner using regular expression to extract the first and second column of a text file: perl -p -e "s/\s*(\w+).*/$1/" perl -p -e "s/\s*.+\s(.+)\s*/$1\n/" whereas the text file's data looks like: Error: terminated 2233 Warning: reboot 3434 Warning:... (3 Replies)
Discussion started by: royalibrahim
3 Replies

8. Shell Programming and Scripting

Perl script to convert xlsx to xls file

Hi I am trying one perl script to convert xlsx to xls file but could not able to get all the rows and columns in the xls file . This scriptFILE is basically to convert XLSX to CSV .. I am tweaking the script to convert XLSX to XLS file also #######################FILE... (3 Replies)
Discussion started by: kshitij
3 Replies

9. Shell Programming and Scripting

Perl - Extract first column from file

Hi, I want to extract first column from a file and redirect the output to another file in perl. I am able to do this from command line by executing below commands. perl -anle 'print $F' Input.dat > Output.dat perl -ne '@F = split("\t", $_); print "$F\n";' Input.dat > Output.dat perl -anE... (7 Replies)
Discussion started by: Neethu
7 Replies

10. Shell Programming and Scripting

Writing xml from excel sheet .xls using perl script

Hi all. I am working on the below requirement of generating .xml file from .xls file which i have , can someone please help me or in writing the perl script for the same: The xls file format is as below which has two columns and number of rows are not fixed: Fixlet Name ... (12 Replies)
Discussion started by: omkar.jadhav
12 Replies
File::Spec::Native(3pm) 				User Contributed Perl Documentation				   File::Spec::Native(3pm)

NAME
File::Spec::Native - Use native OS implementation of File::Spec from a subclass VERSION
version 1.003 SYNOPSIS
# This serves little purpose on its own but can be useful in some situations # For example: use Path::Class 0.24; # convert foreign file type into native type # without having to know what the current OS is foreign_file(Win32 => $win32_path)->as_foreign("Native"); # or to build a file-spec dynamically (possibly taking the type from input): my $type = get_requested_file_spec(); # can return "Native" foreign_file($type => $file_path); # having $type be "Native" is an alternative to having to do: my $file = $type ? foreign_file($type, $file_path) : file($file_path); DESCRIPTION
This module is a stupid hack to make the default File::Spec behavior available from a subclass. This can be useful when using another module that expects a subclass of File::Spec but you want to use the current, native OS format (automatically detected by File::Spec). For example: "as_foreign" in Path::Class (as of version 0.24) allows you to translate a Path::Class object from one OS format to another. However, there is no way to specify that you want to translate the path into the current, native OS format without guessing at what that format is (which may include peeking into @File::Spec::ISA). This module @ISA File::Spec. SEE ALSO
o File::Spec o Path::Class o <https://rt.cpan.org/Ticket/Display.html?id=49721> SUPPORT
Perldoc You can find documentation for this module with the perldoc command. perldoc File::Spec::Native Websites The following websites have more information about this module, and may be of help to you. As always, in addition to those websites please use your favorite search engine to discover more resources. o Search CPAN The default CPAN search engine, useful to view POD in HTML format. http://search.cpan.org/dist/File-Spec-Native <http://search.cpan.org/dist/File-Spec-Native> o RT: CPAN's Bug Tracker The RT ( Request Tracker ) website is the default bug/issue tracking system for CPAN. http://rt.cpan.org/NoAuth/Bugs.html?Dist=File-Spec-Native <http://rt.cpan.org/NoAuth/Bugs.html?Dist=File-Spec-Native> o CPAN Ratings The CPAN Ratings is a website that allows community ratings and reviews of Perl modules. http://cpanratings.perl.org/d/File-Spec-Native <http://cpanratings.perl.org/d/File-Spec-Native> o CPAN Testers The CPAN Testers is a network of smokers who run automated tests on uploaded CPAN distributions. http://www.cpantesters.org/distro/F/File-Spec-Native <http://www.cpantesters.org/distro/F/File-Spec-Native> o CPAN Testers Matrix The CPAN Testers Matrix is a website that provides a visual overview of the test results for a distribution on various Perls/platforms. http://matrix.cpantesters.org/?dist=File-Spec-Native <http://matrix.cpantesters.org/?dist=File-Spec-Native> o CPAN Testers Dependencies The CPAN Testers Dependencies is a website that shows a chart of the test results of all dependencies for a distribution. <http://deps.cpantesters.org/?module=File::Spec::Native> Bugs / Feature Requests Please report any bugs or feature requests by email to "bug-file-spec-native at rt.cpan.org", or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=File-Spec-Native <http://rt.cpan.org/NoAuth/ReportBug.html?Queue=File-Spec-Native>. You will be automatically notified of any progress on the request by the system. Source Code http://github.com/rwstauner/File-Spec-Native <http://github.com/rwstauner/File-Spec-Native> git clone http://github.com/rwstauner/File-Spec-Native AUTHOR
Randy Stauner <rwstauner@cpan.org> COPYRIGHT AND LICENSE
This software is copyright (c) 2011 by Randy Stauner. This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself. perl v5.14.2 2011-07-14 File::Spec::Native(3pm)
All times are GMT -4. The time now is 01:11 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy