We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Get starting point and ending point of Pivot Table without $ sign

I am using aspose-cell for JAVA version:18.4

PivotTableCollection ptc = ws.getPivotTables();
String pivotDataSource = ptc.get(i).getDataSource()[0];//The value is  '\Users\abc.kumar\Documents\Axy Report\[Axy.xlsx]Macroeco'!$B$12:$AM$13
String startPosition = pivotDataSource.split("!")[1].split(":")[0];//Value is $B$12

How do I get the startPosition as B12 instead of $B$12?


You may use some Java API for the task. See the sample line of code that you may add to your code segment:
Sample code:

startPosition = startPosition.replace("$", "");