Thread ID: |
Created: |
Updated: |
Platform: |
Replies: |
144310 | Apr 30,2019 06:50 AM UTC | May 2,2019 08:39 AM UTC | ASP.NET Web Forms (Classic) | 1 |
![]() |
Tags: XlsIO |
using (ExcelEngine excelEngine = new ExcelEngine())
{
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Excel2013;
IWorkbook workbook = application.Workbooks.Open("PivotTable.xlsx");
IWorksheet sheet = workbook.Worksheets[1];
IPivotTable pivotTable = sheet.PivotTables[0];
(pivotTable.Options as PivotTableOptions).IsMultiFieldFilter = true;
workbook.SaveAs("PivotFieldFilters.xlsx");
excelEngine.ThrowNotSavedOnDestroy = false;
} |
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.
This page will automatically be redirected to the sign-in page in 10 seconds.