Getting ec2 details in xlsx format

Question

I am able to get all the ec2 instance details in csv format using boto3.But i am not able to print all the ec2 instance details in xlsx file.

enter code here

can any one suggest how to print all the ec2 details in the account?

Answer 1

The question is unclear. What script did you use to get the csv format?

If you used create_data_set, you could follow the boto3 documentation here.

If your script is working fine for csv files or already have the csv files, then you can just use xlsxwriter or openpyxl as stated in this solution.

And honestly once you have csv files, you can simply open in a spreadsheet software like microsoft excel and use the 'save as' operation.