如何在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;
}
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屋!