Deleting Excel WorkSheet using C#

Delete excel worksheets programmatically from C#

You can delete any worksheet from Microsoft Excel file. In order to delete a worksheet, you must add a reference to the Microsoft.Office.Interop.Excel assembly, and then you must use classes from that assembly to open a workbook and delete a worksheet.The following program shows how to delete worksheet from an an existing Excel file using C#.

Excel Library

To access the object model from Visual C# .NET, you have to add the Microsoft Excel 12.0 Object Library to you project. In the previous chapter you can see a step by step instruction on how to add Excel library to your project.

How to add Excel Library

Delete worksheet from an excel file

How to delete worksheet from an excel file from C#

In order to delete worksheet from excel file, this program open an existing Excel file and select the worksheet and then delete it.

Excel.Sheets worksheets = xlWorkBook.Worksheets; worksheets[1].Delete();

Delete Excel.Worksheet without prompts

Delete Excel.Worksheet without prompt from C#

DisplayAlerts set to False for suppress prompts and alert messages while a macro is running. When a message need a response from the end user, Microsoft Excel chooses the default response. After you complete the running process, Microsoft Excel sets this property to True, unless you are running cross-process code.

The following source code shows how to programmatically delete Worksheets from Workbooks.

Full Source C#
using System; using System.Windows.Forms; using Excel = Microsoft.Office.Interop.Excel; namespace WindowsFormsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); if (xlApp == null) { MessageBox.Show("Excel is not properly installed!!"); return; } xlApp.DisplayAlerts = false; string filePath = @"d:\test.xlsx"; Excel.Workbook xlWorkBook = xlApp.Workbooks.Open(filePath, 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false); Excel.Sheets worksheets = xlWorkBook.Worksheets; worksheets[1].Delete(); xlWorkBook.Save(); xlWorkBook.Close(); releaseObject(worksheets); releaseObject(xlWorkBook); releaseObject(xlApp); MessageBox.Show("Worksheet Deleted!"); } private void releaseObject(object obj) { try { System.Runtime.InteropServices.Marshal.ReleaseComObject(obj); obj = null; } catch (Exception ex) { obj = null; MessageBox.Show("Exception Occured while releasing object " + ex.ToString()); } finally { GC.Collect(); } } } }







Related Topics
  1. How to create Excel file in C#
  2. How to open an Excel file in C#
  3. How to read an Excel file using C#
  4. How to programmatically Add New Worksheets
  5. How to format an Excel file using C#
  6. How to insert a picture in excel from C# App
  7. How to insert a background picture in excel
  8. How to create Excel Chart from C#
  9. How to export excel chart from C#
  10. How to excel chart in C# picturebox
  11. C# data validation input box in excel file
  12. Read and Import Excel File into DataSet or DataTable
  13. How to insert data to Excel file using OLEDB
  14. How to update data in Excel file using OLEDB
  15. How to export databse to excel file
  16. How to export DataGridView to excel file