C#操作ExceL文件怎么删除指定行？

Question

C#操作ExceL文件怎么删除指定行？

Answer 1

把excel当成数据库操作就可以了

Answer 2

Excel.ApplicationClass objApp = new Excel.ApplicationClass();
Excel.WorkbookClass objBook = objApp.Workbooks.Add(System.Reflection.Missing.Value);
Excel.WorksheetClass objSheet = objBook.Worksheets.get_Item(1);
//...objSheet.rows(???).delete();

Answer 3

worksheet.rows(index).delete();  好像不行我是想把EXCEL第一行空行删除掉,如果用数据源,该怎么写sql?

Answer 4

Worksheet.rows.delete(0);不能删除指定行,它把整个SHEET里的数据全部删除了,
高手告一下,怎么才能搞定指定行啊

Answer 5

/// <summary>
        /// 删除行
        /// </summary>
        /// <param name="rowIndex"></param>
        /// <param name="count"></param>
        public void DeleteRows(int rowIndex, int count)
        {
            try
            {
                for (int n = 1; n <= this.WorkSheetCount; n++)
                {
                    workSheet = (Excel.Worksheet)workBook.Worksheets[n];
                    range = (Excel.Range)workSheet.Rows[rowIndex, this.missing];                    for (int i = 0; i < count; i++)
                    {
                        range.Delete(Excel.XlDirection.xlDown);
                    }
                }
            }
            catch (Exception e)
            {
                this.KillExcelProcess();
                throw e;
            }
        }