Columns and Rows in Excel

Anand anand.pasoria at
Mon Dec 19 10:31:55 CET 2005


The worksheet is currently opened in Excel.
And I want to read the data from the excel worksheet.
Instead of looping through the entire worksheet, I want to limit the looping
to the rows and columns used so far!

Thanks and regards,

"Steven D'Aprano" <steve at> wrote in message
news:43A66BAB.30703 at
> Anand wrote:
> > Greetings,
> >
> > How can I find the number of active columns and rows used in an excel
> > sheet?
> > What I mean is how can i find the last column and row or cell position,
> > where the data is stored in an excel sheet?
> Is the worksheet currently open in Excel or OpenOffice,
> and you wish to query the application for that information?
> Or do you want to read the spreadsheet in from a file?
> -- 
> Steven.

More information about the Python-list mailing list