如何在Excel中检查C列中的第一个空单元格 [英] How Do I Check First Empty Cell In Column C In Excel

问题描述

Hello All，

需要一些C＃项目的帮助。我是初学者，在学习的道路上。我正在研究Excel自动化。我需要检查从C2开始的空白单元格，如果它是空白则输入数据，否则检查下一行，如果是空白则输入数据，依此类推。我有VBA代码工作正常，并尝试在我的C＃代码中实现但失败了。这是我的VBA代码

Hello All,
Need some help with a C# project. I am beginner and in a learning path. I am working on excel automation. I need to check blank cell staring from C2 and if it is blank enter data else check next row and if it is blank enter data and so on. I have VBA code which is working fine and tried to implement in my C# code but failed. Here is my VBA code

Sub Macro2()
    Dim ws As Worksheet
    Set ws = ActiveSheet
    For Each cell In ws.Columns(3).Cells
         If Len(cell) = 0 Then cell.Select: Exit For
    Next cell
End Sub

这是我的C＃代码

Here is my C# code

ExcelWorkbook w=ExcelWorkbook("Workbook1");
Excel.Range range = w.Range("C","C100");
foreach (Excel.Range r in range.Rows)
{
    if(r.Value2 == null)
    {
        r.Select();
    }
    else
    {
        i++;
    }
}

搜索谷歌上的各种文章但无法实施。请帮我处理代码。

谢谢

Sachin

Searched various article on google but unable to implement.Please help me with code.
Thanks
Sachin

推荐答案

这样的事情应该做的工作：

Somthing like that should do the work:

Workbook wb = new Application.Workbooks.Open("FullFileName.xlsx");
Worksheet ws = wb.Sheets[1];
int r = 2
while(r<100)
{
    if (!(Excel.Range)ws.Cells[r,3]==null) break;
}

但我更喜欢使用结束（） [ ^ ] property：

But i would prefer to use End()[^] property:

Microsoft.Office.Interop.Excel.XlDirection goUp = Microsoft.Office.Interop.Excel.XlDirection.xlUp;
//return first empty row
var firstEmptyCell = ws.Range("C1000").End(goUp).Row

如需了解更多信息，请参阅：

如何：使用Visual C＃功能访问Office互操作对象（C＃编程指南） [ ^ ]

这篇关于如何在Excel中检查C列中的第一个空单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！