Ssio 是一个简单的电子表格I/O。
基本功能
把Javabeas存入Excel/CSV, 或者从Excel/CSV中解析出Javabea
特性
通过Aotatio把JavabeaProperty映射到列支持日期格式支持复杂类型支持扩展以支持Excel/CSV之外的文件类型其它代码示例
BeadefiitiopublicclassPlayer{@SsColum(idex=0,ame="Id")privatelogid;@SsColum(idex=1)//thecolumamewillbedecidedas"BirthCoutry"privateStrigbirthCoutry;@SsColum(idex=2,typeHadler=FullNameTypeHadler.class)//complexproptypeprivateFullNamefullName;@SsColum(idex=3)//Theeum'same()willbesaved.Otherwise,useatypeHadlerprivateSportTypesportType;@SsColum(idex=4,format="yyyy/MM/dd")//dateformatprivateLocalDatebirthDate;@SsColum(idex=5,typeHadler=TimestampAsMillisHadler.class)//ifyouprefersavigtimestampasumberprivateLocalDateTimecreatedWhe;...}SaveSaveParam<Player>saveParam=//Excel-likefile.ForCSV,use"ewCsvSaveParamBuilder()"ewOfficeSaveParamBuilder<Player>().setBeaClass(Player.class).setBeas(players).setOutputTarget(outputStream).build();//GototheSsioMaagerFactory.javatoseeIoCoptiosSsioMaagerssioMaager=SsioMaagerFactory.ewIstace();SaveResultsaveResult=ssioMaager.save(saveParam);//saveResult.getDatumErrors()Parse//Excel-likefile.ForCSV,use"ewCsvParseParamBuilder()"ParseParam<Player>parseParam=ewOfficeParseParamBuilder().setBeaClass(Player.class).setSpreadsheetIput(iputStream).build();ParseResult<Player>parseResult=ssioMaager.parse(parseParam);List<Player>parsedPlayers=parseResult.getBeas();//parseResult.getCellErrors();
评论