Read Excel macro (.xlsm) file data trough Python

Hello, Kapil I highly recommend using xlwings if you want to open, modify, and save .xlsm files without corrupting them. I have tried a ton of different methods (using other modules like openpyxl) and the macros always end up being corrupted. import xlwings as xw app = xw.App(visible=False) # IF YOU WANT EXCEL TO RUN IN BACKGROUND xlwb = xw.Book('PATH\\TO\\FILE.xlsm') xlws = {} xlws['ws1'] = xlwb.sheets['Your Worksheet'] print(xlws['ws1'].range('B1').value) # get value xlws['ws1'].range('B1').value = 'New Value' # change value yourMacro = xlwb.macro('YourExcelMacro') yourMacro() xlwb.save() xlwb.close() Edit - I added an option to keep Excel invisible at users request

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Dipa Mehta6y ago
Hello, Kapil I highly recommend using xlwings if you want to open, modify, and save .xlsm files without corrupting them. I have tried a ton of different methods (using other modules like openpyxl) and the macros always end up being corrupted. import xlwings as xw app = xw.App(visible=False) # IF YOU WANT EXCEL TO RUN IN BACKGROUND xlwb = xw.Book('PATH\\TO\\FILE.xlsm') xlws = {} xlws['ws1'] = xlwb.sheets['Your Worksheet'] print(xlws['ws1'].range('B1').value) # get value xlws['ws1'].range('B1').value = 'New Value' # change value yourMacro = xlwb.macro('YourExcelMacro') yourMacro() xlwb.save() xlwb.close() Edit - I added an option to keep Excel invisible at users request
0