Search results for query: *

  1. Sachin Patil

    Question Read and Write range with existing data format in excel?

    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...
  2. Sachin Patil

    Answered How to get pivot table range using Closedxml worksheet?

    TargetCell property return only first cell address of table only not a table range
  3. Sachin Patil

    Answered How to get pivot table range using Closedxml worksheet?

    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.
  4. Sachin Patil

    Answered How to get pivot table range using Closedxml worksheet?

    Yes , I want Pivot table targeted cell range.
  5. Sachin Patil

    Answered How to get pivot table range using Closedxml worksheet?

    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...
Back
Top Bottom