Find first non blank cell in column with vb.net

2020-05-03 02:23发布

问题:

In an Excel table, how do I find the first cell containing data?

回答1:

you can use this link

you can also use

    If xlDataSheet.Cells(1, iCurrDataColumn).value Is Nothing Then 
    '.... do something 
    else
    '.....do something


标签: vb.net excel