Azure Data Lake Excel Export To CSV as Same Folder / Path

Question

have you ever made an azure data convert Azure Data Lake excel conversion to CSV file.

first, I have tried using SSIS with Azure Data Lake Source, but when Mapping is not possible, the choice is to add text.

second, says try using azure apps logic with create CSV table but the csv that comes out is only the structure in that folder

Thank you in advance

Check this - https://stackoverflow.com/questions/2536181/is-there-any-simple-way-to-convert-xls-file-to-csv-file-excel https://stackoverflow.com/questions/42926710/converting-xlsx-file-using-to-a-csv-file https://stackoverflow.com/questions/31316551/convert-excel-file-xls-or-xlsx-to-csv-file — GRVPrasad, Feb 21 '20 at 10:26
Hi Oki Kuswanda, If my answer is helpful for you, please mark it as answer( click on the check mark beside the answer to toggle it from greyed out to filled in.). This can be beneficial to other community members. Thank you. — Leon Yue, Feb 25 '20 at 06:48

score 1 · Accepted Answer · answered Feb 24 '20 at 04:35

There is not a built-in way to extract from excel file in Azure data lake. I would suggest you to try one of the below approaches:

Write Custom .NET library for converting Excel to CSV and deploy that to Azure Data Lake Analytics. Azure Data Lake Analytics Programming Guide
Write a custom .NET activity in Azure Data Factory to do this. Custom Activities in Azure Data Factory
Use Azure Functions and Open XML do this activity as detailed in the stack overflow post
Use SSIS Package to do the conversion. You can have SSIS Runtimes in Azure Data Factory. SSIS packages running in Azure Data Factory

score 0 · Answer 2 · answered Feb 24 '20 at 03:49

As I know about Azure, These isn't any way can help convert the excel file to csv directly.

You could follow these steps:

You could reference this document:

Hope this helps.

2 Answers2