Try to remove access rights for excel file or use python schedule library. Regards,Saleem.From: João Pedro Arruda LemeSent: Wednesday, September 23, 2020 3:27 AMTo: python-win32@python.orgSubject: [python-win32] Excel cannot open or save Hello, I've been facing a problem when trying to exec
Hello,
I've been facing a problem when trying to execute a scheduled task (Windows
Task Scheduler) that calls a Python script making use of pywin32.
The script is very simple, it opens Excel, writes 3 cells, saves and closes
it. I can execute it directly by the Administrator and, using runas, I c
m
www.siemens.com/ingenuityforlife<https://siemens.com/ingenuityforlife>
Von: python-win32
[mailto:python-win32-bounces+hartmut.niemann=siemens@python.org] Im Auftrag
von Tim Roberts
Gesendet: Freitag, 2. März 2018 09:13
An: Python-Win32 List
Betreff: Re: [python-win32] Excel / Word: setting pr
On Mar 2, 2018, at 12:07 AM, Niemann, Hartmut
wrote:
>
> print ('%r' % workbook.BuiltinDocumentProperties)
>
> gives me
>
> >
>
> What can I do with such an object?
Are you checking the Word object model? The BuiltinDocumetProperties method
returns a DocumentProperties object. I believe
Februar 2018 18:20
An: Python-Win32 List
Betreff: Re: [python-win32] Excel / Word: setting properties
Niemann, Hartmut wrote:
>
>
>
> How do I set the [Excel workbook] standard property "Keywords" to
> "C_Restricted" and the user property "Document Confid
Niemann, Hartmut wrote:
>
>
>
> I create an excel document using the COM interface.
>
>
>
> Now I need to set two properties to be compatible with a new company rule:
>
>
>
> “[the tool] uses MS Office standard (‘Keyword’) and custom (‘Document
> Confidentiality’) properties. so if your code
Hi!
I create an excel document using the COM interface.
Now I need to set two properties to be compatible with a new company rule:
"[the tool] uses MS Office standard ('Keyword') and custom ('Document
Confidentiality') properties. so if your code is able
to preset values to these properties [ev
Tarun Kapoor wrote:
> I am supporting this old legacy code that someone else wrote. A user
> had their computer replaced and the code stopped working. We have some
> code written in python that we want to access from Excel. We register
> the python COM like shown below
> ...
> Just for the sake of
I am supporting this old legacy code that someone else wrote. A user had
their computer replaced and the code stopped working. We have some code
written in python that we want to access from Excel. We register the python
COM like shown below
class COMWSdbAccess:
_reg_clsid_ = "{505D2E5B-17EC-
Qing Xu wrote:
> Hi All
>
> Original code:
>
> import win32com.client
> import win32clipboard
> from win32com.client import Dispatch
>
> ws_fc_ipn.PasteSpecial(Paste=-4163)
It would be better to use the symbolic names, like
win32com.client.constants.xlPasteValues. Or:
from win32com.client imp
Hi All
Original code:
import win32com.client
import win32clipboard
from win32com.client import Dispatch
ws_fc_ipn.PasteSpecial(Paste=-4163)
Wanted copy and paste special (paste value) to selection. Gave me
"Type Error: PasteSpecial() got an unexpected keyword argument 'Paste' "
If anyone kno
Tim Roberts wrote:
>Niemann, Hartmut wrote:
>>I want to create an Excel file through the python COM interface.
>>I can open the file, fill the cells, save the file.
>>Now I want to color single characters in the cell content.
>>In VBA ( see
>>http://stackoverflow.com/questions/7618121/excel-
Niemann, Hartmut wrote:
>
>
> I want to create an Excel file through the python COM interface.
>
> I can open the file, fill the cells, save the file.
>
>
>
> Now I want to color single characters in the cell content.
>
>
>
> In VBA ( see
>
> http://stackoverflow.com/questions/7618121/excel-v
Hello!
I want to create an Excel file through the python COM interface.
I can open the file, fill the cells, save the file.
Now I want to color single characters in the cell content.
In VBA ( see
http://stackoverflow.com/questions/7618121/excel-vba-change-color-of-certain-characters-in-a-cell)
I
es+mark.mordeca=prosensus...@python.org] On
Behalf Of Tim Golden
Sent: January-31-14 10:48 AM
To: python-win32@python.org
Subject: Re: [python-win32] Excel Workbooks Exception
On 31/01/2014 15:08, Mark Mordeca wrote:
> I sometimes get a random exception when trying to open an Excel file.
> It
On 31/01/2014 15:08, Mark Mordeca wrote:
> I sometimes get a random exception when trying to open an Excel file.
> It is not consistent. I will get the exception, and then try it
> again and it will work fine.
> xl=win32com.client.DispatchEx("Excel.Application")
>
> book=xl.Workbooks.Open(self.
Hello,
I sometimes get a random exception when trying to open an Excel file. It
is not consistent. I will get the exception, and then try it again and it
will work fine.
Simple two lines of code:
xl=win32com.client.DispatchEx("Excel.Application")
book=xl.Workbooks.Open(self.__filename,
On 30/04/2013 2:21 AM, Niemann, Hartmut wrote:
Hello!
The following snippet
from win32com.client import constants as xl_constants
wbook.ActiveSheet.Range('A3:N' + str(row + 1)).Sort(
Key1 = wbook.ActiveSheet.Range('B3'),
Orientation = xl_constants.xlTopToBottom,
DataOption1 = xl_constant
Hello!
The following snippet
from win32com.client import constants as xl_constants
wbook.ActiveSheet.Range('A3:N' + str(row + 1)).Sort(
Key1 = wbook.ActiveSheet.Range('B3'),
Orientation = xl_constants.xlTopToBottom,
DataOption1 = xl_constants.xlSortTextAsNumbers
On Thu, 8 Dec 2011 09:34:36 +0200
Rikus de Milander wrote:
> Hey,
> I am currently working on a python script to fetch data from a
> database and populate a excel sheet and draw some graphs. Currently I
> have only been able to generate a scatter graph with chart.ChartType
> = constants.xlXYScat
Hey,
I am currently working on a python script to fetch data from a database and
populate a excel sheet and draw some graphs. Currently I have only been
able to generate a scatter graph with chart.ChartType =
constants.xlXYScatter . Is there a way that one can set the position of the
graph on the
Hi All,
I am trying to speed up a bit a new widget I created for wxPython, which
uses heavily the COM interface between Python and Excel (it only reads Excel
data, no writing).
One of the main issues I have found is related to the extraction of the
"Text" property from a range of cells. Let's
Andrea Gavana wrote:
>
> I was wondering if someone had already tackled the problem of
> converting Excel cell NumberFormat to something Python can parse and
> actually use. In more detail, what I mean is: once you right-click on
> a cell and select "Format Cells" you get a huge list of possibl
Hi All,
I was wondering if someone had already tackled the problem of converting
Excel cell NumberFormat to something Python can parse and actually use. In
more detail, what I mean is: once you right-click on a cell and select
"Format Cells" you get a huge list of possible formatting options,
On 01/06/2011 16:07, Mark Mordeca wrote:
Thanks for your reply. I tested this on another box and I did not get the
error. I then tried different code that uses COM to manipulate Excel on
my machine which I know works and has worked in the past and I ended up
getting the error with that code. S
To: Mark Mordeca
Cc: python-win32@python.org
Subject: Re: [python-win32] Excel "stopped working" after reading in sheet
names
On 31/05/2011 6:09 PM, Tim Golden wrote:
> On 30/05/2011 21:26, Mark Mordeca wrote:
>> Greetings,
>>
>> I would appreciate any help I could get
On 31/05/2011 6:09 PM, Tim Golden wrote:
On 30/05/2011 21:26, Mark Mordeca wrote:
Greetings,
I would appreciate any help I could get with the following problem. 30%
of the time after running the following code to get the sheet names out
of an excel file, I will receive a windows error saying th
1 11:38 AM
Cc: python-win32@python.org
Subject: Re: [python-win32] Excel "stopped working" after reading in sheet
names
On 31/05/2011 16:26, Mark Mordeca wrote:
> Thanks for your reply Tim.
> If this is true, I hope to get some advice on how to correct the
problem.
...
Just a cou
On 31/05/2011 16:26, Mark Mordeca wrote:
Thanks for your reply Tim.
If this is true, I hope to get some advice on how to correct the problem.
...
Just a couple of quick answers, because I'm dashing off. One is that
we have code which uses the technique you're demonstrating to *write*
Excel
ppreciated.
Mark
-Original Message-
From: python-win32-bounces+mark.mordeca=prosensus...@python.org
[mailto:python-win32-bounces+mark.mordeca=prosensus...@python.org] On
Behalf Of Tim Golden
Sent: Tuesday, May 31, 2011 4:09 AM
To: python-win32@python.org
Subject: Re: [python-win32] Excel &q
On 30/05/2011 21:26, Mark Mordeca wrote:
Greetings,
I would appreciate any help I could get with the following problem. 30%
of the time after running the following code to get the sheet names out
of an excel file, I will receive a windows error saying that “Microsoft
Office Excel has stopped wo
Greetings,
I would appreciate any help I could get with the following problem. 30% of
the time after running the following code to get the sheet names out of an
excel file, I will receive a windows error saying that “Microsoft Office
Excel has stopped working”.
Code:
xl=win32com.client.Disp
: [python-win32] Excel Calculation - Check when it's done
Bilokon, Paul wrote:
> Thanks so much!
>
> Is there anything like a "global" Worksheet_Calculate, which would get hit
> when the entire worksheet calculation is done?
>
Not that I am aware of, but you probably wan
Bilokon, Paul wrote:
> Thanks so much!
>
> Is there anything like a "global" Worksheet_Calculate, which would get hit
> when the entire worksheet calculation is done?
>
Not that I am aware of, but you probably want to experiment with it to
see if it does what you need.
> Also, are there many
lokon=citi@python.org
[mailto:python-win32-bounces+paul.bilokon=citi@python.org] On Behalf Of Tim
Roberts
Sent: 25 August 2009 18:13
To: Python-Win32 List
Subject: Re: [python-win32] Excel Calculation - Check when it's done
Bilokon, Paul wrote:
>
> My apologies as this question is
Bilokon, Paul wrote:
>
> My apologies as this question is indeed Excel specific though it's
> wide applicability probably merits inclusion here.
>
> Is there any way to determine when a calculation is done in Excel from
> Python over COM, without busy-waiting?
>
> Does anyone have any example
Hi,
My apologies as this question is indeed Excel specific though it's wide
applicability probably merits inclusion here.
Is there any way to determine when a calculation is done in Excel from Python
over COM, without busy-waiting?
Does anyone have any examples?
Many thanks,
Paul
Hello,
I'm trying to get values from a non-contiguous range, specifically
"E5:E10,E35"
Range("E5:E10,E35").Value -- only returns the values for "E5:E10", ignoring
"E35"
Range("E5:E10,E35").Address -- however returns "E5:E10,E35"
Range("E5:E10,E35").Count -- returns 7, which is correct
I'm early
Message: 1
Date: Fri, 25 Jul 2008 12:52:04 +0200
From: Michiel Overtoom <[EMAIL PROTECTED]>
Subject: Re: [python-win32] Excel Document
To: python-win32@python.org
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset="us-ascii"
Sina wrote...
>To read
Sina wrote...
>To read the contents of an excel spreadsheet. In one case I am trying to
>read the value of the cell rather than its contents. i.e. if I have a
>hyperlink called "Document" or "Procedure" which is a hyperlink to
>http://intranet/foo.pdf then this script will return "Document" or "Li
Hi guys,
I have been using this module
http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/440661
To read the contents of an excel spreadsheet. In one case I am trying to
read the value of the cell rather than its contents. i.e. if I have a
hyperlink called "Document" or "Procedure" which is
> Sriram Sundararajan wrote:
> >I have a question on the excelAddin.py sample in the win32com\demos folder.
> >
> > We create a Tool Bar, add a button to it,
> > btnMyButton = cbcMyBar.Controls.Add(Type=constants.msoControlButton,
> > Parameter="Greetings")
> >
> > 'register' the button wit
Sriram Sundararajan wrote:
I have a question on the excelAddin.py sample in the win32com\demos folder.
We create a Tool Bar, add a button to it,
btnMyButton = cbcMyBar.Controls.Add(Type=constants.msoControlButton,
Parameter="Greetings")
'register' the button with the ButtonEvent class,
btnMyBu
I have a question on the excelAddin.py sample in the win32com\demos folder.
We create a Tool Bar, add a button to it,
btnMyButton = cbcMyBar.Controls.Add(Type=constants.msoControlButton,
Parameter="Greetings")
'register' the button with the ButtonEvent class,
btnMyButton=self.toolbarButton = Disp
I am writing to arrays to excel. If I write row-wise everything works well.
app.Range('d4:f4').Value = [2,3,4]
However if I try to assign column wise everything goes wrong
app.Range('d4:d6').Value = [2,3,4]
I know I can rearrage things like [[i] for i in [2,3,4]] but it does
not seem terribly
> >>> from win32com.client import Dispatch
> >>> xlApp = Dispatch("Excel.Application")
> >>> actvSht = xlApp.ActiveSheet
> >>> actvSht.Cells(1,1).Value
> Traceback (most recent call last):
> File "", line 1, in ?
> File
> "c:\python24\lib\site-packages\win32com\gen_py\00020813--0
> 000-C000
Hi,
I have been working thru the 'Python Programming on Win32' book by M.
Hammond in an attempt to get up to speed on Python COM programming. I am
trying to do some simple output to Excel from a Turbogears application.
I am using Microsoft Excel 2003.
I have run into an issue using the Cells met
Carlos Izquierdo wrote:
> The error is almost always on the lines of: "bool object is not
> callable".
Feel free to knock this suggestion on the head straightaway,
but an error of this type will often come down to the fact
that -- somewhere in the code -- you've bound a name which
is origi
Hi,
I'm fairly new to Python COM development and I'm having trouble
automating
Microsoft Excel. I have the following piece of code:
d = win32com.client.Dispatch('Excel.Application')
d.Visible = 1
dw = d.Workbooks.Open('c:\\datos.xls')
dw.Sheets(1
Hussain Jiwani wrote:
> Following is a snippet of code that I have been using to figure out if
> an addin in installed.
>
> xlApp = win32com.client.dynamic.Dispatch('Excel.Application')
> xlApp.DisplayAlerts = 0
> xlApp.Interactive = 1
> if xlApp.Application.Addins.C
xlApp.quit
return
xlApp.Application.Addins(lnAddins).Installed = 0
xlApp.Application.Addins(lnAddins).Installed = 1
Hussain
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tim Roberts
Sent: Wednesday, April 25, 2007 12:
mjohnson wrote:
> I am having a problem with an excel add-in which is installed via
> xlApp.Workbooks.Open("C:/Program
> Files/Program/XLOF32.xla").RunAutoMacros(1)
>
> I can then add the add-in and install it via
> xlApp.AddIns.Add ("C:/Program Files/Program/XLOF32.xla",True)
> xlApp.AddIns.Item(I
I am having a problem with an excel add-in which is installed via
xlApp.Workbooks.Open("C:/Program Files/Program/XLOF32.xla").RunAutoMacros(1)
I can then add the add-in and install it via
xlApp.AddIns.Add ("C:/Program Files/Program/XLOF32.xla",True)
xlApp.AddIns.Item(Index='Excel Functions').Inst
Andrea Gavana wrote:
> Hi Roger,
>
> On 2/10/07, Roger Upole wrote:
>> "Andrea Gavana" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
>>> Hi All,
>>>
>>>I have a very simple python script that tries to put a rectangular
>>> shape in a worksheet and then add some text inside that s
Hi Roger,
On 2/10/07, Roger Upole wrote:
> "Andrea Gavana" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
> > Hi All,
> >
> >I have a very simple python script that tries to put a rectangular
> > shape in a worksheet and then add some text inside that shape. The
> > main problem,
"Andrea Gavana" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
> Hi All,
>
>I have a very simple python script that tries to put a rectangular
> shape in a worksheet and then add some text inside that shape. The
> main problem, is that as usual Excel doesn't like input strings lon
Hi All,
I have a very simple python script that tries to put a rectangular
shape in a worksheet and then add some text inside that shape. The
main problem, is that as usual Excel doesn't like input strings longer
than 200 and something characters. So, By just recording a macro in
Excel, I trie
I ran my test with the 'optional' arguments defined as pythoncom.Missing
and it does work now. Previously my code was working under a very old
Python 1.5.2 where the 'defaultNamedNotOptArg' was defined as
pythoncom.Missing in the .py file generated for the Excel 11.0 Object
Library.
Evidently the
I am using Python 2.2.3 with Pywin32-210.win32-py2.2 The following
Python sequence works fine when using the 'late binding' method.
import win32com.client.dynamic
import types
xlApp = win32com.client.Dispatch("Excel.Application")
xlBook = xlApp.Workbooks.Open( 'C:\\TestExcel.xls' )
sheet = xlBook.
Thanks helped me i was just working on that also!
On 11/23/06, Bob Gailer <[EMAIL PROTECTED]> wrote:
Please reply to the list as well as me. Others learn and sometimes offer
help.
Rikard Bosnjakovic wrote:
>
> I'm an utter novice of COM/DOM and I really don't have much knowledge
> about it. I k
Please reply to the list as well as me. Others learn and sometimes offer
help.
Rikard Bosnjakovic wrote:
>
> I'm an utter novice of COM/DOM and I really don't have much knowledge
> about it. I know how to launch Word/Excel from Python by using
> Dispatch("Excel.Application"), but that's about it.
Rikard Bosnjakovic wrote:
> I am going to add data row wise to Excel. Doing it manually, it would
> be like this:
>
> TAB TAB RETURN
> TAB TAB RETURN
>
> The TAB makes the cursor go to the next cell in the row, and the
> RETURN makes the cursor go to the next row, in the same column as the
>
Rikard Bosnjakovic wrote:
> I am going to add data row wise to Excel. Doing it manually, it would
> be like this:
>
> TAB TAB RETURN
> TAB TAB RETURN
>
> The TAB makes the cursor go to the next cell in the row, and the
> RETURN makes the cursor go to the next row, in the same column as the
>
I am going to add data row wise to Excel. Doing it manually, it would
be like this:
TAB TAB RETURN
TAB TAB RETURN
The TAB makes the cursor go to the next cell in the row, and the
RETURN makes the cursor go to the next row, in the same column as the
first cell.
Now I need to do this in Pyth
thon-win32@python.org
Subject: Re: [python-win32] Excel and OLEObjects
Mark Norley wrote:
> Hello
>
> I'm trying to insert an object into an Excel sheet with the following
code:
>
> import win32com.client
> xlapp = win32com.client.Dispatch("Excel.Application"
Mark Norley wrote:
> Hello
>
> I'm trying to insert an object into an Excel sheet with the following code:
>
> import win32com.client
> xlapp = win32com.client.Dispatch("Excel.Application")
> xlapp.Visible = 1
> xlapp.Workbooks.Add()
> xlapp.ActiveSheet.OLEObjects.Add(FileName = "C:\\mytext.tx"', L
Hello
I'm trying to insert an object into an Excel sheet with the following code:
import win32com.client
xlapp = win32com.client.Dispatch("Excel.Application")
xlapp.Visible = 1
xlapp.Workbooks.Add()
xlapp.ActiveSheet.OLEObjects.Add(FileName = "C:\\mytext.tx"', Link=False,
DisplayAsIcon=False).Sel
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tim Roberts
Sent: Friday, October 06, 2006 12:27 PM
To: 'Python-Win32 List'
Subject: Re: [python-win32] Excel win32com newbie question
Jim Steil wrote:
>Thanks for the response! I tried your suggestion with the follo
Jim Steil wrote:
>Thanks for the response! I tried your suggestion with the following
>results
>
>
>
import win32com.client
x = win32com.client.gencache.EnsureDispatch("Excel.Application")
>Traceback (most recent call last):
> File "", line 1, in ?
> File "C:\Pyt
thon-win32@python.org
Subject: Re: [python-win32] Excel win32com newbie question
Python 2.4.1
Pywin23 2.10
I'm in the process of upgrading my python to 2.4.3, will send a follow-up
after I'm done testing.
Thanks!
-Jim
-Original Message-
From: John Machin [mailto:[EM
Oops, obvious typo on the pywin23 below. Should be pywin32.
-Jim
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jim Steil
Sent: Friday, October 06, 2006 11:59 AM
To: 'John Machin'
Cc: python-win32@python.org
Subject: Re: [python-wi
PROTECTED]
Sent: Friday, October 06, 2006 10:52 AM
To: Jim Steil
Cc: python-win32@python.org
Subject: Re: [python-win32] Excel win32com newbie question
On 6/10/2006 11:34 PM, Jim Steil wrote:
> Thanks for your response too! Unfortunately, I must have something messed
> up here because
On 6/10/2006 11:34 PM, Jim Steil wrote:
> Thanks for your response too! Unfortunately, I must have something messed
> up here because this didn't work either.
>
from win32com.client import Dispatch, constants
print getattr(constants, 'xlHAlignRight', 'Bt!')
> Bt!
app = Disp
Machin [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 05, 2006 6:04 PM
To: Jim Steil
Cc: python-win32@python.org
Subject: Re: [python-win32] Excel win32com newbie question
On 6/10/2006 7:16 AM, Jim Steil wrote:
> I've been working this week building some Excel spreadsheets using
> Py
,
^
SyntaxError: invalid syntax
>>>
Any ideas from here?
-Jim
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tim
Roberts
Sent: Thursday, October 05, 2006 6:06 PM
To: Python-W
Jim Steil wrote:
> I’ve been working this week building some Excel spreadsheets using
> Python and win32com. ...
>
> Possibly my biggest problem is that I can’t get my machine to give me
> the Excel constants. Here is the code I’m doing to try to test the
> constants and the error I’m getting back
On 6/10/2006 7:16 AM, Jim Steil wrote:
> I’ve been working this week building some Excel spreadsheets using
> Python and win32com. I am not having any trouble getting my sheets
> built with the proper data in the proper cells, but I’m having a heck of
> a time trying to find out how I can forma
I’ve been working this week building some Excel
spreadsheets using Python and win32com.
I am not having any trouble getting my sheets built with the proper data
in the proper cells, but I’m having a heck of a time trying to find out
how I can format my cells to make it look nicer. I want
EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bob Gailer
Sent: Thursday, August 17, 2006 4:37 PM
To: [EMAIL PROTECTED]
Cc: python-win32@python.org
Subject: Re: [python-win32] Excel corrupted display problem
[EMAIL PROTECTED] wrote:
> Hi list,
>
> I have a Python script that pops
[EMAIL PROTECTED] wrote:
> 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 us
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 all, if we have number of excel sheets in a workbook.can we access a select sheet in the workbook. when i try to acces it always goes to the last sheet. thanks,
Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, & more on new and used cars.___
2006/02/20 ma PM 12:15:49 CET
> aan:
> onderwerp: Re: [python-win32] Excel using python
>
> [John Machin]
>
> | > OK, given the workbook created in my previous post...
>
> [ ... snip more code ...]
>
> | OK, great, Tim, we're almost there :-)
> | "when i
On 20/02/2006 10:37 PM, Tim Golden wrote:
> | From: John Machin [mailto:[EMAIL PROTECTED]
> |
> | Tim, that's fantastic. Hold out your hand for the elephant stamp :-)
>
> Must be an American thing? (Obligatory Monty Python
> reference: I'm sorry, old man, I don't quite follow your
> banter!)
>
| From: John Machin [mailto:[EMAIL PROTECTED]
|
| Tim, that's fantastic. Hold out your hand for the elephant stamp :-)
Must be an American thing? (Obligatory Monty Python
reference: I'm sorry, old man, I don't quite follow your
banter!)
| ... apart from moderate banter, we haven't got off his
|
On 20/02/2006 10:15 PM, Tim Golden wrote:
> [John Machin]
>
> | > OK, given the workbook created in my previous post...
>
> [ ... snip more code ...]
>
> | OK, great, Tim, we're almost there :-)
> | "when i try to acces it always goes to the last sheet." ...
> | looks like
> | the OP wants th
[John Machin]
| > OK, given the workbook created in my previous post...
[ ... snip more code ...]
| OK, great, Tim, we're almost there :-)
| "when i try to acces it always goes to the last sheet." ...
| looks like
| the OP wants the default sheet to point to some sheet other than the
| last
On 20/02/2006 8:02 PM, Tim Golden wrote:
> [John Machin]
> |
> | On 20/02/2006 7:46 PM, Tim Golden wrote:
> | > [yeswanty devi]
> | >
> | > | Hello all,
> | > | if we have number of excel sheets in a workbook.can
> | > | we access a selected sheet in the workbook. when i try to
> | > |
[John Machin]
|
| On 20/02/2006 7:46 PM, Tim Golden wrote:
| > [yeswanty devi]
| >
| > | Hello all,
| > | if we have number of excel sheets in a workbook.can
| > | we access a selected sheet in the workbook. when i try to
| > | acces it always goes to the last sheet.
| >
| > I assume
On 20/02/2006 7:46 PM, Tim Golden wrote:
> [yeswanty devi]
>
> | Hello all,
> | if we have number of excel sheets in a workbook.can
> | we access a selected sheet in the workbook. when i try to
> | acces it always goes to the last sheet.
>
> I assume this is the kind of thing you want
[yeswanty devi]
| Hello all,
| if we have number of excel sheets in a workbook.can
| we access a selected sheet in the workbook. when i try to
| acces it always goes to the last sheet.
I assume this is the kind of thing you want:
(somewhat exaggerated example, but ...)
import os
imp
Hello all, if we have number of excel sheets in a workbook.can we access a selected sheet in the workbook. when i try to acces it always goes to the last sheet. thanks,
Yahoo! Mail
Use Photomail to share photos without annoying attachments.__
Tim Golden wrote:
> [EMAIL PROTECTED]
>
> | Hello all,
> |
> | I'm having some trouble on the find function in Excel. A
> | simple Find statement works fine, but as soon as I want to
> | use an advanced option (xlByColumns) I get an error.
> |
>
> [... snip ...]
>
> | findcell =
> | xlApp.A
[EMAIL PROTECTED]
| Hello all,
|
| I'm having some trouble on the find function in Excel. A
| simple Find statement works fine, but as soon as I want to
| use an advanced option (xlByColumns) I get an error.
|
[... snip ...]
| findcell =
| xlApp.ActiveSheet.UsedRange.Find('FXN3',None,consta
Hello all,
I'm having some trouble on the find function in Excel. A simple Find statement
works fine, but as soon as I want to use an advanced option (xlByColumns) I get
an error.
This is my program:
#!/usr/bin/python
from win32com.client import Dispatch
from win32com.client import constants
x
At 01:10 PM 1/10/2006, John Machin wrote:
>bob wrote:
> > At 11:16 AM 1/10/2006, John Machin wrote:
> >
> >> bob wrote:
> >>
> >>> Viola, it displays 6.
Oh alright I meant voila. Mi francios es pocito.
> >>
> >>
> >> :-)
> >> Cello, it displays 7.
> >> (-:
> >
> > Version difference? I'm using Ex
bob wrote:
> At 11:16 AM 1/10/2006, John Machin wrote:
>
>> bob wrote:
>>
>>> Viola, it displays 6.
>>
>>
>> :-)
>> Cello, it displays 7.
>> (-:
>
> Version difference? I'm using Excel 2000. and I get xlcsv = 6! But it
> should stay the same!
>
> You can also open the object browser (F2) within
Thank you all for the assistance!
That file were saved nice and easy and I can continue struggling with my quest
to get out of all C# code. Not that i dislike C#, but the right tool to do the
right job ;-)
Again, huge thanks!
Stefan
--
___
Check o
On Wed, 11 Jan 2006 00:12:28 +0800, "Stefan Elwesthal"
<[EMAIL PROTECTED]> wrote:
>
> I have to ask, cause two days later I'm starting to get annoyed ;-)
>
> How could I use PythonCOM and save my re-worked Excel file as an xlCSV
> file? All I get is
> "SaveAs method in Worksheet class failed".
>
Stefan Elwesthal wrote:
> Hi all!
>
> I have to ask, cause two days later I'm starting to get annoyed ;-)
>
> How could I use PythonCOM and save my re-worked Excel file as an xlCSV file?
> All I get is
> "SaveAs method in Worksheet class failed".
>
> Is something wrong with this line?
Yes. Two
1 - 100 of 113 matches
Mail list logo
