通过C#检索Excel中的最后一个空白行 [英] Retrieve Last Blank row in Excel through C#

问题描述

Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
object misValue = Missing.Value;
               
Workbook wb = xlApp.Workbooks.Open("C:\\1001\\Vineet.xls");
Worksheet ws = (Worksheet)wb.Worksheets[1];
               
int lastUsedRow = ws.Cells.SpecialCells(XlCellType.xlCellTypeLastCell, misValue).Row;
wb.Close();

MessageBox.Show(lastUsedRow.ToString());

上面的代码返回1.

Above code return 1.

推荐答案

您的代码正在查找最后一个使用的行，并且看起来不错. 但是，由于您要问的是最后空白行，您实际上是在问尽可能多的行吗?
如果是，则应为65,536.

Your code is finding last used row and looks fine.
But since you are asking last blank row, are you actually asking the largest possible number of rows?
If yes, it should be 65,536.

Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
            object misValue = Missing.Value;
            Workbook wb = xlApp.Workbooks.Open("C:\\1001\\Vineet.xls");
            Worksheet ws = (Worksheet)wb.Worksheets[1]; 
                int sum = 0;
                Range count;
                count = ws.UsedRange.Columns[1,misValue] as Range;
                foreach (Range cell in count.Cells)
                {                   
                        sum += 1;                    
                }               
                wb.Close();
                MessageBox.Show(sum.ToString());

上面的代码将检索"6"

Above code will retrieve "6"

这篇关于通过C#检索Excel中的最后一个空白行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！