Exporting a chart from a spreadsheet in JPEG format...

[srawillliams]

I am using OpenOffice server-side to create a spreadsheet and associated chart. I need to render the chart as a jpeg or gif but cannot figure out how to do this.

I thought that as each sheet exposes an associated XDrawPage, I would be able to use this with a GraphicExportFilter. This, however, does not appear to work.

Any ideas

[/list]

[David]

[DannyB]

The following program....
1. Creates a new spreadsheet
2. Puts some glowing sales figures into it (see the chart!)
3. Creates a chart of those sales figures
4. Creates a new drawing document.
5. Select/Copy/Paste the chart into the Drawing
6. Export the drawing to a JPEG.

This is a standalone example, ready to run. Be sure the change the first line.

[srawilllliams]

Thanks DannyB, Just got a java version of your code working ... will post up once i've got it cleaned up a bit

[srawilliams]

public void exportChart(
XSpreadsheetDocument document,
String chartSheetName,
String fileFormat,
String fileUrl,
XMultiServiceFactory multiServiceFactory
) throws Exception {




//need a draw document
XComponent drawDocument = null;

try {

//get document model
XModel model = (XModel) UnoRuntime.queryInterface(XModel.class, document);

//get collection of sheets belonging to document
XSpreadsheets sheets = document.getSheets();

//get name access reference
XNameContainer sheetsWithNameAccess = (XNameContainer) UnoRuntime.
queryInterface(XNameContainer.class, sheets);

//get the chart sheet
XSpreadsheet chartSheet = (XSpreadsheet) UnoRuntime.queryInterface(
XSpreadsheet.class, sheets.getByName(chartSheetName));

if (chartSheet != null) {

//get draw page supplier for chart sheet
XDrawPageSupplier calcDrawPageSupplier =
(XDrawPageSupplier)
UnoRuntime.queryInterface(XDrawPageSupplier.class, chartSheet);

//get draw page
XDrawPage calcDrawPage = calcDrawPageSupplier.getDrawPage();
int numberOfShapes = calcDrawPage.getCount();

if (calcDrawPage != null && numberOfShapes > 0) {

com.sun.star.drawing.XShape shape = null;
XPropertySet shapeProperties = null;
String classId = null;

//need the doucment controller
XController calcController
= model.getCurrentController();

XSelectionSupplier calcSelectionSupplier = (XSelectionSupplier)
UnoRuntime.queryInterface(XSelectionSupplier.class,
calcController);

boolean found = false;
findShape:for (int i = 0; i < numberOfShapes; i++) {

shape = (XShape) UnoRuntime.queryInterface
(XShape.class, calcDrawPage.getByIndex(i));

shapeProperties = (XPropertySet) UnoRuntime.
queryInterface(XPropertySet.class, shape);

classId = (String) shapeProperties.getPropertyValue("CLSID");

if (classId != null &&
classId.toLowerCase().equals(CHART_CLASS_ID.toLowerCase())) {

calcSelectionSupplier.select(shape);
found = true;
break findShape;
}

}


if(found) {
//get a dispatch helper object/service
Object dispatchHelperObject =
multiServiceFactory.createInstance
("com.sun.star.frame.DispatchHelper");

com.sun.star.frame.XDispatchHelper dispatchHelper =
(com.sun.star.frame.XDispatchHelper) UnoRuntime.queryInterface(
com.sun.star.frame.XDispatchHelper.class, dispatchHelperObject);

//get the XFrame for the calc doc
com.sun.star.frame.XFrame calcDocFrame = calcController.getFrame();

XDispatchProvider calcDispatchProvider = (XDispatchProvider)
UnoRuntime.queryInterface(XDispatchProvider.class, calcDocFrame);

PropertyValue[] dispatchPropertyValues = new PropertyValue[0];

dispatchHelper.executeDispatch(calcDispatchProvider,
".uno:Copy", "", 0,
dispatchPropertyValues);

//create a draw document
XComponentLoader loader = (XComponentLoader)
UnoRuntime.queryInterface(
XComponentLoader.class,
multiServiceFactory.createInstance("com.sun.star.frame.Desktop"));

//hide the document by setting the Hidden property
PropertyValue[] drawDocProperties = new PropertyValue[1];
PropertyValue aValue = new PropertyValue();
aValue.Name = "Hidden";
aValue.Value= new Boolean(true);
drawDocProperties[0] = aValue;

drawDocument = (XComponent)
UnoRuntime.queryInterface(XComponent.class,
loader.loadComponentFromURL(
"private:Factory/sdraw",
"_blank", 0, drawDocProperties
));

XDrawPagesSupplier drawDrawPagesSupplier =
(XDrawPagesSupplier) UnoRuntime.queryInterface(
XDrawPagesSupplier.class, drawDocument);

//get the first drawpage
XDrawPages drawDrawPages = drawDrawPagesSupplier.getDrawPages();
Object drawPageObject = drawDrawPages.getByIndex(0);
XDrawPage drawDrawPage = (XDrawPage) UnoRuntime.queryInterface
(XDrawPage.class, drawPageObject);


//get the draw document model
XModel drawDocModel =
(XModel) UnoRuntime.queryInterface(XModel.class, drawDocument);

//get draw documet controller
XController drawDocController = drawDocModel.getCurrentController();

//get the frame for the draw doc
XFrame drawDocFrame = drawDocController.getFrame();

//paste into draw document
XDispatchProvider drawDispatchProvider = (XDispatchProvider)
UnoRuntime.queryInterface(XDispatchProvider.class, drawDocFrame);

dispatchHelper.executeDispatch(drawDispatchProvider,
".uno:Paste", "", 0,
new PropertyValue[0]);

//get an export filter object
Object GraphicExportFilter = multiServiceFactory.createInstance
("com.sun.star.drawing.GraphicExportFilter");
XExporter exporter = (XExporter)
UnoRuntime.queryInterface(XExporter.class, GraphicExportFilter);

PropertyValue[] exportProperties = new PropertyValue[2];
for (int i = 0; i < exportProperties.length; i++) {
exportProperties[i] = new PropertyValue();
}

//use an export filter
exportProperties[0] = new PropertyValue();
exportProperties[0].Name = "MediaType";
//exportProperties[0].Value = "image/gif";
exportProperties[0].Value = fileFormat;

exportProperties[1].Name = "URL";
exportProperties[1].Value = fileUrl;

//export the chart
XDrawPagesSupplier drawPagesSupplier =
(XDrawPagesSupplier) UnoRuntime.queryInterface(
XDrawPagesSupplier.class, drawDocument);

//get collection of draw pages
XDrawPages drawPages = drawPagesSupplier.getDrawPages();

//get first draw page
XDrawPage drawPage = (XDrawPage) UnoRuntime.queryInterface(
XDrawPage.class,
drawPages.getByIndex(0));

Object shapeAsObject = drawPage.getByIndex(0);
XShape chartShape = (XShape) UnoRuntime.queryInterface(
XShape.class, shapeAsObject);


XComponent pageToExport = (XComponent)
UnoRuntime.queryInterface(XComponent.class, chartShape);

exporter.setSourceDocument(pageToExport);

XFilter drawFilter = (XFilter)
UnoRuntime.queryInterface(XFilter.class, exporter);
drawFilter.filter(exportProperties);
} else {
throw new Exception("Chart shape could not be found. ");
}

}
} else {
throw new Exception("Chart sheet could not be found. ");
}
}
catch (Exception e) {
e.printStackTrace();
throw new Exception("Error exporting chart :" + e.getMessage());
}
finally {
if(drawDocument != null) {
//kill off the local draw document
drawDocument.dispose();
}
}
}

[leofantasy]

Have you tested the java code?
I run the codes, it doesn't successful!

[mihel]

Java code works perfectly well.
Except for some minor issues.
Many thanks!!!