workbook-ag凯发旗舰厅

overview

package

class

tree

deprecated

index

help

prev class next class

frames no frames

summary: nested | field | constr | method

detail: field | constr | method

com.spire.xls
class workbook

java.lang.object
  com.spire.xls.workbook

public final class workbook
extends java.lang.object
extends java.lang.object

represents the workbook object of excel.

constructor summary
`workbook()` create a new instance of workbook.

method summary
`void`	`addpivottablestyle(pivottablestyle pts)`
`static boolean`	`bookispasswordprotected(java.lang.string filename)` check if the file is password protected.
`void`	`calculateallvalue()` caculate all formula for the workbook
`java.lang.object`	`calculateformulavalue(java.lang.string text)` calculates the string formula
`void`	`changepalettecolor(java.awt.color color, int index)` changes the palette for the spreadsheet in the specified index.
`double`	`columnwidthtopixels(double columnwidth)` onverts column width in characters into column width in pixels.
`boolean`	`containsfont(excelfont font)` indicates whether the workbook contains specified font.
`void`	`copytoclipboard()` copies whole workbook to the clipboard.
`void`	`copytoclipboard(worksheet worksheet)` copies the selected worksheet to clipboard.
`worksheet`	`createemptysheet()` create a new worksheet.
`worksheet`	`createemptysheet(java.lang.string name)` create a new worksheet.
`void`	`createemptysheets(int sheetcount)` create workbook with specified number of worksheets.
`void`	`createemptysheets(java.lang.string[] sheetnames)` create workbook with specified names of worksheets.
`excelfont`	`createfont()` creates a font object and adds it to the workbook.
`excelfont`	`createfont(java.awt.font font)` creates a font object and add it to the workbook.
`pivotstyle`	`createpivotstyle()`
`void`	`dispose()`
`cellrange[]`	`findallbool(boolean boolvalue)` finds the cell with the input bool.
`cellrange[]`	`findalldatetime(java.util.date datetimevalue)` finds the cell with the input datetime.
`cellrange[]`	`findallnumber(double doublevalue, boolean formulavalue)` finds the cell with the input double.
`cellrange[]`	`findallstring(java.lang.string stringvalue, boolean formula, boolean formulavalue)` finds the cell with the input string.
`cellrange`	`findbool(boolean boolvalue)` finds the cell with the input bool.
`cellrange`	`finddatetime(java.util.date datetimevalue)` finds the cell with the input datetime.
`cellrange`	`findnumber(double doublevalue, boolean formulavalue)` finds the cell with the input number.
`cellrange`	`findstring(java.lang.string stringvalue, boolean formula, boolean formulavalue)` finds the cell with the input string.
`worksheet`	`getactivesheet()` returns an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window or workbook.
`int`	`getactivesheetindex()` gets index of the active worksheet.
`addinfunctionscollection`	`getaddinfunctions()` returns collection of add-in functions.
`boolean`	`getallow3drangesindatavalidation()` indicates whether to allow usage of 3d ranges in datavalidation list property (ms excel doesn't allow).
`excelcalculationmode`	`getcalculationmode()` get calculation mode.
`chartscollection`	`getcharts()` returns a sheets collection that represents all the chart sheets in the specified workbook.
`chartsheet`	`getchartsheetbyname(java.lang.string name)`
`java.util.arraylist`	`getchartsheets()`
`java.lang.string`	`getcodename()` name which used by macros to access to workbook items.
`java.awt.color[]`	`getcolors()` returns colors in the palette for the workbook.
`convertersetting`	`getconvertersetting()` get converter setting
`icustomdocumentproperties`	`getcustomdocumentproperties()` returns collection that represents all the custom document properties for the specified workbook.
`java.lang.string[]`	`getcustomfontfilepaths()` returns the custom path of font files.
`java.util.hashtable`	`getcustomfontparsedresult()` get result that parse the custom path of font files
`java.util.hashtable`	`getcustomtablestyles()`
`datasorter`	`getdatasorter()` gets data sorter to sort the data.
`boolean`	`getdate1904()` true if the workbook uses the 1904 date system.
`java.nio.charset.charset`	`getdefaultcharset()` default charset = utf-8
`java.lang.string`	`getdefaultfontname()` returns the name of the default font.
`double`	`getdefaultfontsize()` returns the default font size.
`boolean`	`getdisablemacrosstart()` allows users to disable load of macros from document.
`builtindocumentproperties`	`getdocumentproperties()` returns a builtindocumentproperties collection that represents all the built-in document properties for the specified workbook.
`java.lang.string`	`getfilename()` gets file name.
`markerdesigner`	`getmarkerdesigner()`
`excelcolors`	`getmatchingcolor(java.awt.color color)` find best matching color in workbook palette.
`excelcolors`	`getmatchingcolor(int r, int g, int b)` find best matching color in workbook palette.
`int`	`getmaxdigitwidth()`
`inameranges`	`getnameranges()` gets names collection that represents all the names in the specified workbook
`ixlsrange`	`getolesize()` get the size of the visible range of cells when this workbook is displyed as an embedded obect in another document;
`java.lang.string`	`getopenpassword()` returns password to encrypt document.
`boolean`	`getoptimizeimport()` indicates whether to optimize import data.
`java.awt.color`	`getpalettecolor(excelcolors color)` gets excel color from workbook palette.
`pivotcachescollection`	`getpivotcaches()`
`boolean`	`getprintusingimagemode()` get print by using image mode
`boolean`	`getreadonly()` indicates whether the workbook has been opened as read-only.
`int`	`getselectedtab()` gets tab index of selected.
`boolean`	`getshowtabs()` gets a value whether the workbook tabs are displayed.
`java.util.listpagecolrow>>`	`getsplitpageinfo()`
`datatable`	`getsplitpagetable(workbook wb)`
`stylescollection`	`getstyles()` returns a styles collection that represents all the styles in the specified workbook.
`excelversion`	`getversion()`
`worksheetscollection`	`getworksheets()` returns a sheets collection that represents all the worksheets in the specified workbook.
`boolean`	`hasmacros()` indicates whether contains vba macros.
`void`	`hasmacros(boolean value)` sets whether contains vba macros.
`void`	`initcalcengine()` initilize calc engine
`boolean`	`iscellprotection()` indicates whether cells are protected.
`boolean`	`isrighttoleft()` indicates whether worksheet is displayed right to left.
`void`	`isrighttoleft(boolean value)` indicates whether worksheet is displayed right to left.
`boolean`	`issaved()` indicates whether workbook changes have been saved.
`boolean`	`iswindowprotection()` indicates window is protected.
`void`	`loadfromfile(java.lang.string filename)` loads a file and imports its data.
`void`	`loadfromfile(java.lang.string filename, boolean preservemode)` loads a file and imports its data.
`void`	`loadfromfile(java.lang.string filename, excelversion version)` loads a file and imports its data.
`void`	`loadfromfile(java.lang.string filename, java.lang.string separator)` loads text files stream with user defined separator.
`void`	`loadfromfile(java.lang.string filename, java.lang.string separator, int row, int column)` loads text files with user defined separator.
`void`	`loadfromfile(java.lang.string filename, java.lang.string separator, int row, int column, excelversion version)` loads text files with user defined separator.
`void`	`loadfromhtml(java.io.inputstream stream)` loads a html file and imports its data.
`void`	`loadfromhtml(java.lang.string filename)` loads a html file and imports its data.
`void`	`loadfrommhtml(java.io.inputstream stream)` loads a mhtml file and imports its data.
`void`	`loadfrommhtml(java.lang.string filename)` loads a mhtml file and imports its data.
`void`	`loadfromstream(java.io.inputstream stream)` loads workbook from the stream.
`void`	`loadfromstream(java.io.inputstream stream, boolean loadstyles)` load workbook from the stream.
`void`	`loadfromstream(java.io.inputstream stream, excelversion version)` load workbook from the stream.
`void`	`loadfromstream(java.io.inputstream stream, java.lang.string separator, int row, int column)` loads text files stream with user defined separator.max row 60000.
`void`	`loadfromstream(java.io.inputstream stream, java.lang.string separator, int row, int column, excelversion version)` loads text files stream with user defined separator.
`void`	`loadfromxml(java.io.inputstream stream)` loads a xml file and imports its data.
`void`	`loadfromxml(java.lang.string filename)` loads a xml file and imports its data.
`void`	`pastefromclipboard()` copies workbook and all its worksheets from the clipboard.
`double`	`pixelstocolumnwidth(double pixels)` converts column width in pixels into column width in characters.
`void`	`protect(java.lang.string passwordtoopen)` protects file, also protects workbook window and structure.
`void`	`protect(java.lang.string passwordtoopen, boolean bisprotectwindow, boolean bisprotectcontent)` protects file,also indicates whether protects workbook window and structure or not
`void`	`protectworkbook(boolean bisprotectwindow, boolean bisprotectcontent, java.lang.string password)` sets protection for workbook.
`void`	`replace(java.lang.string oldvalue, datacolumn newvalues, boolean includecolumnname)` replaces cell's value from data column values.
`void`	`replace(java.lang.string oldvalue, datatable newvalues, boolean includecolumnname)` replaces cell's value from data table values.
`void`	`replace(java.lang.string oldvalue, java.util.date newvalue)` replaces cell's value by specified value.
`void`	`replace(java.lang.string oldvalue, double newvalue)` replaces cell's value by specified value.
`void`	`replace(java.lang.string oldvalue, double[] newvalues, boolean isvertical)` replaces cell's value from array.
`void`	`replace(java.lang.string oldvalue, int[] newvalues, boolean isvertical)` replaces cell's value from array.
`void`	`replace(java.lang.string oldvalue, java.lang.string newvalue)` replaces cell's value by specified value.
`void`	`replace(java.lang.string oldvalue, java.lang.string[] newvalues, boolean isvertical)` replaces cell's value from array.
`void`	`resetpalette()` resets the color palette to the default colors.
`boolean`	`retainhiddendatatocsv()` gets retain hidden data.
`void`	`retainhiddendatatocsv(boolean value)` sets retain hidden data.
`void`	`save()` saves changes to the specified workbook
`java.awt.image.bufferedimage[]`	`saveasimage(float dpix, float dpiy)` save workbook to image.
`java.awt.image.bufferedimage`	`saveasimage(int sheetindex, float dpix, float dpiy)` save workbook to image.
`void`	`saveastemplate(java.lang.string filename)` save workbook as template to file.
`void`	`saveasxml(java.io.inputstream stream)` save workbook as xml format to stream.
`void`	`saveasxml(java.lang.string filename)` save workbook to an xml data file.
`java.awt.image.bufferedimage`	`savechartasimage(chartsheet chartsheet)` save chart to image.
`java.awt.image.bufferedimage[]`	`savechartasimage(worksheet worksheet)` save chart to images.
`java.awt.image.bufferedimage`	`savechartasimage(worksheet worksheet, int chartindex)` saves chart to image.
`void`	`savetofile(java.lang.string filename)` saves changes to the workbook in a different file
`void`	`savetofile(java.lang.string filename, excelversion version)` saves changes to the workbook in a different file
`void`	`savetofile(java.lang.string filename, fileformat fileformat)` saves changes to the workbook in a different file
`void`	`savetofile(java.lang.string filename, java.lang.string separator)` saves changes to the workbook in a different file
`void`	`savetostream(java.io.outputstream stream)` saves workbook the stream
`void`	`savetostream(java.io.outputstream stream, fileformat fileformat)` saves workbook to stream.
`void`	`savetostream(java.io.outputstream stream, java.lang.string separator)` save workbook the stream.
`void`	`setactivesheetindex(int value)` sets index of the active worksheet.
`void`	`setallow3drangesindatavalidation(boolean value)` indicates whether to allow usage of 3d ranges in datavalidation list property (ms excel doesn't allow).
`void`	`setcalculationmode(excelcalculationmode value)` set calculation mode.
`void`	`setcodename(java.lang.string value)` name which used by macros to access to workbook items.
`void`	`setconvertersetting(convertersetting value)`
`void`	`setcustomfontfilepaths(java.lang.string[] value)` sets the custom path of font files.
`void`	`setdate1904(boolean value)` set if the workbook uses the 1904 date system.
`void`	`setdefaultcharset(java.nio.charset.charset defaultcharset)`
`void`	`setdefaultfontname(java.lang.string value)` sets the name of the default font.
`void`	`setdefaultfontsize(double value)` sets the default font size.
`void`	`setdisablemacrosstart(boolean value)` allows users to disable load of macros from document.
`void`	`setmaxdigitwidth(int w)`
`void`	`setolesize(int firstrow, int firstcolumn, int lastrow, int lastcolumn)` set the size of the visible range of cells when this workbook is displyed as an embedded obect in another document;
`void`	`setopenpassword(java.lang.string openpassword)` sets password to encrypt document.
`void`	`setoptimizeimport(boolean value)` indicates whether to optimize import data.
`void`	`setprintusingimagemode(boolean usingimagemode)` set print by using image mode
`void`	`setselectedtab(int value)` sets tab index of selected.
`void`	`setshowtabs(boolean value)` sets a value whether the workbook tabs are displayed.
`void`	`setversion(excelversion version)`
`void`	`setwriteprotectionpassword(java.lang.string password)` sets write protection password.
`void`	`unprotect()` unprotects file also upprotect workbook window and structure
`void`	`unprotect(java.lang.string bookwindowandstructurepassword)` unprotect file also upprotect workbook window and structure
`void`	`unprotectworkbook(java.lang.string password)` unprotect workbook window and structure

constructor detail

workbook

public workbook()

create a new instance of workbook.

method detail

getworksheets

public worksheetscollection getworksheets()

returns a sheets collection that represents all the worksheets in the specified workbook. read-only sheets object.

returns:: represents the worksheets collection.

getnameranges

public inameranges getnameranges()

gets names collection that represents all the names in the specified workbook

returns:

getactivesheet

public worksheet getactivesheet()

returns an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window or workbook. returns nothing if no sheet is active. read-only.

returns:

getallow3drangesindatavalidation

public boolean getallow3drangesindatavalidation()

indicates whether to allow usage of 3d ranges in datavalidation list property (ms excel doesn't allow).

returns:

setallow3drangesindatavalidation

public void setallow3drangesindatavalidation(boolean value)

indicates whether to allow usage of 3d ranges in datavalidation list property (ms excel doesn't allow).

parameters:: value -

getactivesheetindex

public int getactivesheetindex()

gets index of the active worksheet.

returns:

setactivesheetindex

public void setactivesheetindex(int value)

sets index of the active worksheet.

parameters:: value -

getaddinfunctions

public addinfunctionscollection getaddinfunctions()

returns collection of add-in functions.

returns:

getcalculationmode

public excelcalculationmode getcalculationmode()

get calculation mode.

returns:

setcalculationmode

public void setcalculationmode(excelcalculationmode value)

set calculation mode.

parameters:: value -

getdatasorter

public datasorter getdatasorter()

gets data sorter to sort the data.

returns:

getcodename

public java.lang.string getcodename()

name which used by macros to access to workbook items.

returns:

setcodename

public void setcodename(java.lang.string value)

name which used by macros to access to workbook items.

getcolors

public java.awt.color[] getcolors()

returns colors in the palette for the workbook. the palette has 56 entries, each represented by an rgb value. read/write object.

returns:

getconvertersetting

public convertersetting getconvertersetting()

get converter setting

returns:: convert setting.

setconvertersetting

public void setconvertersetting(convertersetting value)

getdate1904

public boolean getdate1904()

true if the workbook uses the 1904 date system. read/write boolean.

returns:

setdate1904

public void setdate1904(boolean value)

set if the workbook uses the 1904 date system. read/write boolean.

parameters:: value -

getdefaultfontname

public java.lang.string getdefaultfontname()

returns the name of the default font.

returns:

setdefaultfontname

public void setdefaultfontname(java.lang.string value)

sets the name of the default font.

parameters:: value -

getdefaultfontsize

public double getdefaultfontsize()

returns the default font size.

returns:

setdefaultfontsize

public void setdefaultfontsize(double value)

sets the default font size.

parameters:: value -

getcustomfontfilepaths

public java.lang.string[] getcustomfontfilepaths()

returns the custom path of font files.

returns:

setcustomfontfilepaths

public void setcustomfontfilepaths(java.lang.string[] value)

sets the custom path of font files.

parameters:: value -

getcustomfontparsedresult

public java.util.hashtable getcustomfontparsedresult()

get result that parse the custom path of font files

getdisablemacrosstart

public boolean getdisablemacrosstart()

allows users to disable load of macros from document.

returns:

setdisablemacrosstart

public void setdisablemacrosstart(boolean value)

allows users to disable load of macros from document.

parameters:: value -

getfilename

public java.lang.string getfilename()

gets file name.

returns:

hasmacros

public boolean hasmacros()

indicates whether contains vba macros.

returns:

hasmacros

public void hasmacros(boolean value)

sets whether contains vba macros.

parameters:: value -

iscellprotection

public boolean iscellprotection()

indicates whether cells are protected.

returns:

isrighttoleft

public boolean isrighttoleft()

indicates whether worksheet is displayed right to left.

isrighttoleft

public void isrighttoleft(boolean value)

indicates whether worksheet is displayed right to left.

issaved

public boolean issaved()

indicates whether workbook changes have been saved.

returns:

iswindowprotection

public boolean iswindowprotection()

indicates window is protected.

returns:

getmarkerdesigner

public markerdesigner getmarkerdesigner()

getmaxdigitwidth

public int getmaxdigitwidth()

getopenpassword

public java.lang.string getopenpassword()

returns password to encrypt document.

returns:

setopenpassword

public void setopenpassword(java.lang.string openpassword)

sets password to encrypt document.

parameters:: openpassword -

getoptimizeimport

public boolean getoptimizeimport()

indicates whether to optimize import data. this option will take effect only on import methods that are available with the worksheet warning: setting this property to true can decrease memory significantly, but will increase the performance of data import .

setoptimizeimport

public void setoptimizeimport(boolean value)

getpivotcaches

public pivotcachescollection getpivotcaches()

getreadonly

public boolean getreadonly()

indicates whether the workbook has been opened as read-only.

returns:

getselectedtab

public int getselectedtab()

gets tab index of selected.

returns:

setselectedtab

public void setselectedtab(int value)

sets tab index of selected.

parameters:: value -

getshowtabs

public boolean getshowtabs()

gets a value whether the workbook tabs are displayed.

setshowtabs

public void setshowtabs(boolean value)

sets a value whether the workbook tabs are displayed.

parameters:: value -

getstyles

public stylescollection getstyles()

returns a styles collection that represents all the styles in the specified workbook. read-only.

returns:

getversion

public excelversion getversion()

setversion

public void setversion(excelversion version)

getcharts

public chartscollection getcharts()

returns a sheets collection that represents all the chart sheets in the specified workbook. read-only.

returns:

getchartsheets

public java.util.arraylist getchartsheets()

getcustomdocumentproperties

public icustomdocumentproperties getcustomdocumentproperties()

returns collection that represents all the custom document properties for the specified workbook. read-only.

returns:

getcustomtablestyles

public java.util.hashtable getcustomtablestyles()

getdocumentproperties

public builtindocumentproperties getdocumentproperties()

returns a builtindocumentproperties collection that represents all the built-in document properties for the specified workbook. read-only.

returns:

loadfromfile

public void loadfromfile(java.lang.string filename)

loads a file and imports its data.

parameters:: filename - file name.

loadfromfile

public void loadfromfile(java.lang.string filename,
                         boolean preservemode)

loads a file and imports its data.

parameters:: filename - file name; preservemode - preserve mode

loadfromfile

public void loadfromfile(java.lang.string filename,
                         excelversion version)

loads a file and imports its data.

parameters:: filename - file name; version - excel version

loadfromfile

public void loadfromfile(java.lang.string filename,
                         java.lang.string separator)

loads text files stream with user defined separator.

parameters:: filename - file name; separator - delimiter of text file.

loadfromfile

public void loadfromfile(java.lang.string filename,
                         java.lang.string separator,
                         int row,
                         int column)

loads text files with user defined separator.

parameters:: filename - file name.; separator - delimiter of text file.; row - start row.; column - start column.

loadfromfile

public void loadfromfile(java.lang.string filename,
                         java.lang.string separator,
                         int row,
                         int column,
                         excelversion version)

loads text files with user defined separator.

parameters:: filename - file name.; separator - delimiter of text file.; row - start row.; column - start column.; version - workbook version

loadfromstream

public void loadfromstream(java.io.inputstream stream)

loads workbook from the stream.

parameters:: stream - stream contains data.

loadfromstream

public void loadfromstream(java.io.inputstream stream,
                           boolean loadstyles)

load workbook from the stream.

parameters:: stream - stream contains data.; loadstyles - indicates whether loads styles.

loadfromstream

public void loadfromstream(java.io.inputstream stream,
                           excelversion version)

load workbook from the stream.

parameters:: stream - stream contains data; version - excel version

loadfromstream

public void loadfromstream(java.io.inputstream stream,
                           java.lang.string separator,
                           int row,
                           int column)

loads text files stream with user defined separator.max row 60000.

parameters:: stream - file stream.; separator - delimiter of text file.; row - start row.; column - start column.

loadfromstream

public void loadfromstream(java.io.inputstream stream,
                           java.lang.string separator,
                           int row,
                           int column,
                           excelversion version)

loads text files stream with user defined separator. version2007 support 60000 row

parameters:: stream - file stream.; separator - delimiter of text file.; row - start row.; column - start column.; version - excel version.

loadfromxml

public void loadfromxml(java.lang.string filename)

loads a xml file and imports its data.

parameters:: filename - file name.

loadfromxml

public void loadfromxml(java.io.inputstream stream)

loads a xml file and imports its data.

parameters:: stream - stream contains data.

loadfromhtml

public void loadfromhtml(java.lang.string filename)

loads a html file and imports its data.

parameters:: filename - file name.

loadfromhtml

public void loadfromhtml(java.io.inputstream stream)

loads a html file and imports its data.

parameters:: stream - stream contains data.

loadfrommhtml

public void loadfrommhtml(java.lang.string filename)

loads a mhtml file and imports its data.

parameters:: filename - file name.

loadfrommhtml

public void loadfrommhtml(java.io.inputstream stream)

loads a mhtml file and imports its data.

parameters:: stream - stream contains data.

savetofile

public void savetofile(java.lang.string filename)

saves changes to the workbook in a different file

parameters:: filename - file name.

savetofile

public void savetofile(java.lang.string filename,
                       fileformat fileformat)

saves changes to the workbook in a different file

parameters:: filename - file name; fileformat - file format

savetofile

public void savetofile(java.lang.string filename,
                       java.lang.string separator)

saves changes to the workbook in a different file

parameters:: filename - file name.; separator -

retainhiddendatatocsv

public boolean retainhiddendatatocsv()

gets retain hidden data.

returns:

retainhiddendatatocsv

public void retainhiddendatatocsv(boolean value)

sets retain hidden data.

parameters:: value -

dispose

public void dispose()

savetofile

public void savetofile(java.lang.string filename,
                       excelversion version)

saves changes to the workbook in a different file

parameters:: filename - file name; version - excel version

addpivottablestyle

public void addpivottablestyle(pivottablestyle pts)

calculateformulavalue

public java.lang.object calculateformulavalue(java.lang.string text)

calculates the string formula

parameters:: text -
returns:

calculateallvalue

public void calculateallvalue()

caculate all formula for the workbook

changepalettecolor

public void changepalettecolor(java.awt.color color,
                               int index)

changes the palette for the spreadsheet in the specified index.

parameters:: color - color structure; index - palette index,value should be from 0 to 55

columnwidthtopixels

public double columnwidthtopixels(double columnwidth)

onverts column width in characters into column width in pixels.

parameters:: columnwidth - column width in characters.
returns:: column width in pixels.

containsfont

public boolean containsfont(excelfont font)

indicates whether the workbook contains specified font.

parameters:: font -
returns:

copytoclipboard

public void copytoclipboard()

copies whole workbook to the clipboard.

copytoclipboard

public void copytoclipboard(worksheet worksheet)

copies the selected worksheet to clipboard.

parameters:: worksheet -

createemptysheet

public worksheet createemptysheet()

create a new worksheet.

returns:

createemptysheet

public worksheet createemptysheet(java.lang.string name)

create a new worksheet.

parameters:: name - sheet name.
returns:

createemptysheets

public void createemptysheets(int sheetcount)

create workbook with specified number of worksheets.

parameters:: sheetcount -

createemptysheets

public void createemptysheets(java.lang.string[] sheetnames)

create workbook with specified names of worksheets.

parameters:: sheetnames -

createfont

public excelfont createfont()

creates a font object and adds it to the workbook.

returns:

createfont

public excelfont createfont(java.awt.font font)

creates a font object and add it to the workbook.

parameters:: font - font to add
returns:

createpivotstyle

public pivotstyle createpivotstyle()

findallbool

public cellrange[] findallbool(boolean boolvalue)

finds the cell with the input bool.

parameters:: boolvalue - bool value to search for
returns:: found ranges

findallnumber

public cellrange[] findallnumber(double doublevalue,
                                 boolean formulavalue)

finds the cell with the input double.

parameters:: doublevalue - double value to search for.; formulavalue - indicates whether includes formula value to search for.
returns:

findallstring

public cellrange[] findallstring(java.lang.string stringvalue,
                                 boolean formula,
                                 boolean formulavalue)

finds the cell with the input string.

parameters:: stringvalue - string value to search for; formula - indicates whether includes formula to search for.; formulavalue - indicates whether includes formula value to search for.
returns:

findalldatetime

public cellrange[] findalldatetime(java.util.date datetimevalue)

finds the cell with the input datetime.

parameters:: datetimevalue -
returns:

findbool

public cellrange findbool(boolean boolvalue)

finds the cell with the input bool.

parameters:: boolvalue - bool value to search for.
returns:: found range.

findnumber

public cellrange findnumber(double doublevalue,
                            boolean formulavalue)

finds the cell with the input number.

parameters:: doublevalue - double value to search for.; formulavalue - indicates whether includes formula value to search for.
returns:: found range.

findstring

public cellrange findstring(java.lang.string stringvalue,
                            boolean formula,
                            boolean formulavalue)

finds the cell with the input string.

parameters:: stringvalue - string value to search for.; formula - indicates whether includes formula to search for.; formulavalue - indicates whether includes formula value to search for.
returns:: found range.

finddatetime

public cellrange finddatetime(java.util.date datetimevalue)

finds the cell with the input datetime.

parameters:: datetimevalue - datetime value to search for.
returns:: found range.

getmatchingcolor

public excelcolors getmatchingcolor(java.awt.color color)

find best matching color in workbook palette.

parameters:: color - color to search for.
returns:: workbook palette color.

getmatchingcolor

public excelcolors getmatchingcolor(int r,
                                    int g,
                                    int b)

find best matching color in workbook palette.

parameters:: r - red color.; g - green color.; b - blue color.
returns:: workbook palette color.

getpalettecolor

public java.awt.color getpalettecolor(excelcolors color)

gets excel color from workbook palette.

parameters:: color - index from palette array.
returns:: rgb color.

getsplitpageinfo

public java.util.listpagecolrow>> getsplitpageinfo()

getsplitpagetable

public datatable getsplitpagetable(workbook wb)

initcalcengine

public void initcalcengine()

initilize calc engine

bookispasswordprotected

public static boolean bookispasswordprotected(java.lang.string filename)

check if the file is password protected.

parameters:: filename -
returns:

pastefromclipboard

public void pastefromclipboard()

copies workbook and all its worksheets from the clipboard.

pixelstocolumnwidth

public double pixelstocolumnwidth(double pixels)

converts column width in pixels into column width in characters.

parameters:: pixels - column width in pixels.
returns:: column width in characters.

protect

public void protect(java.lang.string passwordtoopen)

protects file, also protects workbook window and structure.

parameters:: passwordtoopen - password to open file.

protect

public void protect(java.lang.string passwordtoopen,
                    boolean bisprotectwindow,
                    boolean bisprotectcontent)

protects file,also indicates whether protects workbook window and structure or not

parameters:: passwordtoopen - password to open file.; bisprotectwindow - indicates if protect workbook window.; bisprotectcontent - indicates if protect workbook content.

protectworkbook

public void protectworkbook(boolean bisprotectwindow,
                            boolean bisprotectcontent,
                            java.lang.string password)

sets protection for workbook.

parameters:: bisprotectwindow - indicates if protect workbook window.; bisprotectcontent - indicates if protect workbook content.; password - password

replace

public void replace(java.lang.string oldvalue,
                    datacolumn newvalues,
                    boolean includecolumnname)

replaces cell's value from data column values.

parameters:: oldvalue - value to replace.; newvalues - new data.; includecolumnname - indicates whether includes column name.

replace

public void replace(java.lang.string oldvalue,
                    datatable newvalues,
                    boolean includecolumnname)

replaces cell's value from data table values.

parameters:: oldvalue - value to replace.; newvalues - new data.; includecolumnname - indicates whether includes column name.

replace

public void replace(java.lang.string oldvalue,
                    java.util.date newvalue)

replaces cell's value by specified value.

parameters:: oldvalue - value to replace.; newvalue - new value

replace

public void replace(java.lang.string oldvalue,
                    double newvalue)

replaces cell's value by specified value.

parameters:: oldvalue - value to replace.; newvalue - new value.

replace

public void replace(java.lang.string oldvalue,
                    double[] newvalues,
                    boolean isvertical)

replaces cell's value from array.

parameters:: oldvalue - value to replace.; newvalues - new values.; isvertical - indicates whether new values should be inserted vertically.

replace

public void replace(java.lang.string oldvalue,
                    int[] newvalues,
                    boolean isvertical)

replaces cell's value from array.

parameters:: oldvalue - value to replace.; newvalues - new values.; isvertical - indicates whether new values should be inserted vertically.

replace

public void replace(java.lang.string oldvalue,
                    java.lang.string newvalue)

replaces cell's value by specified value.

parameters:: oldvalue - value to replace.; newvalue - new value

replace

public void replace(java.lang.string oldvalue,
                    java.lang.string[] newvalues,
                    boolean isvertical)

replaces cell's value from array.

parameters:: oldvalue - value to replace.; newvalues - new values.; isvertical - indicates whether new values should be inserted vertically.

resetpalette

public void resetpalette()

resets the color palette to the default colors.

save

public void save()

saves changes to the specified workbook

saveasimage

public java.awt.image.bufferedimage[] saveasimage(float dpix,
                                                  float dpiy)

save workbook to image.

parameters:: dpix - dpi x; dpiy - dpi y
returns:

saveasimage

public java.awt.image.bufferedimage saveasimage(int sheetindex,
                                                float dpix,
                                                float dpiy)

save workbook to image.

parameters:: sheetindex - sheet index; dpix - dpi x; dpiy - dpi y
returns:

saveasxml

public void saveasxml(java.lang.string filename)

save workbook to an xml data file.

parameters:: filename - xml file name.

saveasxml

public void saveasxml(java.io.inputstream stream)

save workbook as xml format to stream.

parameters:: stream - stream object.

savechartasimage

public java.awt.image.bufferedimage savechartasimage(chartsheet chartsheet)

save chart to image.

parameters:: chartsheet - chart sheet
returns:

savechartasimage

public java.awt.image.bufferedimage[] savechartasimage(worksheet worksheet)

save chart to images.

parameters:: worksheet - worksheet instance
returns:: worksheet chart to images.

savechartasimage

public java.awt.image.bufferedimage savechartasimage(worksheet worksheet,
                                                     int chartindex)

saves chart to image.

parameters:: worksheet - work sheet; chartindex - chart index
returns:

saveastemplate

public void saveastemplate(java.lang.string filename)

save workbook as template to file.

parameters:: filename -

savetostream

public void savetostream(java.io.outputstream stream)

saves workbook the stream

parameters:: stream - stream object

savetostream

public void savetostream(java.io.outputstream stream,
                         fileformat fileformat)

saves workbook to stream.

parameters:: stream -; fileformat -

savetostream

public void savetostream(java.io.outputstream stream,
                         java.lang.string separator)

save workbook the stream.

parameters:: stream - stream object.; separator - separator

setmaxdigitwidth

public void setmaxdigitwidth(int w)

setolesize

public void setolesize(int firstrow,
                       int firstcolumn,
                       int lastrow,
                       int lastcolumn)

set the size of the visible range of cells when this workbook is displyed as an embedded obect in another document;

parameters:: firstrow - the visible range's first row index; firstcolumn - the visible range's first column index; lastrow - the visible range's last row index; lastcolumn - the visible range's last column index

setwriteprotectionpassword

public void setwriteprotectionpassword(java.lang.string password)

sets write protection password.

parameters:: password - password to set

unprotect

public void unprotect()

unprotects file also upprotect workbook window and structure

unprotect

public void unprotect(java.lang.string bookwindowandstructurepassword)

unprotect file also upprotect workbook window and structure

parameters:: bookwindowandstructurepassword - password for protect workbook window and structure

unprotectworkbook

public void unprotectworkbook(java.lang.string password)

unprotect workbook window and structure

parameters:: password - password

getchartsheetbyname

public chartsheet getchartsheetbyname(java.lang.string name)

getolesize

public ixlsrange getolesize()

get the size of the visible range of cells when this workbook is displyed as an embedded obect in another document;

returns:: if there does not set the size ,return null

getprintusingimagemode

public boolean getprintusingimagemode()

get print by using image mode

setprintusingimagemode

public void setprintusingimagemode(boolean usingimagemode)

set print by using image mode

getdefaultcharset

public java.nio.charset.charset getdefaultcharset()

default charset = utf-8

setdefaultcharset

public void setdefaultcharset(java.nio.charset.charset defaultcharset)

parameters:: defaultcharset - charset

overview

package

class

tree

deprecated

index

help

prev class next class

frames no frames

summary: nested | field | constr | method

detail: field | constr | method

workbook-ag凯发旗舰厅

com.spire.xls class workbook

workbook

getworksheets

getnameranges

getactivesheet

getallow3drangesindatavalidation

setallow3drangesindatavalidation

getactivesheetindex

setactivesheetindex

getaddinfunctions

getcalculationmode

setcalculationmode

getdatasorter

getcodename

setcodename

getcolors

getconvertersetting

setconvertersetting

getdate1904

setdate1904

getdefaultfontname

setdefaultfontname

getdefaultfontsize

setdefaultfontsize

getcustomfontfilepaths

setcustomfontfilepaths

getcustomfontparsedresult

getdisablemacrosstart

setdisablemacrosstart

getfilename

hasmacros

hasmacros

iscellprotection

isrighttoleft

isrighttoleft

issaved

iswindowprotection

getmarkerdesigner

getmaxdigitwidth

getopenpassword

setopenpassword

getoptimizeimport

setoptimizeimport

getpivotcaches

getreadonly

getselectedtab

setselectedtab

getshowtabs

setshowtabs

getstyles

getversion

setversion

getcharts

getchartsheets

getcustomdocumentproperties

getcustomtablestyles

getdocumentproperties

loadfromfile

loadfromfile

loadfromfile

loadfromfile

loadfromfile

loadfromfile

loadfromstream

loadfromstream

loadfromstream

loadfromstream

loadfromstream

loadfromxml

loadfromxml

loadfromhtml

loadfromhtml

loadfrommhtml

loadfrommhtml

savetofile

savetofile

savetofile

retainhiddendatatocsv

retainhiddendatatocsv

com.spire.xls
class workbook