ExcelWorkbookImporter

Inheritance: java.lang.Object

public class ExcelWorkbookImporter

Provides functionality for importing content from an Excel workbook into a presentation.

Methods

addChartFromWorkbook(IShapeCollection shapes, float x, float y, IExcelDataWorkbook workbook, String worksheetName, int chartIndex, boolean embedAllWorkbook)

public static IChart addChartFromWorkbook(IShapeCollection shapes, float x, float y, IExcelDataWorkbook workbook, String worksheetName, int chartIndex, boolean embedAllWorkbook)

Retrieves a chart from the specified Excel workbook and adds it to the end of the given shape collection at the specified coordinates.

Example:
 
 IExcelDataWorkbook wb = new ExcelDataWorkbook(testFile);
 Presentation pres = new Presentation();
 try {
     ExcelWorkbookImporter.addChartFromWorkbook(pres.getSlides().get_Item(0).getShapes(), 10, 10, wb, worksheetName, chartName, false);
     pres.save("result.pptx", SaveFormat.Pptx);
 } finally {
     if (pres != null) pres.dispose();
 }

Parameters:

Returns: IChart - The chart that was added to the shape collection.

addChartFromWorkbook(IShapeCollection shapes, float x, float y, IExcelDataWorkbook workbook, String worksheetName, String chartName, boolean embedAllWorkbook)

public static IChart addChartFromWorkbook(IShapeCollection shapes, float x, float y, IExcelDataWorkbook workbook, String worksheetName, String chartName, boolean embedAllWorkbook)

Retrieves a chart from the specified Excel workbook and adds it to the end of the given shape collection at the specified coordinates.

Example:
 
 IExcelDataWorkbook wb = new ExcelDataWorkbook(testFile);
 Presentation pres = new Presentation();
 try {
     String worksheetName = "worksheet name";
     Dictionary.Enumerator<Integer, String> worksheetCharts = wb.getChartsFromWorksheet(worksheetName).iterator();
     while (worksheetCharts.hasNext())
     {
         KeyValuePair<Integer, String> chart = worksheetCharts.next();
         ISlide slide = pres.getSlides().addEmptySlide(pres.getLayoutSlides().get_Item(0));
         ExcelWorkbookImporter.addChartFromWorkbook(slide.getShapes(), 10, 10, wb, worksheetName, chart.getKey(), false);
     }
     pres.save("result.pptx", SaveFormat.Pptx);
 } finally {
     if (pres != null) pres.dispose();
 }

Parameters:

Returns: IChart - The chart that was added to the shape collection.

addChartFromWorkbook(IShapeCollection shapes, float x, float y, InputStream workbookStream, String worksheetName, String chartName, boolean embedAllWorkbook)

public static IChart addChartFromWorkbook(IShapeCollection shapes, float x, float y, InputStream workbookStream, String worksheetName, String chartName, boolean embedAllWorkbook)

Retrieves a chart from the specified Excel workbook and adds it to the end of the given shape collection at the specified coordinates.

Example:
 
 Presentation pres = new Presentation();
 try {
     FileInputStream fStream = new FileInputStream(workbookPath);
     ExcelWorkbookImporter.addChartFromWorkbook(pres.getLayoutSlides().get_Item(0).getShapes(), 10, 10, fStream, worksheetName, chartName, true);
     fStream.close();
     pres.save("result.pptx", SaveFormat.Pptx);
 } finally {
     if (pres != null) pres.dispose();
 }

Parameters:

Returns: IChart - The chart that was added to the shape collection.

addChartFromWorkbook(IShapeCollection shapes, float x, float y, String workbookPath, String worksheetName, String chartName, boolean embedWorkbook)

public static IChart addChartFromWorkbook(IShapeCollection shapes, float x, float y, String workbookPath, String worksheetName, String chartName, boolean embedWorkbook)

Retrieves a chart from the specified Excel workbook and adds it to the end of the given shape collection at the specified coordinates.

Example:
 
 Presentation pres = new Presentation();
 try {
     ExcelWorkbookImporter.addChartFromWorkbook(pres.getSlides().get_Item(0).getShapes(), 10, 10, workbookPath, worksheetName, chartName, false);
     pres.save("result.pptx", SaveFormat.Pptx);
 } finally {
     if (pres != null) pres.dispose();
 }

Parameters:

Returns: IChart - The chart that was added to the shape collection.