找到ecxel的最后一行值 [英] find ecxel last row value

问题描述

我想在一个单元格中解析Excel工作表的最后一行的值，这是我的代码，它返回第一行单元格值：

I want to parse the value of last row of an Excel worksheet af a cell, here is my code wich returns the First row cell value :

Dim instance As XlFileAccess
       workbook = APP.Workbooks.Open("C:\Users\supervisor\Documents\Visual Studio 2008\projects\email\email\email stats2.xlsx")
               worksheet = workbook.Sheets("stats")
               Dim lastrow As Range = worksheet.Rows.End(XlDirection.xlUp)
            TextBox2.Text = worksheet.Rows(lastrow.Row.count, 2).Value
       workbook.Save()
       workbook.Close("C:\Users\supervisor\Documents\Visual Studio 2008\projects\email\email\email stats2.xlsx")

       APP.ActiveWorkbook.Close("C:\Users\supervisor\Documents\Visual Studio 2008\projects\email\email\email stats2.xlsx")
       APP.Quit()

   End Sub

推荐答案

试试这个

Try this

Dim findme As Range = excel.Range("A1:A" & lastrow.row)

您也可以查看以下链接。

http://www.siddharthrout.com/2012/10/02/find- last-in-an-excel-sheetvbavb-net / [ ^ ]

这篇关于找到ecxel的最后一行值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！