[jxcell]使用jxcell导入excel中重命名的单元格内容

引用jxcell.jar包

---

import java.util.HashMap;
import java.util.Iterator;
import com.jxcell.*;

public class excelImport {
@SuppressWarnings("unchecked")
public static void main(String args[])
{
try{
int colNum = 0;
int rowNum = 0;
String[] str1;
View tempView = new View();
//读取excel
tempView.read(".//44.xls");
//取出该excel中重命名单元格的个数
int numAll = tempView.getDefinedNameCount();
HashMap mapInfo = new HashMap();

//暂存单元格名称
String strName;
//暂存单元格位置字符串：如Sheet1!$B$1
String strLocal;
//暂存单元格中内容
String strValue;
String strA = "A";
//如果表格范围超过26列 将字母列数转化为整数
char[] colChar;
char charA = 'A';
for(int i = 1;i <= numAll;i++)
{
strName = tempView.getDefinedName(i);
strLocal = tempView.getDefinedName(strName);
//分