Regarding a Deleting a Worksheet from Workbook

[akhil007]

I have created a worksheet dynamically and then try to delete it at the end but when I delete the worksheet and try to save the workbook , a Null Pointer Exception is thrown . Please help me out . Thank you

Sample Code :-

Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];
worksheet.Name = "Sheet 7777";
worksheet.Range["A3"].Text = "Hello World";
workbook.SaveToFile("NEw File.xlsx", ExcelVersion.Version2016);
Worksheet sheet = workbook.Worksheets[1];
sheet.Name = "Hello";
workbook.SaveToFile("NEw File.xlsx", ExcelVersion.Version2016);
workbook.Worksheets.Remove("Sheet 7777"); // tried both , same exception is thrown
//workbook.Worksheets[0].Remove();
workbook.SaveToFile("NEw File.xlsx", ExcelVersion.Version2016);

[Lisa.Li]

Hello Akhil,

Thanks for your inquiry.
Please add below code to load the xlsx file before removing a worksheet. If you have other questions, please do not hesitate to contact us.

Code: Select all

workbook.LoadFromFile("NEw File.xlsx");

Sincerely,
Lisa
E-iceblue support team

[Lisa.Li]

Hello Akhil,

Greetings from E-iceblue.
Did my code help you? Your feedback will be greatly appreciated.

Sincerely,
Lisa
E-iceblue support team