With VBA, I can edit arbitrary workbook metadata like so, and it will be reflected on SharePoint: Now, I am hoping to do the same with openpyxl I can do this for properties without spaces: but properties with spaces won’t work–I try this and the script runs, but nothing shows on SharePoint: This can be done with xlsxwriter but it
Tag: vba
workbook save failing, not sure why
I apologize for the length of this. I am a relative Neophyte to Excel VBA and even more junior with Python. I have run into an issue with an error that occasionally occurs in python using OpenPyXl (just trying that for the first time). Background: I have a series of python scripts (12) running and querying an API to gather
Running Python in VBA where there are spaces in execution path
I wrote a Python script to perform calculations which I want to run via Excel VBA and display the results in Excel. To be usable for different users I am trying to write a code that will generate the paths to the Python execution and Python scripts based on the usernames they enter since that is the only thing that
xlwings RunPython with function arguments
I am trying to run the RunPython function from a button in excel. I would like the function to take a parameter from a box in excel, something like this: Is this a possibility? And if so how do I write the code? I would prefer not to use UDF. Answer You can do that in two ways: 1) By
Python pandas write resulted dataframe to xlsm without losing the macro
I have a lot of excel files that I need to compile into a single excel file, and then copy the compiled one into an existing excel file (with macro / .xlsm) in a certain sheet. I solved the first problem (compiling multiple excel files into a single excel file). The resulted dataframe is saved in .csv format. The resulted
How to insert a picture into Excel at a specified cell position with python (Anaconda) use vba
I try to use this link with vba code but in Python it doesn’t work. AttributeError Traceback (most recent call last) in () 9 sheet.Cells(20, 20).Select 10 #obj1=sheet.Shapes.AddPicture (r’C:/Users/Home/Desktop/picture.jpg’, False, True, 10, 3, 100, 100) —> 11 obj1=wb.ActiveSheet.Pictures.Insert(r’C:/Users/Home/Desktop/picture.jpg’) 12 obj1.ShapeRange 13 obj1.ShapeRange.LockAspectRatio = msoTrue AttributeError: ‘function’ object has no attribute ‘Insert’ Answer Unless you absolutely need to use VBA, this