您好...请帮助我，如何使用C＃修剪excel表中的空行？提前致谢... [英] Hello... Can you please assist me, how to trim empty rown in an excel sheet using C#? Thanks in advance...

问题描述

如果我从Excel工作表中删除一些行，然后如果我尝试上传，我的数据表中会出现空行。



我有什么试过：

If i delete some rows from excel sheet and then if i try to upload that i am getting empty rows in my datatable.

What I have tried:

static void DeleteBlankRows(string FILEPATH, string EXTENSION)
        {
            Microsoft.Office.Interop.Excel.Application application = new Microsoft.Office.Interop.Excel.Application();
            //This is my test excel file;
            Microsoft.Office.Interop.Excel.Workbook exceldoc = application.Workbooks.Open(FILEPATH);

            Worksheet exlwooksheet = (Microsoft.Office.Interop.Excel.Worksheet)exceldoc.Sheets["Sheet4"];

            var LastRow = exlwooksheet.UsedRange.Rows.Count;
            LastRow = LastRow + exlwooksheet.UsedRange.Row - 1;
            int i = 0;
            for (i = 1; i <= LastRow; i++)
            {
                if (application.WorksheetFunction.CountA(exlwooksheet.Rows[i]) == 0)
                    (exlwooksheet.Rows[i] as Microsoft.Office.Interop.Excel.Range).Delete();
            }

            exceldoc.Save();
            exceldoc.Close();
        }

推荐答案

参见Range.Delete Method（Excel） [ ^ ]。

这篇关于您好...请帮助我，如何使用C＃修剪excel表中的空行？提前致谢...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！