一部分代碼如下,剩下的思路就搞不出來了(有報錯):public class TestJxl {public static void main(String args[]){JFileChooser jfc=new JFileChooser();jfc.showOpenDialog(null);File f1=jfc.getSelectedFile();int q,w;List list=new ArrayList();try{// 構(gòu)建Workbook對象, 只讀Workbook對象// 直接從本地文件創(chuàng)建Workbook, 從輸入流創(chuàng)建WorkbookFileInputStream fis=new FileInputStream(f1);Workbook wb1=Workbook.getWorkbook(f1);jxl.Sheet st=wb1.getSheet(0);Cell cell=null;q=st.getColumns();w=st.getRows();for(int i=0;i<q;i++){for(int j=0;j<w;j++){cell=st.getCell(i, j);list.add(cell.getContents());}}for(String ss:list){System.out.println(ss);}System.out.println(list.get(0));wb1.close();fis.close();jfc.showSaveDialog(null);File f2=jfc.getSelectedFile();FileOutputStream fos=new FileOutputStream(f2);//獲取可寫工作簿W(wǎng)ritableWorkbook wwb=Workbook.createWorkbook(fos);// 讀取第一張工作表WritableSheet dataSheet=wwb.getSheet(0);// 設(shè)置凍結(jié)單元格dataSheet.getSettings().setVerticalFreeze(5);dataSheet.getSettings().setHorizontalFreeze(4);int y=0;for(int i=0;i<q;i++){for(int j=5;j<5+w;j++){dataSheet.addCell(new Label(i, j, list.get(y++)));}}wwb.write();wwb.close();fos.close();}catch(Exception ex){ex.printStackTrace();}}}java.lang.IndexOutOfBoundsException: Index: 0, Size: 0at java.util.ArrayList.RangeCheck(ArrayList.java:547)at java.util.ArrayList.get(ArrayList.java:322)at jxl.write.biff.WritableWorkbookImpl.getSheet(WritableWorkbookImpl.java:408)at test.TestJxl.main(TestJxl.java:67)
添加回答
舉報
0/150
提交
取消