Public classtestcasemanager{ Public Static FinalString title_caseid= "Test example ID"; Public Static FinalString title_casename= "Test Name"; Public Static FinalString title_testresult= "test Result"; Public Static FinalString title_testtime = "Test pass Time"; Public Static FinalString [] titles=NewString[]{title_caseid,title_casename,title_testresult,title_testtime}; Public Static voidGenerexcel (list<testcase>list, String path) {File File=NewFile (path); if(!file.exists ()) {Createexcel (List,path); }Else{List<TestCase>list2 readexcel (path); intlistnumber list2.size (); for(inti=0;i<listnumber;i++) {TestCase TestCase=List2.get (i); List.add (testcase); } createexcel (List,path); } } Public Static voidCreateexcel (list<testcase>list, String path) {Hssfworkbook Workbook=NewHssfworkbook (); Format Format=NewSimpleDateFormat ("Yyyy-mm-dd"); String SheetName= Format.format (NewDate ()); Hssfsheet sheet=Workbook.createsheet (SheetName); Hssfrow Row=Sheet.create} Public StaticList<testcase>readexcel (String path) {}}
Import data into local Excel and read local Excel into List