Automation Excel from Python

Question

In my company, we use Linux in development and production environment. But we have a machine running Windows and Excel because we use a third party application excel addin to get financial market data to the machine. The add-in provides some functions (just like Excel function) for getting these datas into the local machine and then sending back to a MySql Database. We've also developed some VBA script to automation the task but still not satisfy with the result. I'm considering using Python to do all these jobs, but before jumping in, i need to find a python package that can do

Use python to manipulate Excel (with its add-ins) and use its functions without opening Excel?
If I need to open Excel, I need to automate that task of executing the script every day, or in specific moment of the day (the market data need to be feed a specific time)

Thanks for suggestion

Arbalest · Accepted Answer · 2019-03-07 16:49:14Z

12

You'll need the Python Win32 extensions - http://sourceforge.net/projects/pywin32/

(now migrated to GitHub: https://github.com/mhammond/pywin32)

Then you can use COM.

from win32com.client import Dispatch
excel = Dispatch('Excel.Application')
wb = excel.Workbooks.Open(r'c:\path\to\file.xlsx')
ws = wb.Sheets('My Sheet')
# do other stuff, just like VBA
wb.Close()
excel.Quit()

You can put your script on Windows Task Scheduler to run for the times you need.

edited Mar 7, 2019 at 16:49

Arbalest

1,1051 gold badge11 silver badges23 bronze badges

answered Mar 17, 2013 at 23:01

pyrospade

8,1004 gold badges38 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

nam Over a year ago

Can you have take a look at my new question? stackoverflow.com/questions/15929676/…

Clarius · Accepted Answer · 2017-04-18 08:45:42Z

2

As an alternative, you might consider openpyxl.

import openpyxl
wb= openpyxl.Workbook()
ws = wb.get_active_sheet()
ws.title = 'My Title'
wb.save('C:\\Development\\Python\\alpha.xlsx')

Here's a chapter from the book I'm working through.

https://automatetheboringstuff.com/chapter12/

Luck

answered Apr 18, 2017 at 8:45

Clarius

1,47918 silver badges13 bronze badges

Collectives™ on Stack Overflow

Automation Excel from Python

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related