org.apache.poi.xssf.usermodel

Class XSSFVMLDrawing

java.lang.Object

org.apache.poi.POIXMLDocumentPart

org.apache.poi.xssf.usermodel.XSSFVMLDrawing

public final class XSSFVMLDrawing
extends POIXMLDocumentPart

Represents a SpreadsheetML VML drawing.

In Excel 2007 VML drawings are used to describe properties of cell comments, although the spec says that VML is deprecated:

The VML format is a legacy format originally introduced with Office 2000 and is included and fully defined in this Standard for backwards compatibility reasons. The DrawingML format is a newer and richer format created with the goal of eventually replacing any uses of VML in the Office Open XML formats. VML should be considered a deprecated format included in Office Open XML for legacy reasons only and new applications that need a file format for drawings are strongly encouraged to use preferentially DrawingML

Warning - Excel is known to put invalid XML into these files! For example, >br< without being closed or escaped crops up.

See 6.4 VML - SpreadsheetML Drawing in Office Open XML Part 4 - Markup Language Reference.pdf

Author:

Yegor Kozlov

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.poi.POIXMLDocumentPart

POIXMLDocumentPart.RelationPart

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	XSSFVMLDrawing() Create a new SpreadsheetML drawing
protected	XSSFVMLDrawing(PackagePart part) Construct a SpreadsheetML drawing from a package part

Method Summary

Modifier and Type	Method and Description
protected void	commit() Save the content in the underlying package part.
protected com.microsoft.schemas.vml.CTShape	findCommentShape(int row, int col) Find a shape with ClientData of type "NOTE" and the specified row and column
protected List<XmlObject>	getItems()
protected com.microsoft.schemas.vml.CTShape	newCommentShape()
protected void	read(InputStream is)
protected boolean	removeCommentShape(int row, int col)
protected void	write(OutputStream out)

Methods inherited from class org.apache.poi.POIXMLDocumentPart

_invokeOnDocumentRead, addRelation, createRelationship, createRelationship, createRelationship, getNextPartNumber, getPackagePart, getParent, getRelationById, getRelationId, getRelationParts, getRelations, getTargetPart, onDocumentCreate, onDocumentRead, onDocumentRemove, onSave, prepareForCommit, read, rebase, removeRelation, removeRelation, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

XSSFVMLDrawing

protected XSSFVMLDrawing()

Create a new SpreadsheetML drawing

See Also:

XSSFSheet.createDrawingPatriarch()

XSSFVMLDrawing

protected XSSFVMLDrawing(PackagePart part)
                  throws IOException,
                         XmlException

Construct a SpreadsheetML drawing from a package part

Parameters:

part - the package part holding the drawing data, the content type must be application/vnd.openxmlformats-officedocument.drawing+xml

Throws:

IOException

XmlException

Since:

POI 3.14-Beta1

Method Detail

read

protected void read(InputStream is)
             throws IOException,
                    XmlException

Throws:

IOException

XmlException

getItems

protected List<XmlObject> getItems()

write

protected void write(OutputStream out)
              throws IOException

Throws:

IOException

commit

protected void commit()
               throws IOException

Description copied from class: POIXMLDocumentPart

Save the content in the underlying package part. Default implementation is empty meaning that the package part is left unmodified. Sub-classes should override and add logic to marshal the "model" into Ooxml4J. For example, the code saving a generic XML entry may look as follows:

 protected void commit() throws IOException {
   PackagePart part = getPackagePart();
   OutputStream out = part.getOutputStream();
   XmlObject bean = getXmlBean(); //the "model" which holds changes in memory
   bean.save(out, DEFAULT_XML_OPTIONS);
   out.close();
 }
 

Overrides:

commit in class POIXMLDocumentPart

Throws:

IOException - a subclass may throw an IOException if the changes can't be committed

newCommentShape

protected com.microsoft.schemas.vml.CTShape newCommentShape()

findCommentShape

protected com.microsoft.schemas.vml.CTShape findCommentShape(int row,
                                                             int col)

Find a shape with ClientData of type "NOTE" and the specified row and column

Returns:

the comment shape or null

removeCommentShape

protected boolean removeCommentShape(int row,
                                     int col)