The previous time is doing, imported and exported, you should see it / ** Export data is XLS format * @Param fos * @Param bo * / public void WriteExcelbo (FileoutPutStream Fos, Java.util.Vector VE) {JXL. Write.writableworkbook wwb; try {wwb = workbook.createworkbook (fos); jxl.write.writablesheet WS = wwb.createsheet ("Booksheet", 10); ws.addcell (new jxl.write.label (0, 1, " Bibliographic ID ")); ws.addcell (new jxl.write.label (1, 1," ISBN ")); ws.addcell (new jxl.write.label (2, 1," pricing "); WS. AddCell (3, 1, "book name"); ws.addcell (new jxl.write.label (4, 1, "original book name"); ws.addcell (new jxl. Write.label (5, 1, "Subscription Name"); ws.addcell (new jxl.write.label (6, 1, "author")); ws.addcell (New JXL.WRITE.LABEL (7, 1 , "Translator"); ws.addcell (new jxl.write.label (8, 1, "version")); ws.addcell (new jxl.write.label (9, 1, "publishing") ); Ws.addcell (New JXL.WRITE.LABEL (10, 1, "Press")); ws.addcell (New JXL.WRITE.LABEL (11, 1, "Publish Date"); ws.addcell New jxl.write.label (12, 1, "pages")); ws.addcell (new jxl.write.label (13, 1, "book high")); ws.addcell (new jxl.write.label (14, 1, "Frame")); WS.Addcell (New JXL.WRITE.LABEL (15, 1, "Series")); ws.addcell (new jxl.write.label (16, 1, "general notes"); ws.addcell NEW JXL.WRITE.LABEL (17, 1, "Introduction")); ws.addcell (new jxl.write.label (18, 1, "keyword")); ws.addcell (new jxl.write.label 19, 1, "Medium Graphics")); ws.addcell (New JXL.WRITE.Label (20, 1, "Update Date")); ws.addcell (new jxl.write.label (21, 1, "Number")); book = new book [ve.size ()]; for (int i = 0; i Book [i] .getbookid ())); ws.addcell (new jxl.write.label (1, i 2, book [i] .Getisbn ())); ws.addcell (new jxl.write.label 2, i 2, "" Book [i] .GetPrice ())); ws.addcell (new jxl.write.label (3, i 2, book [i] .getbookTitle ()); WS. AddCell (4, i 2, Book [i] .GetoldFileName ()); ws.addcell (new jxl.write.label (5, i 2, book [i] .Getsubtitle )))); Ws.addcell (new jxl.write.label (6, i 2, book [i] .Getwriter ()); ws.addcell (new jxl.write.label (7, i 2, book [i] .Gettranscribe ())); ws.addcell (new jxl.write.label (8, i 2, " book [i] .getversion ()); ws.addcell (new jxl.write. Label (9, i 2, book [i] .GetpublishCity ())); ws.addcell (new jxl.write.label (10, i 2, book [i] .Getpublisher ()); ws.addcell (New jxl.write.label (11, i 2, book [i] .GetpublishDate (). Tostring ())); ws.addcell (new jxl.write.label (12, i 2, " BOOK [i] .GETPAGE ())); ws.addcell (new jxl.write.label (13, i 2, "" book [i] .gethight ())); ws.addcell (new jxl.write. Label (14, i 2, BOOK [i] .GetInstall ())); ws.addcell (new jxl.write.label (15, i 2, book [i] .getseries ())); ws.addcell (new jxl.write.label (16 , i 2, book [i] .Getnotes ()); ws.addcell (new jxl.write.label (17, i 2, book [i] .Getprecisnotes ()); ws.addcell (new jxl .write.label (18, i 2, book [i] .Getsubject ())); ws.addcell (new jxl.write.label (19, i 2, book [i] .getcls (). Replaceall ( "_", ""))); Ws.addcell (new jxl.write.label (20, i 2, book [i] .getupdatedate (). Tostring ())); ws.addcell (new jxl.write .Label (21, i 2, "0");} jxl.write.writablefont wfc = new jxl.write.WritableFont (WritableFont.ARIAL, 255, WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK); jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat (wfc); ws .addcell (new jxl.write.label (0, 0, "to ensure that you submit the stability and correctness of the order, do not change this table format (please do not change the book ID, order the number of yourself!)")) Wwb.write (); // Close Excel working thin object Wwb.close ();} catch (ooExce) {} catch (rowsexceededExcection e) {} catch (writeexception e) {}} // Import Excel if (f .getname (). Indexof (". xls")> 0) {Try {FIS = New fileInputStream (f); bookbean bob = new bookbean (); userbean usb = new userbean (); jxl.workbook rwb = workbook.getWorkbook (FIS); jxl.sheet sh = rwb.getsheet (0); int Rowcount = sh.Getrows (); SimpleDateFormat SDF = New SimpleDateFormat ("DD / MM / YYYYYYYYYY); book = new book [RowCount - 1]; For (int i = 1; i
