Problem with row header that has a line feed

Jul 27, 2016 at 8:09 PM
I have XLS file whose column header has a line feed (char(10))

I refer to it on the pivot table and add it to RowFields.
But, when I open the XLS file, it didn't add that to the pivot table.
How can I fix it ?

var OpenClosedField = pivotTable1.Fields[1]; //--> this is the column whose header has the line feed
var countField = pivotTable1.Fields[1];
pivotTable1.DataFields[0].Function = OfficeOpenXml.Table.PivotTable.DataFieldFunctions.Count;

Thank you.