This article demonstrates how to delete images from an excel worksheet using Spire.XLS component and C#. Below is the screenshot of the sample file we used for demonstration:
Detail steps:
Step 1: Initialize an object of Workbook class and load the excel file.
Workbook workbook = new Workbook(); workbook.LoadFromFile("Input.xlsx");
Step 2: Get the first worksheet.
Worksheet sheet = workbook.Worksheets[0];
Step 3: Delete all images from the worksheet.
for (int i = sheet.Pictures.Count-1; i >= 0; i--) { sheet.Pictures[i].Remove(); }
Step 4: Save the file.
workbook.SaveToFile("DeleteImages.xlsx", ExcelVersion.Version2013);
Output:
Full code:
using Spire.Xls; namespace DeleteImages { class Program { static void Main(string[] args) { Workbook workbook = new Workbook(); workbook.LoadFromFile("Input.xlsx"); Worksheet sheet = workbook.Worksheets[0]; for (int i = sheet.Pictures.Count-1; i >= 0; i--) { sheet.Pictures[i].Remove(); } workbook.SaveToFile("DeleteImages.xlsx", ExcelVersion.Version2013); } } }