java - How to copy a row from existing excel sheet to a new excel sheet using Apache POI? -


i want compare 2 excel sheets , find if row differs, if want copy single row differs excel new row in new excel. below code snippet took net , tried problem if copy 10th row of existing excel(for example) first row of new excel, 1st row copied in new excel remaining rows first excel copied new one. think problem way write new excel [workbook.write(out)] please help!! in advance!!

    public class rowcopy {  public static void main(string[] args) throws exception{     hssfworkbook workbook = new hssfworkbook(new fileinputstream("c:/input.xls"));     hssfsheet sheet = workbook.getsheet("sheet1");     copyrow(workbook, sheet, 0, 1);     fileoutputstream out = new fileoutputstream("c:/output.xls");     workbook.write(out);     out.close(); }  private static void copyrow(hssfworkbook workbook, hssfsheet worksheet, int sourcerownum, int destinationrownum) {     // source / new row     hssfrow newrow = worksheet.getrow(destinationrownum);     hssfrow sourcerow = worksheet.getrow(sourcerownum);      // if row exist in destination, push down rows 1 else create new row     if (newrow != null) {         worksheet.shiftrows(destinationrownum, worksheet.getlastrownum(), 1);     } else {         newrow = worksheet.createrow(destinationrownum);     }      // loop through source columns add new row     (int = 0; < sourcerow.getlastcellnum(); i++) {         // grab copy of old/new cell         hssfcell oldcell = sourcerow.getcell(i);         hssfcell newcell = newrow.createcell(i);          // if old cell null jump next cell         if (oldcell == null) {             newcell = null;             continue;         }          // copy style old cell , apply new cell         hssfcellstyle newcellstyle = workbook.createcellstyle();         newcellstyle.clonestylefrom(oldcell.getcellstyle());         ;         newcell.setcellstyle(newcellstyle);          // if there cell comment, copy         if (oldcell.getcellcomment() != null) {             newcell.setcellcomment(oldcell.getcellcomment());         }          // if there cell hyperlink, copy         if (oldcell.gethyperlink() != null) {             newcell.sethyperlink(oldcell.gethyperlink());         }          // set cell data type         newcell.setcelltype(oldcell.getcelltype());          // set cell data value         switch (oldcell.getcelltype()) {             case cell.cell_type_blank:                 newcell.setcellvalue(oldcell.getstringcellvalue());                 break;             case cell.cell_type_boolean:                 newcell.setcellvalue(oldcell.getbooleancellvalue());                 break;             case cell.cell_type_error:                 newcell.setcellerrorvalue(oldcell.geterrorcellvalue());                 break;             case cell.cell_type_formula:                 newcell.setcellformula(oldcell.getcellformula());                 break;             case cell.cell_type_numeric:                 newcell.setcellvalue(oldcell.getnumericcellvalue());                 break;             case cell.cell_type_string:                 newcell.setcellvalue(oldcell.getrichstringcellvalue());                 break;         }     }

}

just modify copyrow method, add parameter hssfsheet resultsheet modify newrow variable in method resultsheet 

private static void copyrow(hssfworkbook workbook, hssfsheet worksheet, hssfsheet resultsheet, int sourcerownum, int destinationrownum) {     // source / new row     hssfrow newrow = resultsheet.getrow(destinationrownum);     hssfrow sourcerow = worksheet.getrow(sourcerownum);

take resultsheet destination "output.xls"


Comments

Post a Comment

Popular posts from this blog

user interface - How to replace the Python logo in a Tkinter-based Python GUI app? -

is there way change default logo, python logo , appears in window's task bar? notice have replaced default tk logo used appear in application window. i using windows 7 , python 2.6 , developing gui of tkinter. you can using winico tk extension package. winico package can used add system tray icons tk programs. the following sample shows 1 way change runtime application icon. note need provide .ico file suitable sizes of icons in on command line , need use pythonw. not change taskbar icon console when running python script. test extracted winico0.6 package python\tcl\winico0.6 folder package require winico work , ran code below using pythonw winico_test.py path\to\some\ico\file.ico . import sys tkinter import * def main(argv): root = tk() root.update() root.tk.call('package','require','winico') id = root.tk.call('winico','createfrom',argv[1]) root.tk.call('winico','setwindow',root,id...
Read more

objective c - Greedy NSProgressIndicator Allocation -

i'm using bunch of nsprogressindicators @ once (32 exact) , looks when they're animating start allocating memory no one's business greedy_run http://i62.tinypic.com/15rgmso.png i've got reports app slowdown , crash after days of uptime, , looks culprit, it's hard pinpoint bugs take days appear. i comment out call start animating, memory behaves expected. result of multiple nsprogressindicators alloc'ed on same thread? or maybe sandboxing? of constant allocations coming core animation threads, don't know else going on. custom nsview progress indicator lives in @interface myview () @property (nonatomic, strong) nsimageview *imageview; @property (nonatomic, strong) nstextview *numbertxt; @property (nonatomic, strong) nsprogressindicator *progress; @end @implementation myview - (id)initwithframe:(nsrect)framerect { self = [super initwithframe:framerect]; if (self) { // image nsimage *image = [nsimage imagenamed:@"bg.png"]; c...
Read more

how to set an OCR language in Google Drive -

i need upload image google drive including ocr feature. the problem setocrlanguage method. need specify hebrew language , based on iso 639-1 codes should "heb". i'm getting response "code" : 400, "errors" : [ { "domain" : "global", "location" : "ocrlanguage", "locationtype" : "parameter", "message" : "invalid value", "reason" : "invalid" } ], any idea should code or can list of avaliable codes?
Read more