<div>
Can the Excel files be saved in CSV format first?<br />
<br />
If not, then either use Spreadsheet::ParseExcel module<br />
<br />
<a href="http://search.cpan.org/dist/Spreadsheet-ParseExcel/lib/Spreadsheet/ParseExcel.pm" rel="ugc">http://search.cpan.org/dist/Spreadsheet-ParseExcel/lib/Spreadsheet/ParseExcel.pm</a><br />
<br />
or if you are on Windows box, you could use Win32::OLE to achieve the same type of thing you could do with VB.
</div>


Can the Excel files be saved in CSV format first?

If not, then either use Spreadsheet::ParseExcel module

http://search.cpan.org/dist/Spreadsheet-ParseExcel/lib/Spreadsheet/ParseExcel.pm [http://search.cpan.org/dist/Spreadsheet-ParseExcel/lib/Spreadsheet/ParseExcel.pm]

or if you are on Windows box, you could use Win32::OLE to achieve the same type of thing you could do with VB.

<div>
can you show me a sample of your excel files. This &nbsp;can be done using &nbsp;Win32::OLE. <br />
I have the code to read excel files. i can modify it according to your needs.<br />
<br />
thank you
</div>


can you show me a sample of your excel files. This  can be done using  Win32::OLE.
I have the code to read excel files. i can modify it according to your needs.

thank you

<div>
The Excel Files can be saved in CSV format.<br />
The sample is:<br />
1st file:<br />
<br />
Branch_no<br />
Line_no<br />
BR_Manager<br />
<br />
2nd File:<br />
<br />
Branch_no<br />
Line_no<br />
BR_city<br />
BR_state<br />
BR_zip<br />
<br />
3rd file:<br />
<br />
Branch_no<br />
Line_no<br />
FName<br />
LName<br />
<br />
I want all the fields from all 3 files and the join columns will be Branch_no and Line_no<br />

</div>


The Excel Files can be saved in CSV format.
The sample is:
1st file:

Branch_no
Line_no
BR_Manager

2nd File:

Branch_no
Line_no
BR_city
BR_state
BR_zip

3rd file:

Branch_no
Line_no
FName
LName

I want all the fields from all 3 files and the join columns will be Branch_no and Line_no


<div>
can you please give some values for the fields so that i can test.<br />
and how big are these excel files.. how many rows?<br />

</div>


can you please give some values for the fields so that i can test.
and how big are these excel files.. how many rows?


<div>
Thanks nedfine,<br />
<br />
This is certainly helping me!!
</div>


Thanks nedfine,

This is certainly helping me!!

<div>
<div class="content wysiwyg-content">
Hello,<br />
I need your urgent help!<br />
I need to pass 3 excel files to a Perl program and need to generate a csv file containing a merged version. I am not really a Perl programmer, but this is the part of my job which I need to complete ASAP. Your help will be highly appreciated.
</div>
</div>


Hello,
I need your urgent help!
I need to pass 3 excel files to a Perl program and need to generate a csv file containing a merged version. I am not really a Perl programmer, but this is the part of my job which I need to complete ASAP. Your help will be highly appreciated.

.XLS to CSV using Perl

A programming language is a formal constructed language designed to communicate instructions to a machine, particularly a computer. Thousands of different programming languages have been created, mainly in the computer field, and many more still are being created every year. The description of a programming language is usually split into the two components of syntax (form) and semantics (meaning). Some languages are defined by a specification document (for example, the C programming language is specified by an ISO Standard), while other languages (such as Perl) have a dominant implementation that is treated as a reference. Some languages have both, with the basic language defined by a standard and extensions taken from the dominant implementation being common.

Programming Languages-Other

Perl is a high-level, general-purpose, interpreted, dynamic programming languages with over 25 years of development. Perl 5 runs on over 100 platforms from portables to mainframes and is suitable for both rapid prototyping and large-scale development projects.  Perl gained widespread popularity as a Common Gateway Interface (CGI) scripting language, in part due to its regular expression and string parsing abilities. In addition to CGI, Perl is used for graphics programming, system administration, network programming, finance, bioinformatics, and other applications.