blocks|key|4267255|text|您可以使用Range对象来完成此操作。我在这里假设您使用的是Excel互操作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4267256|假设你打开了你的书，然后设置范围，然后删除它，它应该看起来像这样|4267257|ApplicationClass+excel+=+new+ApplicationClass();
//Abrir+libro+y+seleccionar+la+hoja+adecuada+aqui
//...

Microsoft.Office.Interop.Excel.Range+cel+=+(Range)excel.Cells[rowIndex,+columnIndex];
cel.Delete();|code-block|syntax|javascript|4267258|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You can do it using a Range Object. I assume here that you are using Excel interop. 

Let say you have your book open, then set the range then delete it 
It should look something like this

<pre><code>ApplicationClass excel = new ApplicationClass();
//Abrir libro y seleccionar la hoja adecuada aqui
//...

Microsoft.Office.Interop.Excel.Range cel = (Range)excel.Cells[rowIndex, columnIndex];
cel.Delete();
</code></pre>

blocks|key|4267277|text|你可以用这个。İt正在工作..。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4267278|++++_Application+docExcel+=+new+Microsoft.Office.Interop.Excel.Application+{+Visible+=+false+};
+++dynamic+workbooksExcel+=+docExcel.Workbooks.Open(@"C:\Users\mahmut.efe\Desktop\Book4.xlsx");
+++var+worksheetExcel+=+(_Worksheet)workbooksExcel.ActiveSheet;

+++((Range)worksheetExcel.Rows[2,+Missing.Value]).Delete(XlDeleteShiftDirection.xlShiftUp);

+++workbooksExcel.Save();
+++workbooksExcel.Close(false);
+++docExcel.Application.Quit();|code-block|syntax|javascript|4267279|欲了解更多信息，请访问this网站|offset|length|4267280|entityMap|0|LINK|mutability|MUTABLE|url|http://labs.winshuttle.com/devnet/?p=120^0|0|0|B|4|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

You can use this. İt's working ...

<pre><code> _Application docExcel = new Microsoft.Office.Interop.Excel.Application { Visible = false };
 dynamic workbooksExcel = docExcel.Workbooks.Open(@"C:\Users\mahmut.efe\Desktop\Book4.xlsx");
 var worksheetExcel = (_Worksheet)workbooksExcel.ActiveSheet;

 ((Range)worksheetExcel.Rows[2, Missing.Value]).Delete(XlDeleteShiftDirection.xlShiftUp);

 workbooksExcel.Save();
 workbooksExcel.Close(false);
 docExcel.Application.Quit();
</code></pre>

For more information you can visit <a href="http://labs.winshuttle.com/devnet/?p=120" rel="noreferrer">this</a> web site

blocks|key|2370627|text|您可以指定单元格(例如，A1)，并找到包含该单元格的整个行作为一个范围，然后可以删除该行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2370628|excel.Worksheet+sheet+=+(excel.Worksheet)excelWorkBook.Sheets["sheet1"];++++
excel.Range+cells+=+(excel.Range)sheet.Range["A1",+Type.Missing];++++
excel.Range+del+=+cells.EntireRow;++++
del.Delete();|code-block|syntax|javascript|2370629|上面的代码将从sheet1中删除第一行|2370630|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You can specify a cell (eg. A1) and find the entire row containing that cell as a range and then can delete the row.

<pre><code>excel.Worksheet sheet = (excel.Worksheet)excelWorkBook.Sheets["sheet1"]; 
excel.Range cells = (excel.Range)sheet.Range["A1", Type.Missing]; 
excel.Range del = cells.EntireRow; 
del.Delete();
</code></pre>

The above given code will delete first row from sheet1

blocks|key|4356673|text|//+Here+is+the+answers+to+
//+1.+Delete+entire+row+-+Below+rows+will+shift+up
//+2.+Delete+few+cells+-+Below+cells+will+shift+up
//+3.+Clear+few+cells+-+No+shifting

using+Excel+=+Microsoft.Office.Interop.Excel;

Excel.Application+ExcelApp+=+new+Excel.Application();
++++++++++++++++++Excel.Workbook+ExcelWorkbook+=+ExcelApp.Workbooks.Open(ResultFilePath);
++++++++++++++++++ExcelApp.Visible+=+true;
++++++++++++++++++Excel.Worksheet+ExcelWorksheet+=+ExcelWorkbook.Sheets[1];

Excel.Range+TempRange+=+ExcelWorksheet.get_Range("H11",+"J15");

//+1.+To+Delete+Entire+Row+-+below+rows+will+shift+up
TempRange.EntireRow.Delete(Type.Missing);

//+2.+To+Delete+Cells+-+Below+cells+will+shift+up
TempRange.Cells.Delete(Type.Missing);

//+3.+To+clear+Cells+-+No+shifting
TempRange.Cells.Clear();|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|4356674|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>// Here is the answers to 
// 1. Delete entire row - Below rows will shift up
// 2. Delete few cells - Below cells will shift up
// 3. Clear few cells - No shifting

using Excel = Microsoft.Office.Interop.Excel;

Excel.Application ExcelApp = new Excel.Application();
 Excel.Workbook ExcelWorkbook = ExcelApp.Workbooks.Open(ResultFilePath);
 ExcelApp.Visible = true;
 Excel.Worksheet ExcelWorksheet = ExcelWorkbook.Sheets[1];

Excel.Range TempRange = ExcelWorksheet.get_Range("H11", "J15");

// 1. To Delete Entire Row - below rows will shift up
TempRange.EntireRow.Delete(Type.Missing);

// 2. To Delete Cells - Below cells will shift up
TempRange.Cells.Delete(Type.Missing);

// 3. To clear Cells - No shifting
TempRange.Cells.Clear();
</code></pre>

blocks|key|4267337|text|要删除一行，只需要一行简单的代码作为以下代码|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4267338|xlWorkSheet.Rows[NUMBER_ROW].Delete();|code-block|syntax|javascript|4267339|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

To remove a row you need an only simple row of code as a follow

<pre><code>xlWorkSheet.Rows[NUMBER_ROW].Delete();
</code></pre>

I want to write from my form (in C#) to an excel spread sheet and delete certain rows if blank.

I can write perfectly fine to a speadsheet and save it, but lets say the user entered data into row a1, a2, a3, and a4, I now want to delete all the rows in between a4 and a29. 

All I need is to find out how to delete a certain range of cells. 

Thanks

C# and excel deleting rows

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我想从我的表单(在C#中)写入excel电子表格，并删除某些空白行。我可以很好地将数据写入speadsheet并保存它，但是假设用户在a1、a2、a3和a4行中输入了数据，我现在想删除a4和a29之间的所有行。我所需要的就是找出如何删除特定范围的单元格。谢谢

问C#和excel删除行
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问C#和excel删除行EN