如何使用多个模板从excel读取数据 [英] How do I read data from excel with multiple template
问题描述
Hi Techies,
我有业务要求从excel读取数据,这将有多个模板。
示例:Excel 1 - > ClientName可能在列#2上,Age可能在列#10
Excel 2 - > ClientName可能位于第20列,Age可能是第1列
基本上,列的顺序可能不同,某些时间合并列也可能。
每个客户都有自己的模板和指定的数据,因此我不能强迫他们使用标准模板
您的技术解决方案将是非常感谢。
我的尝试:
思考机器学习..但我不确定
Hi Techies,
I have a business requirement of reading data from excel which will have multiple templates.
Example : Excel 1 -> ClientName may be on column #2 and Age may be column #10
Excel 2 -> ClientName may be on column #20 and Age may be column #1
Basically, the order of column may different and some time merged column also.
Each client will have their own template with specified data, hence I cannot force them to use a standard template
Your technical solution would be much appreciated.
What I have tried:
Thinking of Machine Learning.. but I am not sure
推荐答案
参见使用MS Excel(xls / xlsx)使用MDAC和Oledb [ ^ ]和Microsoft.Office.Interop.Excel命名空间| Microsoft Docs [ ^ ]。在任何一种情况下,您都可以使用实际的列名来查找数据。
See Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^] and Microsoft.Office.Interop.Excel Namespace | Microsoft Docs[^]. In either case you can use the actual column names to find your data.
这篇关于如何使用多个模板从excel读取数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!