This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 81%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
I have several excel files in a blob storage folder, each excel file has some sheets.
I need to get each file name and each sheet name, and then, insert them in a database.
Eg: insert into dbo.FilesNames (FileName, SheetName)
I need to repeat this for each sheet and file.
Thanks.
Regards,
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Hello Martin,
Welcome to the Microsoft q&a platform , and for posting your question.
We have had similar question answered in this thread
Referenced blog to use the ADF activities to get sheet names dynamically- https://datasharkx.wordpress.com/2022/08/31/iterating-across-all-excel-sheets-dynamically-and-converting-into-csv-files-via-azure-data-factory-synapse-pipeline/
It is also possible by creating an azure function and using pandas library as mentioned here
Hope either of these will be helpful for you to achieve what you want.
If not feel free to let us know. Thanks
Hi Subashri!
Thanks for your comments.
I think it is in order to insert the content of the sheets, but I need to insert the file name and the sheet name in a database.
For example I have two excel files with two sheets:
1- File: Product.xlsx
Sheet1: List
Sheet2: Amount
2- File: User.xlsx
Sheet1: Name
Sheet2: Category
So I need insert those values in the database .
Insert into dbo.Files (FileName, SheetName)
values ('Product', 'List')
Insert into dbo.Files (FileName, SheetName)
values ('Product', 'Amount ')
Insert into dbo.Files (FileName, SheetName)
values ('User', 'Name')
Insert into dbo.Files (FileName, SheetName)
values ('User', 'Category')
Thanks.
Regards,
Hi Martin . request you to use python as shown here, as there's no dynamic way to get sheet names using ADF activities. https://stackoverflow.com/questions/67541195/adf-how-to-copy-an-excel-sheet-with-multiple-sheets-into-separate-csv-files