Excel Java组件Spire.XLS教程：在Java应用程序的Excel中插入OLE对象

*这么优秀的国产工具怎能错过呢！在线下单专享“一口价”，立即购买！想要获取更多福利的朋友可以咨询在线客服哦~

import com.spire.xls.*;import com.spire.xls.core.IOleObject;import com.spire.doc.*;import com.spire.doc.documents.ImageType;import java.awt.image.BufferedImage;public class insertOLEObjects {    public static void main(String[] args) {        String docFile = "Sample.docx";        String outputFile = "output/insertOLEObjects_result.xlsx";        //加载Excel文档        Workbook workbook = new Workbook();        workbook.loadFromFile("Sample.xlsx");        //获取第一张工作表        Worksheet worksheet = workbook.getWorksheets().get(0);        //生成图片        BufferedImage image = GenerateImage(docFile);        //插入OLE对象        IOleObject oleObject = worksheet.getOleObjects().add(docFile, image, OleLinkType.Embed);        oleObject.setLocation(worksheet.getCellRange("B4"));        oleObject.setObjectType(OleObjectType.ExcelWorksheet);        //保持文档        workbook.saveToFile(outputFile, ExcelVersion.Version2010);    }    private static BufferedImage GenerateImage(String fileName) {        //加载Word文档        Document document = new Document();        document.loadFromFile(fileName);        //将Word文档的第一页保存为图片        BufferedImage image = document.saveToImages(0, ImageType.Bitmap);        return image;    }}

效果图：

---

是E-iceblue官方友好合作伙伴，如果您对spire.xls，可以联系在线客服了解具体授权价格和使用机制

标签：