try
??{
??Workbook book=Workbook.getWorkbook(new File("F:/gw_work/2006-8-31/all.xls"));
???? Sheet sheet=book.getSheet(2);
???? int rowcnt=sheet.getRows();
???? int columns=sheet.getColumns();
???? String data[]=new String[columns];
???? System.out.println(data.length);
???? for(int i=0;i<rowcnt;i++)
???? {
???? ?
???? ?for(int j=0;j<columns;j++)
???? ?{
???? ??Cell cell1=sheet.getCell(j,i);
????String result=cell1.getContents();
????data[j]=result;
????System.out.print(result+"\t");
???? ?}
???? ?System.out.println("in----------------------");
???? ?Mysql.upData(data);
???? ?System.out.println("out----------------------");
???? }
????
????
?} catch (BiffException e) {
??// TODO Auto-generated catch block
??e.printStackTrace();
?} catch (IOException e) {
??// TODO Auto-generated catch block
??e.printStackTrace();
?}
??{
??Workbook book=Workbook.getWorkbook(new File("F:/gw_work/2006-8-31/all.xls"));
???? Sheet sheet=book.getSheet(2);
???? int rowcnt=sheet.getRows();
???? int columns=sheet.getColumns();
???? String data[]=new String[columns];
???? System.out.println(data.length);
???? for(int i=0;i<rowcnt;i++)
???? {
???? ?
???? ?for(int j=0;j<columns;j++)
???? ?{
???? ??Cell cell1=sheet.getCell(j,i);
????String result=cell1.getContents();
????data[j]=result;
????System.out.print(result+"\t");
???? ?}
???? ?System.out.println("in----------------------");
???? ?Mysql.upData(data);
???? ?System.out.println("out----------------------");
???? }
????
????
?} catch (BiffException e) {
??// TODO Auto-generated catch block
??e.printStackTrace();
?} catch (IOException e) {
??// TODO Auto-generated catch block
??e.printStackTrace();
?}