In Azure Data Factory read excel files

azure azure-data-factory
guddu picture guddu · Dec 6, 2018 · Viewed 12.9k times · Source

I am new to Azure Data Factory(ADF), I need to access/load excel files sitting in a blob into ADF but as ADF doesn't support excel format(supports tex/csv/json/.. only) is there a way to ingest excel files into ADF? I really appreciate if anybody could help!

Thanks.

Answer

Bo Xiao picture Bo Xiao · Dec 7, 2018

ADF does not support reading from xls file yet.

You can find solutions in this answer: How to read files with .xlsx and .xls extension in Azure data factory?

Related questions

The client with object id does not have authorization to perform action 'Microsoft.DataFactory/datafactories/datapipelines/read' over scope

I was trying to invoke data factory pipeline from azure function programmatically. Its throwing following error. link: http://eatcodelive.com/2016/02/24/starting-an-azure-data-factory-pipeline-from-c-net/ AuthorizationFailed: The client 'XXXX-XXXXX-XXXX' with object id 'XXX829e05'XXXX-XXXXX' does not have authorization to perform action 'Microsoft.DataFactory/…

Read More
The subscription is not registered to use namespace 'Microsoft.DataFactory error

Going through this tutorial "Create a pipeline with Copy Activity using Visual Studio" and recieving this error when i hit publish. Error not mentioned anywhere on net and very little help/knowledge on azure generally on web.

Read More
Using Azure Data Factory to get data from a REST API

Is it possible to use Azure Data Factory to get data from a REST API and insert it to a Azure database table?

Read More