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

Aspose.Cells Product Family
1

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?

2

@sandipanghosh111,

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

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