Can we embed Excel file in ppt through aspose slide java

Question

Can we embed Excel file as a link in ppt through aspose slide java. Currently I have tried with Aspose slide , the object was embedded in the pptx file but while trying to open the file getting exception.please give me some guidelines to functionality.The sample code attached below.

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.nio.file.Files;

import com.aspose.slides.AutoShape;
import com.aspose.slides.IOleObjectFrame;
import com.aspose.slides.ISlide;
import com.aspose.slides.License;
import com.aspose.slides.Presentation;
import com.aspose.slides.SaveFormat;
import com.aspose.slides.ShapeType;

public class PPTTest1 {

public  void setAsposeLicense() {
    InputStream inputStream = null;
    try {
        License license = new License();
        inputStream = getClass().getClassLoader().getResourceAsStream("C:\\work\\licence\\aspose.slides.lic");
        license.setLicense(inputStream);
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        try {
            if (inputStream != null)
                inputStream.close();
        } catch (Exception e) {
            inputStream = null;
        }
    }
}
public static void main(String[] args) throws IOException {
        PPTTest1 ppt=new PPTTest1();
        ppt.setAsposeLicense();
        //Instantiate Prseetation class that represents the PPTX
        Presentation pres = new Presentation();
        //Access the first slide
        ISlide sld = pres.getSlides().get_Item(0);
        //Load an Excel file to Array of Bytes
        File file=new File("C:\\work\\Demo_uploadt.xlsm");
        int length=(int)file.length();
        FileInputStream fstro = new FileInputStream(file);
        byte[] buf = new byte[length];
        fstro.read(buf, 0, length);
        //Add an Ole Object Frame shape\

        byte[] fileContent = Files.readAllBytes(file.toPath());
        IOleObjectFrame ooff = sld.getShapes().insertOleObjectFrame(0,(float)0,(float) 0,100,400, "Excel.Sheet.10", fileContent);
        ooff.setObjectData(fileContent);
        pres.save("C:\\work\\OleEmbed.pptx", SaveFormat.Pptx);
        System.out.println("ppt generated.........");

    }

}

Answer 1

The below code is working fine for me to attach the excel file to a PPT using Aspose slide

import java.io.IOException;
import java.nio.file.Files;
import java.nio.file.Paths;

import com.aspose.slides.IOleEmbeddedDataInfo;
import com.aspose.slides.IOleObjectFrame;
import com.aspose.slides.OleEmbeddedDataInfo;
import com.aspose.slides.Presentation;
import com.aspose.slides.SaveFormat;

public class SetFileTypeForAnEmbeddingObject2 {

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

        Presentation pres = new Presentation();
        try {
            // Add known Ole objects
            byte[] fileBytes = Files.readAllBytes(Paths.get("C:\\work\\Demo uploadt.xlsm"));

            // Create Ole embedded file info
            IOleEmbeddedDataInfo dataInfo = new OleEmbeddedDataInfo(fileBytes, "xls");

            // Create OLE object
            IOleObjectFrame oleFrame = pres.getSlides().get_Item(0).getShapes().addOleObjectFrame(150, 420, 250, 50,
                    dataInfo);
            oleFrame.setObjectIcon(true);

            pres.save("C:\\work\\" + "SetFileTypeForAnEmbeddingObject7.pptx", SaveFormat.Pptx);
        } finally {
            if (pres != null)
                pres.dispose();
        }
    }
}