图片用Excel画出来(JAVA)

能够将任何图片在excel上利用单元格背景完整的描绘出来。
像网络上出现的用excel画出超级玛丽等等，各种图片都能在excel上"画"出来。

图片我没有经过特殊处理，所以转换的图片不能太大，有多大的图片就要有多少的单元格。如640*480就有307200的单元格。

如要转换的图片：

转换后在excel中的效果：

没多大意义练练手:

import java.awt.Color;import java.awt.image.BufferedImage;import java.io.File;import java.io.IOException;import java.util.Locale;import javax.swing.ImageIcon;import jxl.Workbook;import jxl.WorkbookSettings;import jxl.format.Colour;import jxl.read.biff.BiffException;import jxl.write.Label;import jxl.write.WritableCellFormat;import jxl.write.WritableSheet;import jxl.write.WritableWorkbook;public class Helper {private  BufferedImage getBufferedImage(String filepath){ImageIcon imgicon=new ImageIcon(filepath); BufferedImage bufferedImage = new BufferedImage(imgicon.getIconWidth(),imgicon.getIconHeight(),BufferedImage.TYPE_INT_RGB);      bufferedImage.createGraphics().drawImage(imgicon.getImage(), 0, 0,null); return bufferedImage; }private  Colour getNearestColour(Color awtColor) {       Colour color = null;       Colour[] colors = Colour.getAllColours();       if ((colors != null) && (colors.length > 0)) {        Colour crtColor = null;        int[] rgb = null;        int diff = 0;        int minDiff = 999;             for (int i = 0; i < colors.length; i++) {         crtColor = colors[i];         rgb = new int[3];         rgb[0] = crtColor.getDefaultRGB().getRed();         rgb[1] = crtColor.getDefaultRGB().getGreen();         rgb[2] = crtColor.getDefaultRGB().getBlue();              diff = Math.abs(rgb[0] - awtColor.getRed())           + Math.abs(rgb[1] - awtColor.getGreen())           + Math.abs(rgb[2] - awtColor.getBlue());              if (diff < minDiff) {          minDiff = diff;          color = crtColor;         }        }       }       if (color == null)        color = Colour.BLACK;       return color;      }  public void exec(String convertFromImage,String createxls) throws Exception{WorkbookSettings ws = new WorkbookSettings();    ws.setLocale(new Locale("en", "EN"));    WritableWorkbook workbook = Workbook.createWorkbook(new File(createxls), ws);    WritableSheet s2 = workbook.createSheet("picture", 0);    BufferedImage buffimage=   getBufferedImage(convertFromImage);    int width=buffimage.getWidth();    int heigh=buffimage.getHeight();    for(int i=0;i<width;i++)    {        for(int h=0;h<heigh;h++)    {            WritableCellFormat greyBackground = new WritableCellFormat();            Color c = new Color(buffimage.getRGB(i, h));                     greyBackground.setBackground( getNearestColour(c) );      Label  lr = new Label(i, h, "", greyBackground);    s2.addCell(lr);    }        }               //写入Excel对象     workbook.write();     workbook.close();}/** * @param args * @throws IOException  * @throws BiffException  */public static void main(String[] args) throws Exception {Helper helper=new Helper();System.out.println("输入的图片："+args[0]);System.out.println("输出的excel："+args[1]);System.out.println("转换开始");//转换执行的方法参数 args[0]输入的图片路径 args[1]输出的excel路径//helper.exec( "mslogo.jpg","1.xls");helper.exec(args[0],args[1]);}}