Copy same file name sheet

Question

Copy same file name sheet

Vineet S 1,370

Hi how to copy same file name like ' in sheet name for coping data from excel sheet to blob storage ig. Excel sheet name is test1 and sheet name is test1 and some characters.. How to copy these files blob storage

Vinodh247 30,521 Reputation points MVP

2024-08-04T14:22:12.9533333+00:00
if i understand your ask correctly, can you try the following?

in source settings:

While copying in adf, specify the sheet name. For instance, In the File loading behavior, select the option to load data from a specific sheet. You can specify the sheet name as "test1" here.

in destination:

In the File name field, you can set the output file name to match the sheet name. You may need to use dynamic content to achieve this, for example, by using an expression like @concat('test1', '.xlsx') to ensure the file name is "test1.xlsx".
NIKHILA NETHIKUNTA 4,600 Reputation points Microsoft External Staff

2024-08-06T04:25:53.4566667+00:00

Hi @Vineet S
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Vinodh247 30,521 Reputation points MVP

2024-08-07T13:04:17.2166667+00:00

Vineet S: In case if you have any resolution, please share the same here with the community as it can be helpful to others. Else, please respond with more details and we will try to see if we can help further.
Vineet S 1,370 Reputation points

2024-08-07T13:27:54.27+00:00

It should take dynamically for an example File1 --- file1_1 ,, file2 --- file2_1 it should lookup like conditions ie sheet name like 'file1%' so file should read and take sheet using like conditions
Vinodh247 30,521 Reputation points MVP

2024-08-07T14:22:28.27+00:00
is this the approach you are trying? can you explain

Use a Lookup activity to read the sheet names from the Excel file.

Configure the Lookup activity to connect to your Excel file in Blob Storage.

Set the First row only option to FALSE so that it retrieves all rows, which will include all sheet names.

Get Metadata Activity:

After the Lookup activity, add a Get Metadata activity to get the metadata for the Excel file.

Set the dataset to point to your Excel file in Blob Storage.

In the field list, select Sheet names to retrieve the names of all sheets in the Excel file.

Filter Sheet Names:

Add a Filter activity to filter the sheet names based on your criteria (e.g., using a condition like @contains(item().name, 'file1')). This will allow you to dynamically filter sheet names that match your pattern (like 'file1%').
NIKHILA NETHIKUNTA 4,600 Reputation points Microsoft External Staff

2024-08-08T16:31:34.92+00:00

Hi @Vineet S
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Your answer

Vinodh247 30,521 Reputation points MVP

2024-08-04T14:22:12.9533333+00:00

if i understand your ask correctly, can you try the following?

in source settings:

While copying in adf, specify the sheet name. For instance, In the File loading behavior, select the option to load data from a specific sheet. You can specify the sheet name as "test1" here.

in destination:

In the File name field, you can set the output file name to match the sheet name. You may need to use dynamic content to achieve this, for example, by using an expression like @concat('test1', '.xlsx') to ensure the file name is "test1.xlsx".
NIKHILA NETHIKUNTA 4,600 Reputation points Microsoft External Staff

2024-08-06T04:25:53.4566667+00:00

Hi @Vineet S
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Vinodh247 30,521 Reputation points MVP

2024-08-07T13:04:17.2166667+00:00

Vineet S: In case if you have any resolution, please share the same here with the community as it can be helpful to others. Else, please respond with more details and we will try to see if we can help further.
Vineet S 1,370 Reputation points

2024-08-07T13:27:54.27+00:00

It should take dynamically for an example File1 --- file1_1 ,, file2 --- file2_1 it should lookup like conditions ie sheet name like 'file1%' so file should read and take sheet using like conditions
Vinodh247 30,521 Reputation points MVP

2024-08-07T14:22:28.27+00:00

is this the approach you are trying? can you explain

Use a Lookup activity to read the sheet names from the Excel file.

Configure the Lookup activity to connect to your Excel file in Blob Storage.

Set the First row only option to FALSE so that it retrieves all rows, which will include all sheet names.

Get Metadata Activity:

After the Lookup activity, add a Get Metadata activity to get the metadata for the Excel file.

Set the dataset to point to your Excel file in Blob Storage.

In the field list, select Sheet names to retrieve the names of all sheets in the Excel file.

Filter Sheet Names:

Add a Filter activity to filter the sheet names based on your criteria (e.g., using a condition like @contains(item().name, 'file1')). This will allow you to dynamically filter sheet names that match your pattern (like 'file1%').
NIKHILA NETHIKUNTA 4,600 Reputation points Microsoft External Staff

2024-08-08T16:31:34.92+00:00

Hi @Vineet S
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

Copy same file name sheet

Your answer