Hi all
I am new to shell scripting.

I need to write a shell script that reads each row of an USER_ID colume in a excel file.

the excel has around 10000 rows of data.

Can someone gives me some example or advice what's best way to do this

thanks

I would recommend using a perl script to read EXCEL file.

Modules are readily available in cpan.org

Spreadsheet::ParseExcel - Get information from Excel file - search.cpan.org

Thanks for your reponse matrixmadhan

But I was told to use SH.

Does anyone know how to use SH to read excel data?

Thanks

Who told you?

Excel files are a proprietary binary format not simply CSV files, I strongly suggest you look to see if the Perl solution will work.

Otherwise it would be OLE Automation programming which normally requires Windows.

Tiger99,
Is the file CSV or excel (XLS)?

Thank you porter for your reponse

If I convert my excel file to csv file, is it possible to read the first column of data in csv file using shell script?

i.e (in my csv file I have)
1234,bob
2345,tom
3345,mary

What I need to accomplish is reading the first column (1234,2345,3345) using shell script and pass the number to a stored procedure for executing a select statement (select * from db where id in (1234,2345,3345 .....))

Any help in this would be really appreciated

This can be done with "IFS=," and "while read A B C D E ..."

What database are you using?