On Jan 10, 8:21 pm, Mike P <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I currently have an excel table (1 table each time) that has differing
> number of rows and differing number of columns each time, for another
> program i use (SPSS) to import the data i need to know the cell range
> of this data table
> On Behalf Of Mike P
> Does anyone have any code that does something similar? My
> guess is i have to do something like thefollowing to enable
> python to read xl?
I think that what you want is UsedRange
for row in sheet.UsedRange.Value:
...
Regards,
Ryan Ginstrom
--
http://mail.python.
Hi,
I currently have an excel table (1 table each time) that has differing
number of rows and differing number of columns each time, for another
program i use (SPSS) to import the data i need to know the cell range
of this data table.
I.e what the last row of data is and the last column that has d
On Apr 18, 1:58 pm, Ant <[EMAIL PROTECTED]> wrote:
> Hi Mike,
>
> > I can't find anything about copying a worksheet, but I found a some
> > fairly detailed information about COM objects and getting more
> > information about Python's bindings to them
> > here:http://www.oreilly.com/catalog/pythonw
Hi Mike,
> I can't find anything about copying a worksheet, but I found a some
> fairly detailed information about COM objects and getting more
> information about Python's bindings to them
> here:http://www.oreilly.com/catalog/pythonwin32/chapter/ch12.htmlor
> here:http://mathieu.fenniak.net/pl
On Apr 18, 2:38 am, Ant <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I'm doing some Excel automation work for a friend, and am developing
> on a machine running Office 2000. My friends machine is running Excel
> 2003. The code I've written works like a charm on my machine (in fact
> all three of my mac
Hi all,
I'm doing some Excel automation work for a friend, and am developing
on a machine running Office 2000. My friends machine is running Excel
2003. The code I've written works like a charm on my machine (in fact
all three of my machines), but falls over early on on Excel 2003.
The code snipp
