import java.util.Map;
import java.util.Map.Entry;
import java.util.Set;
+import java.util.regex.Matcher;
+import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.util.CellReference;
public class NamedAreaStore {
String save(String areaname, int row1, int col1, int row2, int col2) {
String area = getAreaString(row1, col1, row2, col2);
-
+ areaname = Matcher.quoteReplacement(areaname);
this.namedAreaMap.put(areaname, area);
return area;
}
+ String save(String areaname, Cell cell) {
+ return this.save(areaname, cell.getRowIndex(), cell.getColumnIndex());
+ }
+
+
String load(String areaName) {
+ areaName = Matcher.quoteReplacement(areaName);
return this.namedAreaMap.get(areaName);
}