Select method of Range class failed

2014-12-23 Thread Jaydeep Patil
Hi all, I have developed python code which copy paste data from one excel sheet to another excel sheet. I have compiled code both for 32 bit 64 bit. It is working fine on 64 bit machine. But on 32 bit, it is giving below error. rng.Select() Select method of Range class failed Just to know

Re: Keep one GUI always on TOP while python code is running

2014-08-08 Thread Jaydeep Patil
Chris, I mean to say, One GUI should be always on top from start to end of code running. So that user cant do any other operation. I am using wxpython Regards Jay -- https://mail.python.org/mailman/listinfo/python-list

Keep one GUI always on TOP while python code is running

2014-08-07 Thread Jaydeep Patil
Hi all, I have one query. I have did some programming which copies and paste data using system clipboard. I need to keep one GUI always on top till my python code is running. Can we do like this? Regards Jaydeep -- https://mail.python.org/mailman/listinfo/python-list

Convert Excel Range into python List

2014-07-01 Thread Jaydeep Patil
How to convert excel range into python list or tuple? show me example Regards Jaydeep Patil -- https://mail.python.org/mailman/listinfo/python-list

Re: Python While loop Takes too much time.

2014-07-01 Thread Jaydeep Patil
On Monday, 30 June 2014 18:16:21 UTC+5:30, Peter Otten wrote: Jaydeep Patil wrote: I have did excel automation using python. In my code I am creating python dictionaries for different three columns data at a time.There are are many rows above 4000. Lets have look in below

Python While loop Takes too much time.

2014-06-30 Thread Jaydeep Patil
= ws.Cells(r+1,c) Please have look in above code suggest me to improve speed of my code. Regards Jaydeep Patil -- https://mail.python.org/mailman/listinfo/python-list

Generate Single PowerPoint from two powerpoints using pywin32(python)

2014-06-17 Thread Jaydeep Patil
Hi, I have two powerpoints, which consists of images in each slide. I need to read each powerpoint, copy images from both powerpoint paste these images into output powerpoint side by side. How should i do thism using python? The repoisition of shapes seems to be difficult. Regards Jaydeep

Re: Generate Single PowerPoint from two powerpoints using pywin32(python)

2014-06-17 Thread Jaydeep Patil
On Tuesday, 17 June 2014 11:50:38 UTC+5:30, Jaydeep Patil wrote: Hi, I have two powerpoints, which consists of images in each slide. I need to read each powerpoint, copy images from both powerpoint paste these images into output powerpoint side by side. How should i do thism

Re: Lock Windows Screen GUI using python

2014-06-03 Thread Jaydeep Patil
On Tuesday, 3 June 2014 10:39:31 UTC+5:30, Ian wrote: On Mon, Jun 2, 2014 at 10:28 PM, Jaydeep Patil patil.jay2...@gmail.com wrote: Dear all, Can we Lock Windows Screen GUI till program runs unlock screen GUI when program finishes? If you mean can you programmatically bring

Re: Lock Windows Screen GUI using python

2014-06-03 Thread Jaydeep Patil
On Tuesday, 3 June 2014 12:39:38 UTC+5:30, Ian wrote: On Tue, Jun 3, 2014 at 12:40 AM, Jaydeep Patil patil.jay2...@gmail.com wrote: Hi Lan, Currently I am doing some automation in python excel. It read the data plots number of graphs. It took more than 20 minutes. So while

Re: Lock Windows Screen GUI using python

2014-06-03 Thread Jaydeep Patil
On Tuesday, 3 June 2014 20:57:32 UTC+5:30, Ian wrote: On Jun 3, 2014 1:56 AM, Jaydeep Patil patil@gmail.com wrote: I have another query. We can now block user inputs. But in my automation three is copy paste work going on continuously in Excel before plotting the graphs

Re: Lock Windows Screen GUI using python

2014-06-03 Thread Jaydeep Patil
On Wednesday, 4 June 2014 10:28:28 UTC+5:30, Ian wrote: On Tue, Jun 3, 2014 at 9:55 PM, Jaydeep Patil patil.jay2...@gmail.com wrote: Hi lan, For plotting one graph, I need to use four to five excel files. Currently I am reading excel files one by one and copy data of excel files

Lock Windows Screen GUI using python

2014-06-02 Thread Jaydeep Patil
Dear all, Can we Lock Windows Screen GUI till program runs unlock screen GUI when program finishes? Regards Jaydeep Paril -- https://mail.python.org/mailman/listinfo/python-list

Re: Hold wxframe (GUI)

2014-03-26 Thread Jaydeep Patil
On Wednesday, 26 March 2014 10:34:26 UTC+5:30, Jaydeep Patil wrote: I constructed Two frames. One frame consist of GUI which consist of one Ok button. Afer click on OK button another GUI calls. But after Second gui calling, It wont stop further procesees. I need to stop futher

Can we hold execution python programming till GUI event close on?

2014-03-26 Thread Jaydeep Patil
Hi... I have one wxframe. after click on that frame another frame opens and rest part is executed. I need ti stop the next execution after secong gui calls up. please suggest. -- https://mail.python.org/mailman/listinfo/python-list

Hold wxframe (GUI)

2014-03-25 Thread Jaydeep Patil
I constructed Two frames. One frame consist of GUI which consist of one Ok button. Afer click on OK button another GUI calls. But after Second gui calling, It wont stop further procesees. I need to stop futher proceeses. How can i hold second gui? Please reply Sample Code is: import wx

Python powerpoint automation using pywin32

2014-02-24 Thread Jaydeep Patil
I need to create a new powerpoint presentation. I need to add images, paste some graphs, add texts, tables into powerpoint. Is any link or document available which help me to do this work more effectivey faster. Regards Jay -- https://mail.python.org/mailman/listinfo/python-list

Re: Python powerpoint automation using pywin32

2014-02-24 Thread Jaydeep Patil
On Monday, 24 February 2014 17:27:23 UTC+5:30, sffj...@gmail.com wrote: On Monday, 24 February 2014 11:35:08 UTC, Jaydeep Patil wrote: I need to create a new powerpoint presentation. I need to add images, paste some graphs, add texts, tables into powerpoint. Is any link

Docs related python powerpoint automation using pywin32

2014-02-24 Thread Jaydeep Patil
Hi, Required help regarding python powerpoint automation using pywin32. provide some reference or guides? Regards Jaydeep -- https://mail.python.org/mailman/listinfo/python-list

TypeError: can't multiply sequence by non-int of type 'tuple'

2014-02-20 Thread Jaydeep Patil
HI, I have a tuple. I need to make sqaure of elements of tuple and after that i want add all suared tuple elements for total. When i trying to do it, below error came. Code: seriesxlist1 = ((0.0,), (0.01,), (0.02,), (0.03,), (0.04,), (0.05,), (0.06,), (0.07,), (0.08,), (0.09,), (0.1,),

Re: TypeError: can't multiply sequence by non-int of type 'tuple'

2014-02-20 Thread Jaydeep Patil
On Friday, 21 February 2014 12:06:54 UTC+5:30, Rustom Mody wrote: On Friday, February 21, 2014 12:01:53 PM UTC+5:30, Jaydeep Patil wrote: HI, I have a tuple. I need to make sqaure of elements of tuple and after that i want add all suared tuple elements for total. When i trying

Remove comma from tuples in python.

2014-02-20 Thread Jaydeep Patil
I am getting below tuple from excel. How should i remove extra commas in each tuple to make it easy for operations. tuples is: seriesxlist1 = ((0.0), (0.01), (0.02), (0.03), (0.04), (0.05), (0.06), (0.07), (0.08), (0.09), (0.1), (0.11)) please suggest me solution. Regards jay --

AttributeError: 'win32com.gen_py.Microsoft Excel 14.0 Object Library.Shape instance at 0x70837752' object has no attribute 'SeriesCollection'

2014-02-13 Thread Jaydeep Patil
: 'win32com.gen_py.Microsoft Excel 14.0 Object Library.Shape instance at 0x70837752' object has no attribute 'SeriesCollection' se = chartObj.SeriesCollection().NewSeries() Regards Jaydeep Patil -- https://mail.python.org/mailman/listinfo/python-list

Re: AttributeError: 'win32com.gen_py.Microsoft Excel 14.0 Object Library.Shape instance at 0x70837752' object has no attribute 'SeriesCollection'

2014-02-13 Thread Jaydeep Patil
On Thursday, 13 February 2014 16:41:48 UTC+5:30, Ben Finney wrote: Jaydeep Patil patil.jay2...@gmail.com writes: I have created chart object. But unable to add series into chart. Your code isn't self-contained (we are not able to run it as you presented it). Are you

Error getting while running python function

2014-02-10 Thread Jaydeep Patil
I have defined one function as below. def InfoDir(msg): msg1 = wx.MessageDialog(msg) msg1.ShowModal() msg1.Destroy() InfoDir(Testing) It gives below error. msg1 = wx.MessageDialog(msg) File C:\Python27\lib\site-packages\wx-2.8-msw-unicode\wx\_windows.py, line

Re: Error getting while running python function

2014-02-10 Thread Jaydeep Patil
On Tuesday, 11 February 2014 09:37:23 UTC+5:30, Jaydeep Patil wrote: I have defined one function as below. def InfoDir(msg): msg1 = wx.MessageDialog(msg) msg1.ShowModal() msg1.Destroy() InfoDir(Testing) It gives below error. msg1

Re: Error getting while running python function

2014-02-10 Thread Jaydeep Patil
On Tuesday, 11 February 2014 09:42:35 UTC+5:30, Chris Angelico wrote: On Tue, Feb 11, 2014 at 3:07 PM, Jaydeep Patil patil.jay2...@gmail.com wrote: I have defined one function as below. def InfoDir(msg): msg1 = wx.MessageDialog(msg) msg1.ShowModal