16,554
社区成员
发帖
与我相关
我的任务
分享
Imports Spire.Xls
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim workbook As Workbook = New Workbook()
workbook.LoadFromFile("Input.xlsx")
Dim sheet As Worksheet = workbook.Worksheets(0)
'Dim cell As CellRange = sheet.Range("A1:A10").FindString(TextBox1.Text, False, False)
Dim cell As CellRange = sheet.Columns(0).FindString(TextBox1.Text, False, False)
If cell IsNot Nothing Then
MessageBox.Show("此批号已纳入黑名单")
End If
End Sub
End Class