java - File not saved on different computer using outputstream and filechooser -
i trying edit inside .xls file using apache poi library. updation succesfull on local computer.but, stuck when jar file of application not saved excel file on computer on installed.
filechooser filechooser = new filechooser(); filechooser.settitle("generated data of dvat "); filechooser.settitle("generate xls file of " + "dvat 31"); filechooser.getextensionfilters().addall( new extensionfilter("xls files", "*.xls")); filechooser.setinitialfilename(common .replacewhitespaceandslash("dvat31") + "_" + common.replacewhitespaceandslash(common.comp.getname()+"_") +this.fromdate+"_"+this.todate+ ".xls"); filechooser.setinitialdirectory(new file(system .getproperty("user.home") + "/desktop")); file selectedfilename = filechooser.showsavedialog(null); if(selectedfilename!=null) { string filename=absolutepath; hssfworkbook wb = hssfreadwrite.readfile(filename); fileoutputstream stream = new fileoutputstream(selectedfilename.getabsolutepath()); // updation on .xls sheet. row = sheet.getrow(34); for(int i=1;i<=12;i++) { if(i==4) { cell=row.getcell(i); cell.setcellvalue(this.consignmenttotal); } } // closing workbook , outputstream. wb.write(stream); stream.close(); wb.close();
Comments
Post a Comment