Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Read excel file using shell script Post 302505304 by cgkmal on Wednesday 16th of March 2011 03:57:21 PM
Old 03-16-2011
Hi hiten.r.chauhan,

I haven't used, but this is a solution for your question:

Here are the references:

The CPAN Search Site - search.cpan.org

http://search.cpan.org/~hmbrand/Spreadsheet-Read-0.41/Read.pm

Converting xls files to csv with xls2csv on Ubuntu - CAP Marketer

Hope it helps.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

editing excel file through shell script

Hi, I am having a business file in excel having charts based on data already present on it. I would like to add new rows after the existing data and refesh the chart on it using shell script. For example-- In excel file in "sheet1", There is some data in first 10 rows ( from column A to F).... (0 Replies)
Discussion started by: sanjay1979
0 Replies

2. Shell Programming and Scripting

how to put data using shell script to a excel file

Hi, Can any one tell me how to put data using shell script to a excel file from text file to other columns of excel file,leaving first column unaffected i.e it should not overwrite data in first column. Say my text file data is: 15-dec-2008 15-dec-2009 16-dec-2008 16-dec-2009 say my first... (1 Reply)
Discussion started by: siri_886
1 Replies

3. UNIX for Advanced & Expert Users

put data in excel file using shell script

Hi. I wish to add data in a specific excel file on daily basis.However the currect dat's data should always come on top i.e for example should always occupy cell A7,B7,C7 .. and the data of day before which was earlier on 7th row of each coloumn should move to 8th row..data on 8th row should... (1 Reply)
Discussion started by: kanus
1 Replies

4. Shell Programming and Scripting

Shell script - Excel/CSV file - More than one tab

Hi All, Following is my requirement. I have searched the site and found some threads which has same queries, but non of them have any answer. I thought of posting it once more. We are generating different reports through shell script after we finish our data load. Currently there are 7 such... (5 Replies)
Discussion started by: ace_friends22
5 Replies

5. UNIX and Linux Applications

Perl Script to read an excel file into an array and search in the UNIX directories

Hi, I want the Perl script with versions 5.8.2 and 5.8.5 starting with #!/usr/bin/perl The Perl program should read the excel file or text file line by line and taking into an array and search in the UNIX directories for reference file of .jsp or .js or .xsl with path .The Object names... (2 Replies)
Discussion started by: pasam
2 Replies

6. Shell Programming and Scripting

Shell Script for converting file to Excel or CSV

Hi I have a dat file which has "n" number of columns. The file is delimited. The number of columns keep varying as the file is generated out of DB queries. Could you please help me in writing a script which will generate a XLS or CSV file out of the dat file. (5 Replies)
Discussion started by: Vee
5 Replies

7. Shell Programming and Scripting

Convert excel file to PDF file using shell script

Hi All, Is it possible to convert the excel file to PDF file(Without loosing any format) using unix shell scripting ??? If yes Kindly help me on the code Thanks in advance!!! (5 Replies)
Discussion started by: Balasankar
5 Replies

8. UNIX for Dummies Questions & Answers

How to Create excel file(.csv) using shell script?

Hi, i have shell script which compiles n number of test cases and execute them one by one. i want to create report in excel through script in which two columns namely "test id" and "release".second column have two subcolumns namely compiles and excutes. so i want first column should display test... (15 Replies)
Discussion started by: RamMore123
15 Replies

9. Shell Programming and Scripting

Need help to write a shell script to convert text file to excel file.

Hi Everyone, I want your help to write a script which will take text file as input and on the basis of delimiter ":"script will create excel sheet. Example input: IpAdress:InstanceName:Port:ServerName 10.255.255.1:abc:2232:xyz_abc Output should be an excel sheet like below: Column... (8 Replies)
Discussion started by: akabhinav18
8 Replies

10. Shell Programming and Scripting

Creating an excel file with filters using shell script.

Hi All, I am new to shell scripting. I have made a script that can convert an excel file from cvs file. This excel file contains hundreds of records and i would like the reader to be able to filter. Is it possible to create an excel file with filters? or that functionality has not been... (3 Replies)
Discussion started by: Marvin159875321
3 Replies
SVN::Class::Repos(3pm)					User Contributed Perl Documentation				    SVN::Class::Repos(3pm)

NAME
SVN::Class::Repos - represents the repository of a Subversion workspace SYNOPSIS
use SVN::Class; my $file = svn_file( 'path/to/file' ); my $info = $file->info; my $url = $info->url; print "repository URL is $url "; DESCRIPTION
SVN::Class::URL represents the source repository for a workspace. METHODS
SVN::Class::URL inherits from Rose::URI and SVN::Class. init Override the base Rose::URI method to set some default values in object. AUTHOR
Peter Karman, "<karman at cpan.org>" BUGS
Please report any bugs or feature requests to "bug-svn-class at rt.cpan.org", or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=SVN-Class <http://rt.cpan.org/NoAuth/ReportBug.html?Queue=SVN-Class>. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes. SUPPORT
You can find documentation for this module with the perldoc command. perldoc SVN::Class You can also look for information at: o AnnoCPAN: Annotated CPAN documentation http://annocpan.org/dist/SVN-Class <http://annocpan.org/dist/SVN-Class> o CPAN Ratings http://cpanratings.perl.org/d/SVN-Class <http://cpanratings.perl.org/d/SVN-Class> o RT: CPAN's request tracker http://rt.cpan.org/NoAuth/Bugs.html?Dist=SVN-Class <http://rt.cpan.org/NoAuth/Bugs.html?Dist=SVN-Class> o Search CPAN http://search.cpan.org/dist/SVN-Class <http://search.cpan.org/dist/SVN-Class> ACKNOWLEDGEMENTS
I looked at SVN::Agent before starting this project. It has a different API, more like SVN::Client in the SVN::Core, but I cribbed some of the ideas. The Minnesota Supercomputing Institute "http://www.msi.umn.edu/" sponsored the development of this software. COPYRIGHT
Copyright 2008 by the Regents of the University of Minnesota. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. SEE ALSO
Rose::URI, Path::Class, Class::Accessor::Fast, SVN::Agent, IPC::Cmd perl v5.14.2 2012-01-31 SVN::Class::Repos(3pm)
All times are GMT -4. The time now is 08:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy