package com.corba.mnq.xls;

import java.io.File;
import common.Logger;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.Number;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class XlsRw {
	private static Logger logger = Logger.getLogger(XlsRw.class);
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		try{
			File input=new File("d:\\TestSpec.xls");
			File output=new File("d:\\output.xls");
			logger.setSuppressWarnings(Boolean.getBoolean("jxl.nowarnings"));
			Workbook book1=Workbook.getWorkbook(input);
			WritableWorkbook book2=Workbook.createWorkbook(output,book1);
			
			WritableSheet sheet=book2.getSheet("TestSpec");
			WritableSheet sheet1=book2.getSheet("TestReport");
			for( int i=1;i<9;i++){
				for( int j=2;j<8;j++){
				    Number n = (Number) sheet1.getWritableCell(j,i);
				    n.setValue(0);
				}
			}

			for( int i=1;i<8; i++){
				Label lb;
				if( i<10 ){
					sheet.removeRow(1);
					
					/*
					lb=new Label(0,i,""+i);
					sheet.addCell(lb);
					lb=new Label(1,i,"xxxxxxx");
					sheet.addCell(lb);
					lb=new Label(2,i,"File");
					sheet.addCell(lb);
					lb=new Label(3,i,"M");
					sheet.addCell(lb);	
					lb=new Label(4,i,"UnTested");
					sheet.addCell(lb);
					*/
				} else if( i<20 ){
					lb=new Label(0,i,""+i);
					sheet.addCell(lb);
					lb=new Label(1,i,"xxxxxxx");
					sheet.addCell(lb);
					lb=new Label(2,i,"Module");
					sheet.addCell(lb);
					lb=new Label(3,i,"M");
					sheet.addCell(lb);	
					lb=new Label(4,i,"UnTested");
					sheet.addCell(lb);
				} else if( i<30 ){
					lb=new Label(0,i,""+i);
					sheet.addCell(lb);
					lb=new Label(1,i,"xxxxxxx");
					sheet.addCell(lb);
					lb=new Label(2,i,"Interface");
					sheet.addCell(lb);
					lb=new Label(3,i,"M");
					sheet.addCell(lb);	
					lb=new Label(4,i,"UnTested");
					sheet.addCell(lb);
				} else if( i<40 ){
					lb=new Label(0,i,""+i);
					sheet.addCell(lb);
					lb=new Label(1,i,"xxxxxxx");
					sheet.addCell(lb);
					lb=new Label(2,i,"Operation");
					sheet.addCell(lb);
					lb=new Label(3,i,"M");
					sheet.addCell(lb);	
					lb=new Label(4,i,"UnTested");
					sheet.addCell(lb);
				} else {
					lb=new Label(0,i,""+i);
					sheet.addCell(lb);
					lb=new Label(1,i,"xxxxxxx");
					sheet.addCell(lb);
					lb=new Label(2,i,"Parameter");
					sheet.addCell(lb);
					lb=new Label(3,i,"M");
					sheet.addCell(lb);	
					lb=new Label(4,i,"UnTested");
					sheet.addCell(lb);
				}

			}
			book2.write();
			book2.close();
		
		}catch(Exception ex){
			ex.printStackTrace();
			return;
		}
	}

}