Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel addins
#1
Dear all,

I have a question i am hoping you are able to help me with.
I am running the code (snip) below in Jupyter. When it is completed, all addins in Excel are either disabled or have stopped working. I have to disable them in the addin list and enable them again.

Are there any way around this? to not disrupt the addins I use.

BEst,
Rogstad

import numpy as np
import pandas as pd
%matplotlib inline

import os
import errno
import shutil


from datetime import datetime

pwd = %pwd

path = pwd + '/input'
try:
os.makedirs(path)
except OSError:
if not os.path.isdir(path):
raise

path = pwd + '/output'
try:
os.makedirs(path)
except OSError:
if not os.path.isdir(path):
raise

import win32com.client
import time
import shutil


SourcePathName='Path'
FileName='Name'
Application = win32com.client.Dispatch("Excel.Application")
Application.Visible = 1
Workbook = Application.Workbooks.open(SourcePathName + '/' + FileName)
Workbook.Save()
Application.Quit()
Reply


Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020