Merage the Excel file

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Convert Excel File (xls) to tab delimited text file on AIX

Hi i have a problem in my job i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand cat xxx.xls > xxx.txt Do you have eny idea? PS: sorry for my english Thanks!!

2. 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...

3. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM...

4. Shell Programming and Scripting

Perl script to Merge contents of 2 different excel files in a single excel file

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...

5. Shell Programming and Scripting

Writing excel file using perl : Excel file formatting changed

I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed. What to do...Please...

6. Shell Programming and Scripting

How to convert excel file to csv file or text file?

Hi all, I need to find a way to convert excel file into csv or a text file in linux command. The reason is I have hundreds of files to convert. Another complication is the I need to delete the first 5 lines of the excel file before conversion. so for instance input.xls description of...

7. Shell Programming and Scripting

How to print excel file / csv file in solaris server ?

Hi, I have to print a excel file in solaris server. I am using lexmark printer with post script printer driver . But the problem is when i am using " lp -d <printer name> <somefile name.xls>" command it is not printing correctly. but for pdf file using the same command it printing correctly. ...

8. UNIX for Advanced & Expert Users

Problem in converting password protected excel file to csv file in unix

I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner. I could manually ftp the excel file to local...

9. Shell Programming and Scripting

PERL: Split Excel Workbook to Indiv Excel files

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...

LEARN ABOUT CENTOS

business::isbn::data

Business::ISBN::Data(3) 				User Contributed Perl Documentation				   Business::ISBN::Data(3)

NAME

       Business::ISBN::Data - data pack for Business::ISBN

SYNOPSIS

       see Business::ISBN

DESCRIPTION

       You don't need to load this module yourself in most cases. "Business::ISBN" will load it when it loads.

       These data are generated from the RangeMessage.xml file provided by the ISBN Agency. You can retrieve this yourself at
       <http://www.isbn-international.org/agency?rmxml=1>.  This file is included as part of the distribution and should be installed at
       ~lib/Business/ISBN/RangeMessage.xml.

       If you want to use a different RangeMessage.xml file, you can set the "ISBN_RANGE_MESSAGE" environment variable to the alternate location
       before you load "Business::ISBN". This way, you can use the latest (or even earlier) data without having to install something new or wait
       for an update to this module.

       If the default RangeMessage.xml or your alternate one is not available, the module falls back to data included in Data.pm. However, that
       data is likely to be older data.

       The data are in %Business::ISBN::country_data (although the "country" part is historical). If you want to see where the data are from,
       check $Business::ISBN::country_data{_source}.

SOURCE AVAILABILITY

       This module lives in the Github repository with Business::ISBN:

	       git://github.com/briandfoy/business--isbn.git

       If you have something to add, create a fork on Github and send a pull request.

AUTHOR

       brian d foy, "<bdfoy@cpan.org>"

       Yakov Shafranovich updated the data in October 2008.

       Daniel Jakubik updated the data in July 2012.

COPYRIGHT AND LICENSE

       Copyright (c) 2002-2012, brian d foy, All Rights Reserved.

       You may redistribute this under the same terms as Perl itself.

perl v5.16.3							    2012-07-26						   Business::ISBN::Data(3)

Shell Programming and Scripting