Hi list,
I have a need to copy 3 rows of data from the top of
my Excel spreadsheet to another location. I would
have throught that this should be very straightforward
since I've done a fair amount of Excel/Python
programming. Unforturnately, I am stuck on this one.
The VB Macro says I need to:
Thanks for the help, Roger. Yes, that works. I just
have to remember that:
xlSel=xlSheet.Range("1:1,2:2,3:3").Select()
is *NOT* the same as:
xlSel=xlSheet.Range("1:1,2:2,3:3")
xlSel.Select()
Thanks again.
> Hi list,
>
> I have a need to copy 3 rows of data from the top of
> my Excel spreadsh
Hi list,
I have a Python script that pops up Excel, fill it,
and then continue. If the user clicks on my Python
side to close Excel (via a call to the Quit()
function), then I can reopen it later via another
dispatch call and so forth.
However, if the user close Excel from the Excel side,
next
Hello list,
We all know that it's better to set the values of a spreadsheet by
building a squared virtual sheet first and then copy the whole thing
over with one single range...value call.
But Is there a more efficient way to set the attributes of a number of cells in
Excel?
I am noticing a s
Hi list,
I upgraded to Python 2.5 for evaluation and testing. After installing the
pywin32-210.win32-py2.5.exe, I found that the constants module doesn't work.
For example, this code fails:
from win32com.client import Dispatch, constants
print constants.xlDown
I re-execute makepy.py
> > Hi list,
> >
> > I upgraded to Python 2.5 for evaluation and testing.
> After installing the pywin32-210.win32-py2.5.exe, I found that the
> > constants module doesn't work. For example, this code fails:
> >
> > from win32com.client import Dispatch, constants
> >
> > print constants.xl
