I would like to know the python code that converts Excel data into a csv file for each sheet.

Question

I would like to know the python code that converts Excel data into a csv file for each sheet.

NishimuraChinatsu-9854 756

I would like to know the pyhon code that converts Excel data with 3 sheets into a csv file with synapse notebook acyivity.

The image looks like the one below.

Must be pyhon because it is a macro-enabled Excel file.

![![226076-image.png ]1]1

PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2022-08-09T06:05:20.137+00:00

Hello @NishimuraChinatsu-9854 ,

Just checking in to see if the below answer provided by @Vinodh247 helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

2 answers

Your answer

PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2022-08-09T06:05:20.137+00:00

Hello @NishimuraChinatsu-9854 ,

Just checking in to see if the below answer provided by @Vinodh247 helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Answer 1

Vinodh247 34,666 MVP Volunteer Moderator

Hi NishimuraChinatsu,

Thanks for reaching out to Microsoft Q&A.

Use the below python code to convert your excel(xls, xlsm...etc) into CSV files. You can run the query in your synapse notebook, just change the path according to your requirement. I have tried this out in my synapse environment it works good.

import pandas as pd  
excel_file = 'abfss://xxxxxx*anonymous user*.dfs.core.windows.net/Financial Sample_orig-3Sheets.xlsx'  
all_sheets = pd.read_excel(excel_file, sheet_name=None)  
sheets = all_sheets.keys()  
  
for sheet_name in sheets:  
    sheet = pd.read_excel(excel_file, sheet_name=sheet_name)  
    sheet.to_csv("abfss://xxxxxxxx*anonymous user*xx.dfs.core.windows.net/%s.csv" % sheet_name, index=False)

Please Upvote and Accept as answer if the reply was helpful.

NishimuraChinatsu-9854 756 Reputation points

2022-08-01T05:19:37.51+00:00

I get an error and can't do it well.

Is it a permissions issue?
I would like to know how to solve this.

226594-%E3%82%AD%E3%83%A3%E3%83%95%E3%83%81%E3%83%A3.jpg

Answer 2

Vinodh247 34,666 MVP Volunteer Moderator

Yes it is a permission issue. To resolve this, check the below link where similar issue has been assisted.

https://learn.microsoft.com/en-us/answers/questions/779065/error-this-request-is-not-authorized-to-perform-th.html

Please Upvote and Accept as answer if the reply was helpful.

NishimuraChinatsu-9854 756 Reputation points

2022-08-01T07:38:31.763+00:00

I also granted storage blobdata contributor permissions with a managed identity, but I get the same error.

Could it be a python code issue?

Share via

I would like to know the python code that converts Excel data into a csv file for each sheet.

2 answers

Your answer