VB.NET - 读取CSV文件，查找特定数据 [英] VB.NET - Read CSV file, look for specific data

问题描述

这是交易：


我有一个基本的VB.NET（2012）应用程序，我编写了该应用程序以查找特定的CSV文件。但这就是它停止的原因我被卡住了。


我需要发生的是当我点击一个按钮时，我想要一个窗口弹出来找我找到CSV文件。


然后，我需要我的应用来处理所述CSV文件以查找关键字。在这种情况下：User_Licenses

一旦找到它，它需要计算它下面的TRUE，直到它到达一个空单元格并用数字填充标签。 （有关CSV样本，请参见下图）

Here is the deal:

I have a basic VB.NET (2012) app that I have coded to look for a specific CSV file. But that is where it stops cause I am stuck.

what I need to happen is when I click a button, I want a window to pop up for me to locate the CSV file.

THEN, I need my app to process said CSV file looking for a keyword. In this case: User_Licenses
Once it finds it, It needs to count the TRUE''s below it till it hit an empty cell and populate a label with the number. (See image below for the CSV sample)

推荐答案

请向我们展示您尝试过的代码和告诉我们你遇到了什么问题。

Please show us the code you''ve tried and tell us what problem you''re having with it.

让我澄清一下，我唯一能成功做的就是搜索User_Licenses这个词，我不知道在那一点之后该怎么做。我知道我需要做一些循环并寻找一个空白单元格，但坦率地说，不知道正确/有效的方法。我将继续搜索网络。

Let me clarify, the only thing I have been able to do successfully is search for the word User_Licenses and I don''t know what to do after that point. I know I need to do some kind of loop and look for a blank cell but just frankly don''t know the proper/efficient way of doing it. I will continue to search the net.

仍然需要查看你的代码。

Still need to see your code.

这篇关于VB.NET - 读取CSV文件，查找特定数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！