private void DelHiddenWs_Click(object sender, EventArgs e)
{
TryRun(() =>
{
string filePath = filePath1.Text.Trim().移除路径前后引号();
if (string.IsNullOrEmpty(filePath))
{
MessageBox.Show("路径不能为空");
return;
}
if (string.Compare(".xlsx", System.IO.Path.GetExtension(filePath), true) != 0)
{
MessageBox.Show("只支持.xlsx文件");
return;
}
using (var ms = new MemoryStream())
using (var fs = new FileStream(filePath, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
using (var excelPackage = new ExcelPackage(fs))
{
EPPlusHelper.DeleteWorksheet(excelPackage, eWorkSheetHidden.Hidden, eWorkSheetHidden.VeryHidden);
excelPackage.SaveAs(ms);
ms.Position = 0;
var fileDir = Path.GetDirectoryName(filePath);
var fileName = Path.GetFileNameWithoutExtension(filePath);
string filePathOut = Path.Combine(fileDir, $"{fileName}_OnlyVisibleWS.xlsx");
ms.Save(filePathOut);
MessageBox.Show($"文件已经生成,在目录'{fileDir}'");
WinFormHelper.OpenDirectory(fileDir);
}
});
}