write data to excel file in java using apache POI -

-

i having problem here while writing data excel sheet using apache poi. want call function several times write data excel sheet have created.

is there way can move pointer next row every time @ end of function???

my code given below...

public static void excellog(string filename , string message)   {        string dest="d:\\testexcel.xls";     hssfworkbook myworkbook = new hssfworkbook();     hssfsheet mysheet = myworkbook.createsheet();     hssfrow myrow = null;     hssfcell mycell = null;     string exceldata [][] = new string [1][2];     exceldata[0][0]=filename;     exceldata[0][1]=message;      myrow = mysheet.createrow(rownum);      (int cellnum = 0; cellnum < 2 ; cellnum++){     mycell = myrow.createcell((short) cellnum);     mycell.setcellvalue(exceldata[rownum][cellnum]);            }     rownum++;      try{         fileoutputstream out = new fileoutputstream(dest);         myworkbook.write(out);         out.close();     }catch(exception e){         e.printstacktrace();     }             }

please me in this. thank :)

this modified code it's support dynamic column size. idea create row once , reuse if row exists.

import java.io.fileoutputstream;  import org.apache.poi.hssf.usermodel.hssfcell; import org.apache.poi.hssf.usermodel.hssfrow; import org.apache.poi.hssf.usermodel.hssfsheet; import org.apache.poi.hssf.usermodel.hssfworkbook;  public class poisample {  private static string dest = "d:\\testexcel.xls"; private static hssfworkbook myworkbook = new hssfworkbook(); private static hssfsheet mysheet = myworkbook.createsheet();  private static void excellog(int row, int col, string value) {     hssfrow myrow = mysheet.getrow(row);      if (myrow == null)         myrow = mysheet.createrow(row);      hssfcell mycell = myrow.createcell(col);     mycell.setcellvalue(value); }  public static void main(string[] args) {     int numcol = 10; // assume 10 cols      (int = 0; < 10; i++) {         (int j = 0; j < numcol; j++) {             excellog(i, j, "row : " + + ", cell : " + j);         }     }      try {         fileoutputstream out = new fileoutputstream(dest);         myworkbook.write(out);         out.close();     } catch (exception e) {         e.printstacktrace();     } }

}


Comments

Post a Comment

Popular posts from this blog

c# - SVN Error : "svnadmin: E205000: Too many arguments" -

-
i trying reposotries using c# code process svncommand = null; var psi = new processstartinfo("svnadmin"); psi.redirectstandardoutput = true; psi.redirectstandarderror = true; psi.useshellexecute = false; psi.arguments= @"dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump"; using (svncommand = process.start(psi)) { var myoutput = svncommand.standardoutput; var myerror = svncommand.standarderror; debug.write("output :" + environment.newline + environment.newline + myoutput.readtoend() + environment.newline + "error :" + environment.newline + environment.newline + myerror.readtoend()); svncommand.close(); } when use dump command commandline svnadmin dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump it works fine when try ...
Read more

c# - Copy ObservableCollection to another ObservableCollection -

-
how copy observablecollection item observablecollection without reference of first collection? here observablecollection item value changes affecting both collections. code private observablecollection<ratemodel> _allmetalrate = new observablecollection<ratemodel>(); private observablecollection<ratemodel> _metalrateondate = new observablecollection<ratemodel>(); public observablecollection<ratemodel> allmetalrate { { return this._allmetalrate; } set { this._allmetalrate = value; notifypropertychanged("metalrate"); } } public observablecollection<ratemodel> metalrateondate { { return this._metalrateondate; } set { this._metalrateondate = value; notifypropertychanged("metalrateondate"); } } foreach (var item in metalrateondate) allmetalrate.add(item); what causing , how can solve it? you need clone object referenced item before it's a...
Read more

All overlapping substrings matching a java regex -

-
is there api method returns (possibly overlapping) substrings match regular expression? for example, have text string: string t = 04/31 412-555-1235; , , have pattern: pattern p = new pattern("\\d\\d+"); matches strings of 2 or more characters. the matches are: 04, 31, 412, 555, 1235. how overlapping matches? i want code return: 04, 31, 41, 412, 12, 55, 555, 55, 12, 123, 1235, 23, 235, 35. theoretically should possible -- there obvious o(n^2) algorithm enumerates , checks substrings against pattern. edit rather enumerating substrings, safer use region(int start, int end) method in matcher . checking pattern against separate, extracted substring might change result of match (e.g. if there non-capturing group or word boundary check @ start/end of pattern). edit 2 actually, it's unclear whether region() expect zero-width matches. specification vague, , experiments yield disappointing results. for example: string line = "xx90xx"; strin...
Read more