如何使用每个数据流将Excel文件从Azure数据湖复制到Azure SQL数据库？
我有一个 Excel 文件，下面没有第一列的列名称。
我需要将此文件从数据湖导出到 SQL 数据库。我每天都会在数据湖中获取相同格式的 Excel 文件。
我尝试使用数据流，但是，我收到错误“数据流中现在不支持读取具有不同架构的 excel 文件”
根据文档建议，将使用 foreach 和数据流来解决此问题。
我已经尝试过每个但没有成功。我是 Azure 的新手。所以不确定我应该使用哪种方法？我已经使用了复制活动，但无法获取没有该列的第一列，
请问有人可以建议如何解决此问题吗？
I am having an excel file below which doesn't have column name for the first column.
I need to export this file from the data lake to the SQL database. I am getting the same format of excel file every day in my data lake.
I tried with dataflow, however, I am getting an error of "Read excel files with different schema is not supported now in Dataflow"
As per the documentation suggestion, foreach and dataflow are to be used for this issue.
I have tried for each but had no success. I am new to Azure. So not sure which method I should use? I have used copy activity, but was not able to get the first column which doesn't have the column
Can anyone advise how to solve this issue, please?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您可以创建一个数据流，其中源作为数据湖 Excel（第一行作为标题，未选中），然后添加一个过滤器，其中过滤条件应消除第一行，最后使用接收器作为 Azure SQL 数据库。以下是您可以配置的屏幕截图：
在过滤器设置中，只需编写将跳过第一行的任何条件，如上面屏幕截图中突出显示的那样。
You can create a dataflow with source as your Data lake excel (first row as header as unchecked), then add a filter where filter condition should eliminate the first row and then finally using the sink as Azure SQL Database. Below is the screenshot of something you can configure:
In filter setting, just write any condition that will skip the first row as highlighted in the screenshot above.