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()
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()