1、下载Spire.Office 3.9.1, 并将其中的Spire.XLS.dll文件和Spire.Presentation.dll文件引用到项目中。
2、将代码放入Visual Studio中：【C#】using System;us坡纠课柩ing System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using Spire.Xls;using System.Drawing;using Spire.Presentation;using Spire.Presentation.Drawing;using System.IO;namespace Insert_OLE_to_PPT{ class Program { static void Main(string[] args) { //加载Excel文档 Workbook book = new Workbook(); book.LoadFromFile("Sample.xlsx"); //选择单元格范围并将其保存为图像 Image image = book.Worksheets[0].ToImage(1, 1, 5, 5); //新建一个PowerPoint文档 Presentation ppt = new Presentation(); //插入图像到PowerPoint文档 IImageData oleImage = ppt.Images.Append(image); Rectangle rec = new Rectangle(60, 60, image.Width, image.Height); using (MemoryStream ms = new MemoryStream()) { //将Excel数据保存到流 book.SaveToStream(ms); ms.Position = 0; //根据Excel数据将OLE对象插入到PowerPoint文档 Spire.Presentation.IOleObject oleObject = ppt.Slides[0].Shapes.AppendOleObject("excel", ms.ToArray(), rec); oleObject.SubstituteImagePictureFillFormat.Picture.EmbedImage = oleImage; oleObject.ProgId = "Excel.Sheet.12"; } //保存文档 ppt.SaveToFile("插入OLE.pptx", Spire.Presentation.FileFormat.Pptx2013); } }}
3、调试并运行代码后，生成的文档如下图所示：
