I am trying to read range from excel and writing or appending in another sheet using Microsoft.Office.Interop.Excel in c#. While writing or appending data existing data format is not copy like number, text, currency and date etc. If data type is currency then it convert into text or general...
If source data on Sheet1!A1:F12 and pivot table on Sheet2!A1:B8. The give code returning Sheet1!A1:F12 but I want Sheet2!A1:B8 this result. The Pivot table targeted range . I have attached file. PFA.
I am writing code for get pivot table range using ClosedXML library. Using below code I am getting source data range but not getting table range. Eg.
IXLPivotTable xLPTable = this.CurrentWorksheet.PivotTable(tblName);
return xLPTable.SourceRange.ToString();
Is there other way to get pivot...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.