Re: Extract column of excel

[kcott]

G'day MynameisAchint,

Welcome to the monastery.

While I realise this is your first posting here, unfortunately it has some problems. Please read "How do I post a question effectively?". Do note that PerlMonks is not a code writing service; if you want to post a specification and then sit back while someone else writes your code, you'll need to look elsewhere.

It's unclear from your post whether you're using Excel purely as a reader for CSV files or if Excel has a more integral role. If the former, you can bypass Excel altogether and use Text::CSV; if the latter, you'll need to identify whether you're working with the older (*.xls) or newer (*.xlsx) format and then use (probably) either Spreadsheet::ParseExcel or Spreadsheet::XLSX.

[MynameisAchint]

Hey Ya this is my first post so there are mistakes. I don't want anyone to write the code for me , I have written the code posted too ( though not very properly ) . The issue I am having is that it takes the entries not from the starting of the coloumn of csv but from somewhere in between and till the end . I am guessing that it takes only specified dimensions of the sheet . So I just want your help in ensuring that it takes all the entries of a column I am working with csv format