Hello,
I am creating an excel workbook with a pivot table on one worksheet, and I have a calculated field for that pivot table that I need to conditionally format. I looked at the formatting section for the pivot table in the documentation, and there was nothing there about how to add formatting to individual cells/columns in the pivot table. I came across this post that talks about conditional formatting in a pivot table, but it didn't help resolve my issue. The solution that was proposed in the post was to use the
IPivotTable.Layout()
function, but when I used it in my code, the calculated field values were all zeros; the Layout function, in the notes of it in Visual Studio said "This property is not supported in... ASP.NET Core platforms." So, it seems I can't use this either.
I have found no other applicable posts for this issue, nor anything in the documentation. Is conditional formatting for pivot tables in XlsIO for ASP.NET Core not supported?
I have attached a code snippet where I am testing creating the excel spreadsheet.
Attachment:
ExcelExport_420eb2bc.zip
