unknown |
black |
white |
default background |
default background |
black |
red |
bright green |
blue |
yellow |
pink |
turquoise |
dark red |
green |
dark blue |
dark yellow |
violet |
teal |
grey 25% |
grey 50% |
periwinkle% |
plum |
ivory |
light turquoise |
dark purple |
coral |
ocean blue |
ice blue |
dark blue |
pink |
yellow |
turqoise |
violet |
dark red |
teal |
blue |
sky blue |
light turquoise |
light green |
very light yellow |
pale blue |
rose |
lavender |
tan |
light blue |
aqua |
lime |
gold |
light orange |
orange |
blue grey |
grey 40% |
dark teal |
sea green |
dark green |
olive green |
brown |
plum |
indigo |
grey 80% |
automatic |
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();
}
}}