Results 1 to 2 of 2
  1. #1
    Harpreet1111 is offline Member
    Join Date
    Jul 2009
    Posts
    12
    Rep Power
    0

    Unhappy problems with Jxl

    Hi all,

    I am creating an application in which i want to read the data from an excel sheet and do some processing on it and than I want to change the colour of those rows that have more than one null values..... I am using jxl package for this... A simple application I have created that tends to read the sheet and change the colour of rows....

    But it is not working....
    Java Code:
    public class Parser
    {
    
    	public static void main(String args[]) throws FileNotFoundException,ClassNotFoundException,IOException,jxl.read.biff.BiffException,WriteException
    	{
    
    	Workbook workbook =Workbook.getWorkbook(newFile("MySheet.xls"));
    	Sheet sheet = workbook.getSheet(0);
    	CellView rowView = sheet.getRowView(rowNumber);
           WritableCellFormat newFormat = new WritableCellFormat(rowView.getFormat());
      	newFormat.setBackground(Colour.RED);
      	rowView.setFormat(newFormat);
    	}
    
    }
    Please help..... Thanks in advance
    Regards
    Harpreet1111

  2. #2
    Harpreet1111 is offline Member
    Join Date
    Jul 2009
    Posts
    12
    Rep Power
    0

    Default

    I am getting the following errors......
    Java Code:
    jxl.common.AssertionFailed
            at jxl.common.Assert.verify(Assert.java:37)
            at jxl.biff.XFRecord.<init>(XFRecord.java:521)
            at jxl.write.biff.CellXFRecord.<init>(CellXFRecord.java:69)
            at jxl.write.WritableCellFormat.<init>(WritableCellFormat.java:96)
            at Parser.main(Parser.java:150)
    Exception in thread "main" jxl.common.AssertionFailed
            at jxl.common.Assert.verify(Assert.java:37)
            at jxl.biff.XFRecord.<init>(XFRecord.java:521)
            at jxl.write.biff.CellXFRecord.<init>(CellXFRecord.java:69)
            at jxl.write.WritableCellFormat.<init>(WritableCellFormat.java:96)
            at Parser.main(Parser.java:150)
    Line numbers are varying as this is part of application.........

    Please help

Similar Threads

  1. Problems here
    By Keno777 in forum New To Java
    Replies: 2
    Last Post: 11-13-2009, 11:35 AM
  2. Few Problems Help!
    By elad_bj in forum New To Java
    Replies: 4
    Last Post: 04-07-2009, 03:45 AM
  3. GUI problems.
    By saytri in forum New To Java
    Replies: 1
    Last Post: 12-16-2007, 10:27 PM
  4. a few problems
    By gary in forum AWT / Swing
    Replies: 0
    Last Post: 07-11-2007, 04:57 PM
  5. problems with JPA
    By Ed in forum New To Java
    Replies: 2
    Last Post: 07-04-2007, 05:34 AM

Posting Permissions

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