0

I have written a python code using selenium for automating files extraction from website and then I need to format these reports and append them and i am using macros for this.

Is there any way to call the python code from excel by integrating it with VBA or something like that?

Community
  • 1
  • 1
Umamaheshwar
  • 97
  • 3
  • 9
  • 1
    [this may help you out](http://stackoverflow.com/questions/2986234/can-i-run-c-sharp-code-from-vba-macro) –  May 31 '13 at 09:36
  • 1
    maybe using **OLE AUtomation** if the *Python* code is compiled to an executable or DLL or other ActiveX compliant doobri ... – Our Man in Bananas May 31 '13 at 09:49
  • Possible duplicate of [How to call python script on excel vba?](http://stackoverflow.com/questions/18135551/how-to-call-python-script-on-excel-vba) – J. Chomel Jul 22 '16 at 09:05

1 Answers1

0

you can write a code in python to populate excel [ Edit as well ] . There are libraries openpyexcel, xlrd etc more can be found here

It is easy for integration. Thanks

Ingo Karkat
  • 167,457
  • 16
  • 250
  • 324
Vardhman Patil
  • 517
  • 6
  • 22