如何使用Openxml隐藏/删除Excel工作表 [英] How to Hide/Delete Excel sheet using Openxml

问题描述

我已经使用OpenXml而不是excel对象进行了excel导出。



我是Sheet1和sheet2.In第一张我在C1列中有下拉列表，我使用了sheet2的源数据。现在我想删除/隐藏sheet2，同时导出excel表而不影响下拉数据。



当我尝试下面时，代码sheet2已被删除，但我得到了我的任何数据下拉菜单。

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);

亲爱的Lemme知道是否有任何其他方式来制作它而不影响ddl。



提前感谢。

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

thanks in advance.

推荐答案

此解决方案经过一些修改后对我有用



https://social.msdn.microsoft.com/Forums/en-US/7191e89b-ef46-423f-b099-d98750f3fefd/hide-column-in-excel-using-openxml [< a href =https://social.msdn.microsoft.com/Forums/en-US/7191e89b-ef46-423f-b099-d98750f3fefd/hide-column-in-excel-using-openxml\"target =_ blanktitle =新窗口> ^ ]

This Solution worked for me after some alteration

https://social.msdn.microsoft.com/Forums/en-US/7191e89b-ef46-423f-b099-d98750f3fefd/hide-column-in-excel-using-openxml[^]

这篇关于如何使用Openxml隐藏/删除Excel工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！