java - I tried to read string from file and store it in Excel sheet -

-

this have tried

public class uniqueuser  {       static hssfworkbook hwb=new hssfworkbook();       static hssfsheet sheet =  hwb.createsheet("new sheet");       public static void main(string[]args) throws ioexception      {       hssfrow row;       hashset<string> names = new hashset<>();       bufferedreader br = new bufferedreader (new filereader("sample.log"));       printstream out=new printstream("d:/excel.xls");       string str=null;       while((str=br.readline())!=null)       {       if(str.contains("fltr"))      {           string user=str.substring(97, 135);                   names.add(user);                   hssfrow row1 =  sheet.createrow((short)count);       } }  iterator itr=names.iterator();   while(itr.hasnext()) {        out.println(itr.next());    }  }  }

this program storing values excel sheet when read same file using following program, getting exception , errors.. 

public class country1  {      private string name;          private string shortcode;      public country1(string n, string c)          {         this.name=n;                  this.shortcode=c;          }      public void country(string name2, string shortcode2)           {         // todo auto-generated constructor stub          }      public string getname()           {            return name;          }          public void setname(string name)           {                  this.name = name;     }          public string getshortcode()           {              return shortcode;          }          public void setshortcode(string shortcode)           {              this.shortcode = shortcode;          }      @override          public string tostring()          {              return name + "::" + shortcode;          }  }  public class readexcel  {      public static list<country1> readexceldata(string filename)      {         list<country1> countrieslist = new arraylist<country1>();          try                   {                      //create input stream xlsx/xls file                      fileinputstream fis = new fileinputstream(filename);              //create workbook instance xlsx/xls file input stream                      workbook workbook = null;                      if(filename.tolowercase().endswith("xlsx"))                          {                             workbook = new xssfworkbook(fis);                          }                          else if(filename.tolowercase().endswith("xls"))                          {                              workbook = new hssfworkbook(fis);                          }              //get number of sheets in xlsx file                           int numberofsheets = workbook.getnumberofsheets();              //loop through each of sheets                          for(int i=0; < numberofsheets; i++)                          {                  //get nth sheet workbook                      sheet sheet = workbook.getsheetat(i);                  //every sheet has rows, iterate on them                      iterator<row> rowiterator = sheet.iterator();                  while (rowiterator.hasnext())                           {                      string name = "";                      string shortcode = "";                  //get row object                          row row = rowiterator.next();                    //every row has columns, column iterator , iterate on them                 iterator<cell> celliterator = row.celliterator();                          while (celliterator.hasnext())                                   {                                   //get cell object                                   cell cell = celliterator.next();                          //check cell type , process accordingly                                   switch(cell.getcelltype())                                   {                                     case cell.cell_type_string:                                     if(shortcode.equalsignorecase(""))                                     {                                      shortcode = cell.getstringcellvalue().trim();                                     }                                     else if(name.equalsignorecase(""))                                     {                                 //2nd column                             name = cell.getstringcellvalue().trim();                                     }                                    else                                   {                                 //random data, leave                                system.out.println("randomdata::"+cell.getstringcellvalue());  }  break;   case cell.cell_type_numeric:  system.out.println("random data::"+cell.getnumericcellvalue());  }  } //end of cell iterator  country1 c = new country1(name, shortcode);  countrieslist.add(c);  } //end of rows iterator   } //end of sheets loop  //close file input stream fis.close();  }   catch (ioexception e)   {  e.printstacktrace();  }  return countrieslist;  }  public static void main(string args[])  {      list<country1> list = readexceldata("d:\\excel.xls");      system.out.println("country list\n"+list);  }  }

i confused program correct , 1 wrong.. please me.. lot

exception below:

unable read entire header; 320 bytes read; expected 512 bytes     @ org.apache.poi.poifs.storage.headerblock.alertshortread(headerblock.java:227)     @ org.apache.poi.poifs.storage.headerblock.readfirst512(headerblock.java:208)     @ org.apache.poi.poifs.storage.headerblock.<init>(headerblock.java:104)     @ org.apache.poi.poifs.filesystem.poifsfilesystem.<init>(poifsfilesystem.java:128)     @ org.apache.poi.hssf.usermodel.hssfworkbook.<init>(hssfworkbook.java:342)     @ org.apache.poi.hssf.usermodel.hssfworkbook.<init>(hssfworkbook.java:323)     @ com.unisys.readexcel.readexceldata(readexcel.java:32)     @ com.unisys.readexcel.main(readexcel.java:97)

country list

[]

try change

iterator<row> rowiterator = sheet.iterator();

to

iterator<row> rowiterator = sheet.rowiterator()

also, when writing create rows, not write them

hssfrow row1 =  sheet.createrow((short)count);

then create cell

row.createcell (0).setcellvalue (user);

update

just had @ code, why on earth doing

printstream out=new printstream("d:/excel.xls");

use poi api create xls.


Comments

Post a Comment

Popular posts from this blog

C# random value from dictionary and tuple -

-
i have following code, , need random item contains string "region_1" dictionary. public static dictionary<int, tuple<string, int, currencytype>> itemarray = new dictionary<int, tuple<string, int, currencytype>>() { { 0xb3e, new tuple<string, int, currencytype>("region_1", 1500, currencytype.fame) } }; public static int generateitemid(string shopid) { var generateditem = itemarray.elementat(new random().next(0, itemarray.count)).key; } how select this? it's not possible efficiently... first create static random @ class level... prevent non-random behaviour if run query on short period of time... (it's seeded discrete clock) static random rnd = new random(); then: var item = itemarray.values .where(t => t.item1 == shopid) .orderby(_ => rnd.next()) .firstordefault()
Read more

cgi - How do I interpret URLs without extension as files rather than missing directories in nginx? -

-
so i'm trying install zoneminder , have run under nginx, has few compiled files need run using fast-cgi. these files lack extension. if file has extension, there no issue , nginx interprets file , return 404 if can't find it. if has no extension, assume it's directory , return 404 when can't find sort of index page. here have now: # security camera domain. server { listen 888; server_name mydomain.com; root /srv/http/zm; # enable php support. include php.conf; location / { index index.html index.htm index.php; } # enable cgi support. location ~ ^/cgi-bin/(.+)$ { alias /srv/cgi-bin/zm/; fastcgi_pass unix:/run/fcgiwrap.sock; fastcgi_param script_filename $document_root/$1; include fastcgi.conf; } } the idea is, under cgi-bin directory goes through fastcgi pipe. any idea on howi can fix this? upon closer inspection, realized zoneminder has 2 cgi sc...
Read more

.htaccess - htaccess convert request to clean url and add slash at the end of the url -

-
ok , searched more 4 days , more 20 posts here in stach or in websites without kind of success first here htaccess file rewriteengine on rewriterule ^([a-za-z0-9_]+)/?$ index.php?page=$1 [nc] rewriterule ^([a-za-z0-9_]+)\/([a-za-z0-9_]+)\/?$ index.php?page=$1&action=$2 [nc] i tried many codes 1 worked me can call request , works me www.example.com/pagename => www.example.com/index.php?page=pagename here questions , please provide me information "in detail" understand code well 1- how convert request automatically www.example.com/index.php?page=pagename www.example.com/pagename 2- if tried add slash @ end shows me page without images or styling mean www.example.com/pagename => works www.example.com/pagename/ => doesn't work that's :) for first part need 301 rule this: rewritecond %{the_request} /index\.php\?page=([^\s&]+) [nc] rewriterule ^ /%1? [r=301,l] for second part use absolute path in css, js, images files r...
Read more