Hello @NishimuraChinatsu-9854 ,
Thanks for the question and using MS Q&A platform.
MS Q&A platform is only support question in English language only.
As the question is posted in posted in Japanese language, I had used Google translator to convert to English.
As I understand, you want to convert .xlsx to csv of Excel data in azure synapse pipeline.
You can use pandas to convert Excel to CSV in Azure Synapse Analytics.
The below code snippet helps to convert Excel to CSV:
#importing pandas as pd
import pandas as pd
# Read and store content
# of an excel file
read_file = pd.read_excel ("Test.xlsx")
# Write the dataframe object
# into csv file
read_file.to_csv ("Test.csv",
index = None,
header=True)
# read csv file and convert
# into a dataframe object
df = pd.DataFrame(pd.read_csv("Test.csv"))
# show the dataframe
df
Hope this will help. Please let us know if any further queries.
------------------------------
- Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
- Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators