1 package jp.satomichan.nucalgen;
3 import java.util.HashMap;
5 import java.util.Map.Entry;
8 import org.apache.poi.ss.util.CellReference;
10 public class NamedAreaStore {
12 private static NamedAreaStore instance = new NamedAreaStore();
14 private Map<String, String> namedAreaMap = new HashMap<String, String>();
16 private NamedAreaStore() {
20 static NamedAreaStore getInstance() {
21 return NamedAreaStore.instance;
24 static String getAreaString(int row1, int col1, int row2, int col2) {
25 String ret = new CellReference(row1, col1, true, true).formatAsString();
27 if(row1 != row2 || col1 != col2) {
28 ret = ret + ":" + new CellReference(row2, col2, true, true).formatAsString();
34 String save(String areaname, int row1, int col1, int row2, int col2) {
35 String area = getAreaString(row1, col1, row2, col2);
37 this.namedAreaMap.put(areaname, area);
43 String save(String areaname, int row, int col) {
44 return this.save(areaname, row, col, row, col);
48 String load(String areaName) {
49 return this.namedAreaMap.get(areaName);
53 Set<Entry<String, String>> entrySet(){
54 return this.namedAreaMap.entrySet();