How can I use python in azure function to convert files?

Question

I would like to know the code and how to do it for AzureFunction to convert a macro valid excel file (.xlsm) in gen2 to a csv file using python in azure function.

Answer 1

Hi,

This is the code from this link https://www.codegrepper.com/code-examples/python/move+excel+xlsm+to+csv+file+python

   python  
     
   import pandas as pd  
   data_xls = pd.read_excel('excelfile.xlsx', 'Sheet2', dtype=str, index_col=None)  
   data_xls.to_csv('csvfile.csv', encoding='utf-8', index=False)  

And how to create an Azure Function https://www.serverlessnotes.com/docs/create-an-azure-function-with-python

Kind regards, Kilian GOËTZ.