How to Hide/Delete Excel sheet using Openxml

See more:

C#3.5

OpenXML

i've done excel export using OpenXml instead of excel objects.

I've Sheet1 and sheet2.In sheet one i have dropdown list in column "C1",where i used the source data from sheet2 . Now i want to delete/hide sheet2 while exporting excel sheet without effecting dropdown data.

When i tried below code sheet2 has been deleted but i dint get any data in my dropdown.

var theSheet = workbookPart.Workbook.Descendants<DocumentFormat.OpenXml.Spreadsheet.Sheet>()
                               .FirstOrDefault(s => s.Id == relId1);
theSheet.Remove();
workbookPart.DeletePart(worksheetPart);

Kindly Lemme know if any other way for making it without effecting ddl.

thanks in advance.