Last post Nov 24, 2015 09:01 AM by RajahRajah
Nov 24, 2015 04:12 AM|RajahRajah|LINK
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);
Kindly Lemme know if any other way for making it without effecting ddl.
thanks in advance.
Nov 24, 2015 08:21 AM|Nan Yu|LINK
where i used the source data from sheet2 . Now i want to delete/hide sheet2 while exporting excel sheet without effecting dropdown data.
Then you could try to hide the second sheet which may not effect dropdownlist data ,set status of the sheet :
Please refer to links below for details and demo:
Or when you export to the excel . You could directly set the dropdownlist value and not create the second sheet .
Nov 24, 2015 09:01 AM|RajahRajah|LINK
This Solution worked for me after some alteration