Converting Excel file to txt file

[xavierjohndrx]

Hi,

I need to convert an Excel file to txt file.
But I want only few cloumn information in the text file.
For eg.
EXCEL FILE has the below info.

--------Pin No.-----Function_1----Function_2

Row 1---Pin_1-------INPUT---------OUTPUT

Row 2---Pin_2-------OUTPUT--------INOUT

Row 3---Pin_3-------INOUT---------INPUT


Now this is how I want the text file to be

Pin[1][Function_1] = INPUT
Pin[1][Function_1] = OUTPUT
Pin[2][Function_2] = OUTPUT
Pin[2][Function_2] = INOUT
Pin[3][Function_3] = INOUT
Pin[3][Function_3] = INPUT

Can anyone please let me know how to do it. I am very new to Scripting.Your help is greatly appreciated.

Thanks in advance
Regards
John

[RonB]

Spreadsheet::Re ad - Read the data from a spreadsheet
Spreadsheet::Pa rseExcel - Read information from an Excel file.
Spreadsheet::XL SX - Perl extension for reading MS Excel 2007 files;
General CPAN search - parse excel

[xavierjohndrx]

Hy Ron

Can you please be more specific!!!
I am very new to scripting.

Thanks for your understanding!!

Regards
XJL

[xavierjohndrx]

Hi Ron,

Thanks for your input.
I am able run the script with the help of your Links.

Regards
XJL