急急急!jxl操作包含宏的Excel文件后宏丢失的问题??
Mullo 2006-12-18 05:38:04 public File getExcelFile(InputStream in,List DB,File tempFile) throws JXLException,IOException,Exception
{
Workbook twb = Workbook.getWorkbook(in);
WritableWorkbook wkb = Workbook.createWorkbook(tempFile,twb);
String sheetname = twb.getSheetNames()[0];
WritableSheet sh = wkb.getSheet(0);
int row =2;
int column = 0;
int DBrow = DB.size();
int DBcolumn = SysParams.DBCOLUMN;
String data="";
Iterator DBIt = DB.iterator();
Map mp;
String key="F";
while(DBIt.hasNext())
{
mp = (Map)DBIt.next();
for(column=0;column<DBcolumn;column++)
{
key = key + (new Integer(column+1)).toString();
data=(String) mp.get(key);
if(data==null) data="";
Label label = new Label(column, row, data);
sh.addCell(label);
key="F";
}
row++;
}
wkb.write();
wkb.close();
twb.close();
return tempFile;
}
文件是一个空的包含宏的Excel文件,写入数据后生成的tempFile文件丢失宏。急急急,在线等