Columns and Rows in Excel
anand.pasoria at in.bosch.com
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 REMOVEMEcyber.com.au> wrote in message
news:43A66BAB.30703 at REMOVEMEcyber.com.au...
> 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?
More information about the Python-list