package excel;

import java.io.FileOutputStream;
import java.io.OutputStream;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import jxl.*;
import jxl.format.Alignment;
import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.format.CellFormat;
import jxl.format.Colour;
import jxl.write.Boolean;
import jxl.write.Label;
import jxl.write.Number;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class WriteExcel {

/**
*
* @author smart *
*/
public static void main(String[] args) {

   try {

    String filePath = "D:/workspace/upload/file/test.xls";

    WritableWorkbook wwb;

    OutputStream os = new FileOutputStream(filePath);
    wwb = Workbook.createWorkbook(os);

    WritableSheet sheet = wwb.createSheet("product list", 0);
    int off_col = 0;
    int off_row = 0;

    Colour[] colors = Colour.getAllColours();
    for (int i = 0; i < colors.length; i ) {

     WritableCellFormat wcf = new WritableCellFormat();
     wcf.setBackground(colors[i]);

     jxl.write.Label label = new jxl.write.Label(off_col, i, colors[i].getDescription());
     label.setCellFormat(wcf);
     sheet.addCell(label);
    }

    wwb.write();
    wwb.close();
   } catch (Exception e) {
    System.out.println("---exception---");
    e.printStackTrace();
   }
}}