problems with Jxl

[Harpreet1111]

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....

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

[Harpreet1111]

I am getting the following errors......

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