Formula address from column and row numbers in SmartXLS (java)

Question

How can I get the formula address of a cell knowing the column and the row numbers? I want to use it to link a dynamic data source to a chart. THX

Answer 1

You can use the formatRCNr method:

String rangestr = workBook.formatRCNr(0, 0, false) + ":" + workBook.formatRCNr(2, 2, false); //A1:C2