public class OCalcDoc extends ORootDoc
| Modifier and Type | Class and Description |
|---|---|
class |
OCalcDoc.Sheet
A Calc document sheet.
|
ORootDoc.Info| Constructor and Description |
|---|
OCalcDoc(java.lang.String url)
Constructs and opens a Calc document.
|
| Modifier and Type | Method and Description |
|---|---|
java.util.Collection<java.lang.String> |
chartNames()
Returns a collection of the names of all charts in the document.
|
void |
insertBitmap(OCalcDoc.Sheet sheet,
ODrawArea area,
java.lang.String bitmapURL)
Inserts a bitmap.
|
OCalcDoc.Sheet |
insertSheet(short number,
java.lang.String name)
Inserts a sheet.
|
OCalcDoc.Sheet |
sheet(short number)
Returns a sheet by number.
|
OCalcDoc.Sheet |
sheet(java.lang.String name)
Returns a sheet by name.
|
java.util.ArrayList<OCalcDoc.Sheet> |
sheets()
Returns a collection of all document sheets.
|
java.lang.String |
toString()
Returns a string representation of the document.
|
void |
writeCsv(java.lang.String url)
Writes the document using OFileFilter.CSV.
|
java.lang.String |
writeOds(java.lang.String url)
Writes the document using OFileFilter.ODS.
|
com.sun.star.sheet.XSpreadsheetDocument |
xGetXDoc()
Gets the XSpreadsheetDocument object.
|
close, deleteStyle, info, logFields, logServices, logShapes, logStyles, logSummary, numPages, numShapes, numStyles, read, setupStyles, shapes, shapesByType, style, styleFamilies, styles, styles, url, write, writeProtected, xGetMSFactory, xGetXComplogProps, xGetPropSetpublic OCalcDoc(java.lang.String url)
throws com.sun.star.uno.Exception
url - the URLcom.sun.star.uno.Exceptionpublic java.util.ArrayList<OCalcDoc.Sheet> sheets()
public OCalcDoc.Sheet sheet(short number)
number - the sheet numberpublic OCalcDoc.Sheet sheet(java.lang.String name)
name - the sheet namepublic java.lang.String toString()
public OCalcDoc.Sheet insertSheet(short number, java.lang.String name) throws com.sun.star.uno.Exception
number - the sheet numbername - the sheet namecom.sun.star.uno.Exceptionpublic void insertBitmap(OCalcDoc.Sheet sheet, ODrawArea area, java.lang.String bitmapURL) throws com.sun.star.uno.Exception
sheet - the sheetarea - the draw area for the bitmapbitmapURL - the bitmap URLcom.sun.star.uno.Exceptionpublic java.util.Collection<java.lang.String> chartNames()
throws com.sun.star.uno.Exception
com.sun.star.uno.Exceptionpublic java.lang.String writeOds(java.lang.String url)
throws com.sun.star.uno.Exception
url - the URLcom.sun.star.uno.Exceptionpublic void writeCsv(java.lang.String url)
throws com.sun.star.uno.Exception
url - the URLcom.sun.star.uno.Exceptionpublic com.sun.star.sheet.XSpreadsheetDocument xGetXDoc()