question

RaviNadipalli-9402 avatar image
0 Votes"
RaviNadipalli-9402 asked SaurabhSharma-msft commented

How to work with Excel files having spaces in Sheet names in Azure Data Factory?

Hi,

I'm using Excel file with multiple sheets from Azure File Storage in my Dataset in Azure Data Factory.

It is working fine when sheet names don't have spaces, but it is not working when there are spaces in sheet names.

I tried to enclose sheet name by single quote ', double quote " and square brackets [ ], but nothing worked.

Please let me know if there is any solution for this problem. Thanks.

Regards,
Ravi



azure-data-factory
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ravinadipalli-9402,
Thanks for using Microsoft Q&A !!
Are you using Excel files as source or sink. I have tried reading an excel file having sheet name with spaces in Copy Data activity and it works as expected. See screenshot below -
126417-image.png

Thanks
Saurabh

1 Vote 1 ·
image.png (37.8 KiB)

1 Answer

RaviNadipalli-9402 avatar image
1 Vote"
RaviNadipalli-9402 answered SaurabhSharma-msft commented

My apologies for late reply. I'm using Excel (in Dataset) as Source.

I was checking "Preview data" in Dataset's Connection tab, and it was giving the error. Hence posted this question.

However, it is working fine when Pipeline is run, without any issues.

Thanks for your reply Saurabh.

Regards,
Ravi

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ravinadipalli-9402,
Good to know that it worked for you.

Thanks
Saurabh

0 Votes 0 ·