返回顶部

收藏

java操作excel插入图片

更多
import com.smartxls.WorkBook;

import java.io.FileOutputStream;

public class ReadImageSample
{

    public static void main(String args[])
    {
        try
        {
            WorkBook workBook = new WorkBook();

            //open the workbook
            workBook.read("..\\template\\book.xls");

            String filename = "img";
            int type = workBook.getPictureType(0);
            if(type == -1)
                filename += ".gif";
            else if(type == 5)
                filename += ".jpg";
            else if(type == 6)
                filename += ".png";
            else if(type == 7)
                filename += ".bmp";

            byte[] imagedata = workBook.getPictureData(0);

            FileOutputStream fos = new FileOutputStream(filename);
            fos.write(imagedata);
            fos.close();
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
}

import com.smartxls.PictureShape;
import com.smartxls.ShapeFormat;
import com.smartxls.WorkBook;

public class WriteImagesSample
{

    public static void main(String args[])
    {
        try
        {
            WorkBook workBook = new WorkBook();

            //Inserting image
            PictureShape pictureShape = workBook.addPicture(1, 0, 3, 8, "..\\template\\MS.GIF");
            ShapeFormat shapeFormat = pictureShape.getFormat();
            shapeFormat.setPlacementStyle(ShapeFormat.PlacementFreeFloating);
            pictureShape.setFormat();

            workBook.write(".\\pic.xls");
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
}

标签:java

收藏

0人收藏

支持

0

反对

0

发表评论