java - Uploading Excel file in swing -
i upload excel file , read file according format, problem that file not read. getting exception. adding required jar file (dom4j-1.6.1,poi-3.9-20121203,poi-ooxml-3.9-20121203,poi-ooxml-schemas-3.9-20121203,xmlbeans-2.3.0). please suggest me getting wrong. exception below.
public class csv_upload extends jframe implements actionlistener { public static jframe f; jpanel panel; jbutton b1,b2,b3,b4; jtextfield txt1; jlabel l1; font g,g1; jfilechooser fc; jtextarea log; file file1 ; string str; dbconnection connect=new dbconnection(); static private final string newline = "\n"; public csv_upload() { panel=(jpanel)getcontentpane(); panel.setlayout(null); g=new font("georgia",font.bold,22); g1=new font("georgia",font.bold,15); panel.setbackground(new java.awt.color(204, 230 , 255)); l1=new jlabel("upload excel file"); l1.setbounds(200, 50, 400, 30); l1.setfont(g); l1.setforeground(color.red); panel.add(l1); txt1=new jtextfield(); txt1.setbounds(480, 150,200,40); panel.add(txt1); fc = new jfilechooser(); b1=new jbutton("browse file"); b1.setbounds(50, 150,200,40); b1.setfont(g1); b1.setforeground(color.red); panel.add(b1); b2=new jbutton("upload file"); b2.setbounds(260, 150,200,40); b2.setforeground(color.red); b2.setfont(g1); panel.add(b2); imageicon img=new imageicon("calender.png"); b3=new jbutton(img); b3.setbounds(50, 230,50,30); b3.setforeground(color.red); b3.setfont(g1); panel.add(b3); b1.addactionlistener(this); b2.addactionlistener(this); b3.addactionlistener(this); // b4.addactionlistener(this); } @override public void actionperformed(actionevent e) { if (e.getsource() == b1) { int returnval = fc.showopendialog(csv_upload.this); if (returnval == jfilechooser.approve_option) { file1 = fc.getselectedfile(); str=string.valueof(file1); system.out.println("file fath"+file1); } //handle save button action. } if(e.getsource()==b2) { try { fileinputstream file = new fileinputstream(new file(str)); system.out.println("action performed in file"+file); xssfworkbook workbook = new xssfworkbook(file); xssfsheet sheet = workbook.getsheetat(0); iterator<row> rowiterator = sheet.iterator(); while (rowiterator.hasnext()) { row row = rowiterator.next(); //for each row, iterate through columns iterator<cell> celliterator = row.celliterator(); while (celliterator.hasnext()) { cell cell = celliterator.next(); switch (cell.getcelltype()) { case cell.cell_type_numeric: system.out.print(cell.getnumericcellvalue() + "\t"); break; case cell.cell_type_string: system.out.print(cell.getstringcellvalue() + "\t"); break; } } system.out.println(""); } file.close(); } catch (exception e1) { e1.printstacktrace(); } } if(e.getsource().equals(b3)) { txt1.settext(new datepicker(f).setpickeddate()); } } public static void main(string []s) { f=new csv_upload(); f.setvisible(true); f.setsize(750,500); f.setdefaultcloseoperation(jframe.exit_on_close); } } stack trace:
exception in thread "awt-eventqueue-0" java.lang.nosuchmethoderror: org.apache.poi.xssf.usermodel.xssfworkbook.<init>(ljava/io/inputstream;)v @ add.csv_upload.actionperformed(csv_upload.java:129) @ javax.swing.abstractbutton.fireactionperformed(unknown source) @ javax.swing.abstractbutton$handler.actionperformed(unknown source) @ javax.swing.defaultbuttonmodel.fireactionperformed(unknown source) @ javax.swing.defaultbuttonmodel.setpressed(unknown source) @ javax.swing.plaf.basic.basicbuttonlistener.mousereleased(unknown source) @ java.awt.component.processmouseevent(unknown source) @ javax.swing.jcomponent.processmouseevent(unknown source) @ java.awt.component.processevent(unknown source) @ java.awt.container.processevent(unknown source) @ java.awt.component.dispatcheventimpl(unknown source) @ java.awt.container.dispatcheventimpl(unknown source) @ java.awt.component.dispatchevent(unknown source) @ java.awt.lightweightdispatcher.retargetmouseevent(unknown source) @ java.awt.lightweightdispatcher.processmouseevent(unknown source) @ java.awt.lightweightdispatcher.dispatchevent(unknown source) @ java.awt.container.dispatcheventimpl(unknown source) @ java.awt.window.dispatcheventimpl(unknown source) @ java.awt.component.dispatchevent(unknown source) @ java.awt.eventqueue.dispatcheventimpl(unknown source) @ java.awt.eventqueue.access$200(unknown source) @ java.awt.eventqueue$3.run(unknown source) @ java.awt.eventqueue$3.run(unknown source) @ java.security.accesscontroller.doprivileged(native method) @ java.security.protectiondomain$1.dointersectionprivilege(unknown source) @ java.security.protectiondomain$1.dointersectionprivilege(unknown source) @ java.awt.eventqueue$4.run(unknown source) @ java.awt.eventqueue$4.run(unknown source) @ java.security.accesscontroller.doprivileged(native method) @ java.security.protectiondomain$1.dointersectionprivilege(unknown source) @ java.awt.eventqueue.dispatchevent(unknown source) @ java.awt.eventdispatchthread.pumponeeventforfilters(unknown source) @ java.awt.eventdispatchthread.pumpeventsforfilter(unknown source) @ java.awt.eventdispatchthread.pumpeventsforhierarchy(unknown source) @ java.awt.eventdispatchthread.pumpevents(unknown source) @ java.awt.eventdispatchthread.pumpevents(unknown source) @ java.awt.eventdispatchthread.run(unknown source)
the class org.apache.poi.xssf.usermodel.xssfworkbook has constructor init method accepts java.io.inputstream, , xssfworkbook located in poi-ooxml-schemas-3.9-20121203.jar. check readme file in project's dist directory. check project jar's manifest, should this:
class-path: lib/poi-3.9-20121203.jar lib/poi-ooxml-3.9-20121203.jar …
Comments
Post a Comment