Re: [OT] Python and Excel

2017-12-19 Thread Thomas Jollans
On 2017-12-18 20:16, MRAB wrote: > Those who use Excel might find this interesting: > > Microsoft Considers Adding Python as an Official Scripting Language to > Excel > https://www.bleepingcomputer.com/news/microsoft/microsoft-considers-adding-python-as-an-official-scripting-language-to-excel/ >

Re: [OT] Python and Excel

2017-12-19 Thread Rustom Mody
On Tuesday, December 19, 2017 at 4:38:17 AM UTC+5:30, Les Cargill wrote: > oliver wrote: > > That would be amazing. I still have nightmares of when I had to create this > > big options analysis VBA program in Excel 2007. > > > > > Odd - I haven't found VBA itself to be all that horrible. Yeah, i

Re: [OT] Python and Excel

2017-12-18 Thread Les Cargill
oliver wrote: That would be amazing. I still have nightmares of when I had to create this big options analysis VBA program in Excel 2007. Odd - I haven't found VBA itself to be all that horrible. Yeah, it's got some serious weaknesses but it jut hasn't bit me badly, yet. Then again, it's no

Re: [OT] Python and Excel

2017-12-18 Thread oliver
That would be amazing. I still have nightmares of when I had to create this big options analysis VBA program in Excel 2007. On Mon, Dec 18, 2017, 14:21 MRAB, wrote: > Those who use Excel might find this interesting: > > Microsoft Considers Adding Python as an Official Scripting Language to > Exc

[OT] Python and Excel

2017-12-18 Thread MRAB
Those who use Excel might find this interesting: Microsoft Considers Adding Python as an Official Scripting Language to Excel https://www.bleepingcomputer.com/news/microsoft/microsoft-considers-adding-python-as-an-official-scripting-language-to-excel/ -- https://mail.python.org/mailman/listinfo/p

Re: Win32 python and excel macros

2006-10-18 Thread John Coleman
Mike P wrote: > After just running trying that update it hits the macro perfectly but > hten i get an error message after i type in a couple of values.. as per > below > > Traceback (most recent call last): > File "", line 148, in ? > File ">", line 14, in Run > File "C:\Python24\Lib\site-pa

Re: Win32 python and excel macros

2006-10-18 Thread Mike P
After just running trying that update it hits the macro perfectly but hten i get an error message after i type in a couple of values.. as per below Traceback (most recent call last): File "", line 148, in ? File ">", line 14, in Run File "C:\Python24\Lib\site-packages\win32com\client\dynamic

Re: Win32 python and excel macros

2006-10-18 Thread Mike P
Thanks for your advice on this matter, I'm actually using Excel 2003!! so it shows how much i know! i did manage to get the prog to run with the line xl.Application.Run("CTP.xla!sheet1.CTP") but it didn't do anything... i'm guessing it is along the lines of wht you were saying earlier about big

Re: Win32 python and excel macros

2006-10-18 Thread John Coleman
[EMAIL PROTECTED] wrote: > Hi Experts, > > Looking for a very quick bit on of advice on how to make some python > code run. I'm a newbie to both VBA and Python, so i apologise if this > is very easy but i'm about to tear my hair out after googling for the > last 3 days. > > I have written a large

Win32 python and excel macros

2006-10-18 Thread michael . pearmain
Hi Experts, Looking for a very quick bit on of advice on how to make some python code run. I'm a newbie to both VBA and Python, so i apologise if this is very easy but i'm about to tear my hair out after googling for the last 3 days. I have written a large python script which inside of it create

Re: Python and Excel

2005-01-19 Thread Charlie Taylor
If it helps, I started a similar project a few years ago on SourceForge when I was just learning python called python2xlw. I haven't supported it for quite a while, however, I still use it a lot in my own work. I needed to create Excel files with scatter charts in them for a web interface so

Re: Python and Excel

2005-01-19 Thread howardrh
Please consider this reply as one vote for posting your python Excel interface/software on the Vaults of Pamassus Web Site. Located at http://www.vex.net/parnassus/ -- http://mail.python.org/mailman/listinfo/python-list

Re: Python and Excel

2005-01-19 Thread Simon John
Hmm, sounds interesting, I've always resorted to using CSV (or even HTML!) when exporting to Excel. As far as how to open it up, have a look at creating a project on www.sourceforge.net or just zip it up and bung it on your own website if you have one. I've got the feeling there are also Python-sp