POI ﾗｲﾌﾞﾗﾘを最新版に入れ替える(正)[ﾌﾟﾛｸﾞﾗﾐﾝｸﾞ]
(2016-12-11 18:25:45) by shinoda

< ﾍﾟｰｼﾞ移動: 1 2 >

<画像：20161211_excel.jpg>

package poiTest;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import org.apache.log4j.net.JMSSink;

import org.apache.poi.hssf.usermodel.HSSFClientAnchor;

import org.apache.poi.hssf.usermodel.HSSFCreationHelper;

import org.apache.poi.hssf.usermodel.HSSFPatriarch;

import org.apache.poi.hssf.usermodel.HSSFPicture;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.util.IOUtils;

public class poiTest {

    private static final String IMAGE_FILE = "C:\\Users\\hogehoge\\img\\kao.jpg";

    private static final String OUTPUT_FILE = "InsertImage.xls";

    public static void main(String[] args) throws Exception {

        HSSFWorkbook wb = new HSSFWorkbook();

        HSSFSheet sheet = wb.createSheet("new sheet");

        FileInputStream inputImage = new FileInputStream(IMAGE_FILE);

        byte[] bytes = IOUtils.toByteArray(inputImage);

        int pictureIndex = wb.addPicture(bytes, 　　HSSFWorkbook.PICTURE_TYPE_JPEG);

        inputImage.close();

        HSSFCreationHelper helper = (HSSFCreationHelper) wb.getCreationHelper();

        HSSFPatriarch patriarch = sheet.createDrawingPatriarch();

        HSSFClientAnchor anchor = helper.createClientAnchor();

        anchor.setCol1((short) 1);

        anchor.setRow1(1);

< ﾍﾟｰｼﾞ移動: 1 2 >