使用c#将xls更改为Data Lake Storage中的csv [英] Use c# to change xls to csv in Data Lake Storage
问题描述
我们有很多带有多个工作表的xls.必须手动将其更改为csvs很费时间
We have lots of xls with multiple worksheets. Having to change them manually to csvs is time consuming
有什么可以说的,创建一些c#代码以从xls创建csvs,然后可以将该功能添加到数据Lake Analytics帐户中.
Is there any way to say, create some c# code to create csvs from the xls and then possibly add the function to a data Lake Analytics account.
然后运行一些u-sql创建csvs?
Then run some u-sql to create the csvs?
这是一个远景,但我们正在寻找使用Azure自动化此方法的一种方式
Its a long shot but we are looking at some way of automating this using Azure
黛比
Debbie
推荐答案
Debbie,
Hi Debbie,
有一个图书馆可以这样做,请在这里查看:
There's a library to do so, please check it out here :
https://github.com/ExcelDataReader/ExcelDataReader#如何使用
https://github.com/ExcelDataReader/ExcelDataReader#how-to-use
此外,我发现了一篇文章,解释了如何将xls文件准确转换为csvs:
Also, I found an article explaining how exactly you can convert xls files to csvs :
https://www.codeproject.com/Articles/246772/%2FArticles%2F246772%2FConvert-xlsx-xls-to-csv
https://www.codeproject.com/Articles/246772/%2FArticles%2F246772%2FConvert-xlsx-xls-to-csv
希望这会有所帮助.
这篇关于使用c#将xls更改为Data Lake Storage中的csv的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!