如何按用户ID搜索Excel工作表并在网格视图中显示匹配的数据。 [英] how to search excel sheet by user ID and display matched data in grid view.

问题描述

我有一张excel表，它包含一些雇用详细信息，如他们的姓名地址DOB和ID号。我发现在按员工ID搜索Excel数据时出现问题，没有在数据网格中显示与输入ID相关的数据view.Please帮我解决该怎么做。如何按员工ID搜索以及如何在数据网格视图中显示。

Hi,I have an excel sheet and it contains some employ details like their name address DOB and ID no.I am finding problem in searching excel data by employee ID no.its not displaying data related to entered ID no in data grid view.Please help me out how can i do that.How to search by employee ID and how to display it in Data Grid View.

推荐答案

如果我理解你的问题正确地说，您尝试从C＃读取Excel文件以从中获取som数据。在这种情况下，看看：

- 使用MS Excel（xls / xlsx）使用MDAC和Oledb [ ^ ]

- 使用OLEDB读取和编写Excel [ ^ ]

If I understand your question correctly, you try to read the Excel file from C# to get som data out of it. IN that case, have a look at:
- Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^]
- Reading and Writing Excel using OLEDB[^]

这篇关于如何按用户ID搜索Excel工作表并在网格视图中显示匹配的数据。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！