Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2011
    Posts
    4
    Rep Power
    0

    Default I am getting problem read excel file with 30000 rows using hssf

    I would be great if someone could help me out

  2. #2
    Norm's Avatar
    Norm is offline Moderator
    Join Date
    Jun 2008
    Location
    SW Missouri
    Posts
    17,331
    Rep Power
    25

    Default

    Describe the problem and post any error messages.
    What is hssf?

  3. #3
    Join Date
    Jun 2011
    Posts
    4
    Rep Power
    0

    Default

    HSSF is the POI Project's pure Java implementation of the Excel '97(-2007) file format
    FileInputStream file=new FileInputStream(this.getServlet().getServletContex t().getRealPath("\\Upload")+"\\"+file1);

    HSSFWorkbook workbook = new HSSFWorkbook(file);
    i am getting problem when this i can't read the file and above prepared statement by add batch i tried insert but it is not happening can u please help
    preStatement.setString(1,bean.getBatch_id());
    preStatement.setString(2,bean.getMsisdn());
    preStatement.setString(3,bean.getTse_dt());
    preStatement.setString(4,bean.getFse_status());
    preStatement.setString(5,bean.getFsev_date());
    preStatement.setString(6,bean.getFse_reason());
    preStatement.setString(7,bean.getSv_status());
    preStatement.setString(8,bean.getSvv_date());
    preStatement.setString(9,bean.getLead_reason());
    preStatement.addBatch();
    After this i am going loop i can't find the exception

    preStatement.executeBatch();

  4. #4
    Norm's Avatar
    Norm is offline Moderator
    Join Date
    Jun 2008
    Location
    SW Missouri
    Posts
    17,331
    Rep Power
    25

    Default

    You need to post the full text of the error message so others can see what the problem is.

  5. #5
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,953
    Rep Power
    19

    Default

    Quote Originally Posted by satyendra.kumar View Post
    HSSF is the POI Project's pure Java implementation of the Excel '97(-2007) file format
    FileInputStream file=new FileInputStream(this.getServlet().getServletContex t().getRealPath("\\Upload")+"\\"+file1);

    HSSFWorkbook workbook = new HSSFWorkbook(file);
    i am getting problem when this i can't read the file and above prepared statement by add batch i tried insert but it is not happening can u please help
    There is no prepared statement there. What is the problem with the above code?

    Quote Originally Posted by satyendra.kumar View Post
    preStatement.setString(1,bean.getBatch_id());
    preStatement.setString(2,bean.getMsisdn());
    preStatement.setString(3,bean.getTse_dt());
    preStatement.setString(4,bean.getFse_status());
    preStatement.setString(5,bean.getFsev_date());
    preStatement.setString(6,bean.getFse_reason());
    preStatement.setString(7,bean.getSv_status());
    preStatement.setString(8,bean.getSvv_date());
    preStatement.setString(9,bean.getLead_reason());
    preStatement.addBatch();
    After this i am going loop i can't find the exception

    preStatement.executeBatch();
    What does this have to do with the first part?

    You are going to have to slow down and give us a proper description of your problem, because this is just word salad at the moment.

Similar Threads

  1. Excel file read error
    By Asvin in forum New To Java
    Replies: 10
    Last Post: 04-28-2011, 10:01 PM
  2. How to read Excel file in java
    By nagaraj in forum New To Java
    Replies: 7
    Last Post: 03-18-2011, 05:09 AM
  3. how to read excel file through java program
    By madhuragowda in forum New To Java
    Replies: 2
    Last Post: 04-16-2010, 08:53 AM
  4. How to Read Excel file??
    By spalax in forum New To Java
    Replies: 3
    Last Post: 08-15-2009, 05:06 AM
  5. How to read Excel file with java
    By chetan-24 in forum New To Java
    Replies: 5
    Last Post: 04-22-2009, 05:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •