java jxlÌí¼Óˮӡ(»ùÓÚjxl2.6.12Ð޸ıàÒë°æ)_
ÒòÊý¾Ý°²È«£¬ÐèÒª½«Éú³ÉµÄ±¨±íxls£¬Ìí¼Óˮӡ,ËùÒÔ×ÔÒÑÔÚjxlÖнøÐдúÂëÐ޸ġ£
ʹÓÃÀý×Ó
public class testJxl {
public static void main(String[] args) throws Exception {
OutputStream out = new FileOutputStream("./aaaa.xls"); // дÈëµ½FileInputStream
WritableWorkbook wwb= Workbook.createWorkbook(out);
WritableSheet ws1=wwb.createSheet("test1", 0) ; // µÃµ½¹¤×÷±¡ÖеĵÚÒ»¸ö¹¤×÷±í
File fileImg = new File("./kkkk.bmp");
byte imageData[] = new byte[(int)fileImg.length()];
FileInputStream fis = new FileInputStream(fileImg);
fis.read(imageData);
// must be 24 bit true-colour,bmp file
// * @param imageByte
// * @param widthPixel
// * @param heightPixel
ws1.setWaterMarkImage(imageData,459,142);
wwb.write();
wwb.close();
fis.close();
out.close();
}
}
ÏÂÔØµØÖ·:
http://download.csdn.net/source/2257294
Ïà¹ØÎĵµ£º
ÏÈÀ´Á˽âÒ»ÏÂÁ´±íģʽµÄÔÀí£º
Ê×ÏÈдһ¸öJavaBean£¬ÄÚÈÝÊÇÒªÌí¼ÓµÄÔªËØºÍ¸ÃÔªËØµÄ½Úµã¡£
public class NodeBean implements Serializable
{
private Object data; //ÔªËØ±¾Éí
private NodeBean next; //ÏÂÒ»¸ö½Úµã
&n ......
ËäÈ»¾³£´´½¨¶à¸ö²»ÏàͬµÄÏß³ÌÀ´Íê³É²»Ïà¹ØµÄÈÎÎñ£¬È»¶øÓÐʱִÐеÄÈÎÎñ¿ÉÄÜÓÐÒ»¶¨ÁªÏµ£¬ÕâÑù¾ÍÐèҪʹÕâЩÏ߳̽øÐн»»¥¡£±ÈÈçÓÐÒ»¸öË®ÌÁ£¬ÆäÖжÔË®ÌÁ²Ù×÷Î޷ǰüÀ¨“½øË®”ºÍ“ÅÅË®”£¬ÕâÁ½¸öÐÐΪ¸÷×Ô´ú±íÒ»¸öỊ̈߳¬µ±Ë®ÌÁÖÐûÓÐˮʱ£¬“ÅÅË®”ÐÐΪ²»ÄÜÔÙ½øÐУ ......
Ê×ÏÈ´ò¿ªÃüÁîÐÐÈ·¶¨ÃüÁîÐеĺ¯ÊýÊÇ·ñ¿ÉÒÔÓã¬ÔÚÃüÁîÐÐÀïÃæÊäÈëjar Èç¹û¿ÉÒÔÓþͻá³öÏÖÃüÁîjarµÄ¸÷¸ö²ÎÊýÑ¡Ôñ¹æÔò£¬ºÍÒ»¸öСÎÊÌ⣬ÎÒÓöµ½µÄÎÊÌâÊÇÓÐÒ»¸öµ¥¶ÀµÄclassÎļþ ûÓÐÔ´Îļþ£¬³ÌÐòÒªÔÚnetbeanÀïÃæµ÷ÓÃÕâ¸öclassÎļþ£¬¶øÎÒ²»ÖªµÀnetbeanÈçºÎÒýÓÃÕâ¸öclassÎļþÁË ¾ÍÖ»ºÃ°Ñclass´ò°ü³ÉjarÁË£¬
Ê×ÏÈÎÒÔÚCÅÌÀïÃæ½¨Á¢Á˸öÎ ......
1. ¶Ô×Ô¼ºµÄ×ܽáºÍÀí½âµÄÉý»ªÊÇÎÒϲ»¶×öµÄÒ»¼þÊ£¬ÔÚʵ¼ÊÏîÄ¿¹ý³ÌÖУ¬ºÜ¶àµØ·½¶¼Óõ½¶¯Ì¬Éú³ÉÊ÷Ðβ˵¥µÄµØ·½£¬ÏÖÔھ͸ø´ó¼Ò½²½²ÈçºÎ¶¯Ì¬Éú³ÉÒ»¿ÃÊ÷¡£
2. Ê×ÏÈÎÒÃDZØÐëÒª½¨Á¢Ê÷µÄ½ÚµãÄ£ÐÍ£¬ÆäʵÊ÷µÄ½ÚµãÄ£ÐÍÖÐÍùÍù¾ÍÊÇÎÒÃÇÐèÒª´æ·ÅµÄÊý¾Ý¶ÔÏó£¬ºÜ ......