Anand wrote:
> Greetings,
>
> How can I find the number of active columns and rows used in an excel work
> 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?
>
> A code snippet would be of great help.
>
> Thanks for your c
> "Steven D'Aprano" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>
>>Anand wrote:
>>
>>
>>>Greetings,
>>>
>>>How can I find the number of active columns and rows used in an excel
>
> work
>
>>>sheet?
>>>What I mean is how can i find the last column and row or cell position,
>>>w
Greetings,
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,
Anand
"Steven D'Aprano" <[EMAIL PROTECTED]> wrote in
In Python you probaly best follow a recipe like this.
1 Save the file in Excel as a csv file.
2.Study the reader object of Python's csv module :
http://docs.python.org/lib/module-csv.html
3. Read a row for row in in a list, split it on comma, count the
elements, the maximum of all these is the num
Anand wrote:
> Greetings,
>
> How can I find the number of active columns and rows used in an excel work
> 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 y
Greetings,
How can I find the number of active columns and rows used in an excel work
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?
A code snippet would be of great help.
Thanks for your cooperation and help.
Best rega
