I have .xlsm workbook stored in S3 bucket. I want the Lambda function to load this workbook into the EC2 instance that gets created and then do some VBA operations like running macros. Since we need Microsoft office licence to open excel sheet, I want to make sure that the EC2 server which gets provisioned by lambda service is always a windows VM. How can we make this configuration? Can you please suggest Library which might be helpful?
Can you suggest the Python Library which is invoked to run the macros inside the lambda service
This has nothing to do with Python.