Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,879 questions
The below 2 blogs provides step by step way to load all excel tabs dynamically :
load excel sheet in adf
![](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(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vineet S
1,090
Reputation points
Hi, wants to load excel sheet into ADF pipeline but it should write all the tab from it to the blob storage how to add all sheets from excel sheet to the load
{count} votes
-
AnnuKumari-MSFT 33,476 Reputation points Microsoft Employee2024-08-26T10:45:52.2966667+00:00 Hi Vineet S ,
Just following up to see if the below answer helped. Please do consider clicking
Accept Answeras accepted answers help community as well. Also, please click onYesfor the survey 'Was the answer helpful'
Sign in to comment
1 answer
Sort by: Most helpful
-
Nandan Hegde 32,421 Reputation points MVP2024-08-02T14:28:37.8366667+00:00 -
Vineet S 1,090 Reputation points
2024-08-02T15:22:45.59+00:00 but i want to convert into parquet file
-
Nandan Hegde 32,421 Reputation points MVP
2024-08-05T11:10:00.5866667+00:00 You can update the sink dataset type from delimited type to parquet type in the above blog
-
AnnuKumari-MSFT 33,476 Reputation points Microsoft Employee
2024-08-07T05:41:34.2466667+00:00 Hi Vineet S ,
To load the excel data into parquet format , you can use parquet as the sink dataset present in ADLS/Blob dataset. Did you give it a try? Kindly share What issue are you facing ? Thanks
If the above answer helped in resolving your query, kindly accept it by clicking on
Accept answerbutton . Thankyou -
Vineet S 1,090 Reputation points
2024-08-07T05:44:47.6666667+00:00 It should copy only those sheet that is mention in excel sheet name
-
Vineet S 1,090 Reputation points
2024-08-07T05:50:02.5733333+00:00 But I want load those sheet only whose name is in file name
-
AnnuKumari-MSFT 33,476 Reputation points Microsoft Employee
2024-08-26T10:45:28.4833333+00:00 Vineet S ,
You can create a SQL table having all the sheet names and use foreach to loop through the sheet names and then in the excel dataset, use dynamic content to use @item().sheetname so that it fetches only the required sheet names.
Sign in to comment -