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?
This has nothing to do with Python.