Home  Products  Purchase  Downloads  Demos  Forums  Blogs  Ticket  Wiki  API  Corporate

com.aspose.cells
Class Excel

java.lang.Object
  extended by com.aspose.cells.Excel

public class Excel
extends java.lang.Object

Represents an Excel workbook.


Constructor Summary
Excel()
          Constructs a workbook object using default settings.
 
Method Summary
 Worksheet createSheet()
          Deprecated. Replaced by Worksheets.addSheet().
 Worksheet createSheet(java.lang.String sheetName)
          Deprecated. Replaced by Worksheets.addSheet(String).
 Style createStyle()
          Creates a new style.
 Worksheet getActiveSheet()
          Deprecated. Replaced by Worksheets.getActiveSheet().
 int getActiveSheetIndex()
          Deprecated. Replaced by Worksheets.getActiveSheetIndex().
 int getCalculationMode()
          Returns the calculation mode.
 Style getDefaultStyle()
          Gets the default style of the workbook.
 Style getNamedStyle(java.lang.String styleName)
          Gets a style by it's name.
 Style[] getNamedStyles()
          Gets all named styles within the workbook.
 int getNumerOfSheets()
          Deprecated. Replaced by Worksheets.getNumerOfSheets().
 Palette getPalette()
          Gets the palette of the workbook.
 Worksheet getSheet(int index)
          Deprecated. Replaced by Worksheets.getSheet(int).
 Worksheet getSheet(java.lang.String name)
          Deprecated. Replaced by Worksheets.getSheet(String).
 int getSheetIndex(java.lang.String name)
          Deprecated. Replaced by Worksheets.getSheetIndex(String).
 java.lang.String getSheetName(int index)
          Deprecated. Replaced by Worksheets.getSheetName(int).
 Worksheets getWorksheets()
           
 int insertName(java.lang.String text, java.lang.String refersTo)
          Defines a new name.
 boolean isCalculateBeforeSave()
          Whether workbooks are calculated before they're saved to disk (if the Calculation Mode is set to MANUAL).
 boolean isHorizontalScrollBarHidden()
          Checks if the horizontal scroll bar is hidden.
 boolean isSheetTabBarHidden()
          Checks if the sheet tab bar is hidden.
 boolean isVerticalScrollBarHidden()
          Checks if the vertical scroll bar is hidden.
 void moveSheet(int origin, int dest)
          Deprecated. Replaced by Worksheets.moveSheet(int,int).
 void open(java.io.InputStream stream)
          Opens an Excel file from the given stream.
 void open(java.lang.String fileName)
          Opens an Excel file from disk.
 void read(java.io.InputStream stream)
          Deprecated. Replaced by open(stream).
 void read(java.lang.String fileName)
          Deprecated. Replaced by open(fileName).
 void removeSheet(int index)
          Deprecated. Replaced by Worksheets.removeSheet(int).
 boolean removeSheet(java.lang.String sheetName)
          Deprecated. Replaced by Worksheets.removeSheet(String).
 boolean removeSheet(Worksheet sheet)
          Deprecated. Replaced by Worksheets.removeSheet(Worksheet).
 void save(java.io.OutputStream stream)
          Saves the workbook to the given stream.
 void save(java.io.OutputStream stream, int fileFormatType)
          Saves the workbook to the given stream.
 void save(java.lang.String fileName)
          Saves the workbook to a file.
 void save(java.lang.String fileName, int fileFormatType)
          Saves the workbook to a file.
 void setCalculateBeforeSave(boolean calculateBeforeSave)
          Sets whether workbooks are calculated before they're saved to disk.
 void setCalculationMode(int calculationMode)
          Sets the calculation mode.
 void setHorizontalScrollBarHidden(boolean isHidden)
          Sets the horizontal scroll bar to be hidden or not.
 void setSheetTabBarHidden(boolean isHidden)
          Sets the sheet tab bar to be hidden or not.
 void setVerticalScrollBarHidden(boolean isHidden)
          Sets the vertical scroll bar to be hidden or not.
 void swapSheet(int idx1, int idx2)
          Deprecated. Replaced by Worksheets.swapSheet(int,int).
 void write(java.io.OutputStream stream)
          Deprecated. Replaced by save(stream).
 void write(java.io.OutputStream stream, int fileFormatType)
          Deprecated. Replaced by save(stream,fileFormatType).
 void write(java.lang.String fileName)
          Deprecated. Replaced by save(fileName).
 void write(java.lang.String fileName, int fileFormatType)
          Deprecated. Replaced by save(fileName,fileFormatType).
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

Excel

public Excel()
Constructs a workbook object using default settings. The workbook will only have one sheet with the name "Sheet1".

Method Detail

open

public void open(java.io.InputStream stream)
          throws java.io.IOException
Opens an Excel file from the given stream.

Parameters:
stream - the stream to read from.
Throws:
java.io.IOException - if an I/O error occurs.

open

public void open(java.lang.String fileName)
          throws java.io.IOException
Opens an Excel file from disk.

Parameters:
fileName - the system-dependent file name.
Throws:
java.io.IOException - if an error occurs.

save

public void save(java.io.OutputStream stream)
          throws java.io.IOException
Saves the workbook to the given stream.

Parameters:
stream - the stream to write to.
Throws:
java.io.IOException - if an I/O error occurs.

save

public void save(java.io.OutputStream stream,
                 int fileFormatType)
          throws java.io.IOException
Saves the workbook to the given stream.

Parameters:
stream - the stream to write to.
fileFormatType - one of the FileFormatType values whcih specifies the file format.
Throws:
java.io.IOException - if an I/O error occurs.

save

public void save(java.lang.String fileName)
          throws java.io.IOException
Saves the workbook to a file.

Parameters:
fileName - the system-dependent file name.
Throws:
java.io.IOException - if an I/O error occurs.

save

public void save(java.lang.String fileName,
                 int fileFormatType)
          throws java.io.IOException
Saves the workbook to a file.

Parameters:
fileName - the system-dependent file name.
fileFormatType - one of the FileFormatType values whcih specifies the file format.
Throws:
java.io.IOException - if an I/O error occurs.
See Also:
FileFormatType

getWorksheets

public Worksheets getWorksheets()

getDefaultStyle

public Style getDefaultStyle()
Gets the default style of the workbook.

Returns:
the default style of the workbook.

createStyle

public Style createStyle()
Creates a new style.

Returns:
the new style.

getNamedStyle

public Style getNamedStyle(java.lang.String styleName)
Gets a style by it's name.

Parameters:
styleName - name of the style.
Returns:
the style. Returns null if the style name is invalid.

getNamedStyles

public Style[] getNamedStyles()
Gets all named styles within the workbook.

Returns:
an array of named styles.

isHorizontalScrollBarHidden

public boolean isHorizontalScrollBarHidden()
Checks if the horizontal scroll bar is hidden.

Returns:
true if the horizontal scroll bar is hidden.

isVerticalScrollBarHidden

public boolean isVerticalScrollBarHidden()
Checks if the vertical scroll bar is hidden.

Returns:
true if the vertical scroll bar is hidden.

isSheetTabBarHidden

public boolean isSheetTabBarHidden()
Checks if the sheet tab bar is hidden.

Returns:
true if the sheet tab bar is hidden.

setHorizontalScrollBarHidden

public void setHorizontalScrollBarHidden(boolean isHidden)
Sets the horizontal scroll bar to be hidden or not.

Parameters:
isHidden - true for hidden; false otherwise.

setVerticalScrollBarHidden

public void setVerticalScrollBarHidden(boolean isHidden)
Sets the vertical scroll bar to be hidden or not.

Parameters:
isHidden - true for hidden; false otherwise.

setSheetTabBarHidden

public void setSheetTabBarHidden(boolean isHidden)
Sets the sheet tab bar to be hidden or not.

Parameters:
isHidden - true for hidden; false otherwise.

getPalette

public Palette getPalette()
Gets the palette of the workbook. NOTE: Using a color that is not contained in the palette will not take effect. If you want to use a custom color in this workbook, please change the palette first.

Returns:
the palette of the workbook.

isCalculateBeforeSave

public boolean isCalculateBeforeSave()
Whether workbooks are calculated before they're saved to disk (if the Calculation Mode is set to MANUAL). This property is preserved even if you change the Calculation Mode.

Returns:
whether workbooks are calculated before they're saved to disk.

setCalculateBeforeSave

public void setCalculateBeforeSave(boolean calculateBeforeSave)
Sets whether workbooks are calculated before they're saved to disk.

Parameters:
calculateBeforeSave - whether workbooks are calculated before they're saved to disk.

getCalculationMode

public int getCalculationMode()
Returns the calculation mode.

Returns:
the calculation mode.
See Also:
setCalculationMode(int)

setCalculationMode

public void setCalculationMode(int calculationMode)
Sets the calculation mode.

Parameters:
calculationMode - calculation mode.It could be one of the following values:
CalculationMode.AUTOMATIC
CalculationMode.SEMIAUTOMATIC
CalculationMode.MANUAL
Throws:
java.lang.IllegalArgumentException - if calculation mode is invalid.

insertName

public int insertName(java.lang.String text,
                      java.lang.String refersTo)
               throws java.io.UnsupportedEncodingException
Defines a new name.

Parameters:
text - the name text of the user-defined name.
refersTo - the formula that the name is defined to refer to, beginning with an equal sign.
Returns:
Name object index.
Throws:
java.lang.IllegalArgumentException - if refersTo is null or formulas in the refersTo are unspported.
java.io.UnsupportedEncodingException - if text contains unsupported encoding.

read

@Deprecated
public void read(java.io.InputStream stream)
          throws java.io.IOException
Deprecated. Replaced by open(stream).

Reads an Excel file from the given stream.

Parameters:
stream - the stream to read from.
Throws:
java.io.IOException - if an I/O error occurs.

read

@Deprecated
public void read(java.lang.String fileName)
          throws java.io.IOException
Deprecated. Replaced by open(fileName).

Reads an Excel file from disk.

Parameters:
fileName - the system-dependent file name.
Throws:
java.io.IOException - if an error occurs.

write

@Deprecated
public void write(java.io.OutputStream stream)
           throws java.io.IOException
Deprecated. Replaced by save(stream).

Writes out the workbook to the given stream.

Parameters:
stream - the stream to write to.
Throws:
java.io.IOException - if an I/O error occurs.

write

@Deprecated
public void write(java.io.OutputStream stream,
                             int fileFormatType)
           throws java.io.IOException
Deprecated. Replaced by save(stream,fileFormatType).

Writes out the workbook to the given stream.

Parameters:
stream - the stream to write to.
fileFormatType - one of the FileFormatType values whcih specifies the file format.
Throws:
java.io.IOException - if an I/O error occurs.

write

@Deprecated
public void write(java.lang.String fileName)
           throws java.io.IOException
Deprecated. Replaced by save(fileName).

Writes out the workbook to a file.

Parameters:
fileName - the system-dependent file name.
Throws:
java.io.IOException - if an I/O error occurs.

write

@Deprecated
public void write(java.lang.String fileName,
                             int fileFormatType)
           throws java.io.IOException
Deprecated. Replaced by save(fileName,fileFormatType).

Writes out the workbook to a file.

Parameters:
fileName - the system-dependent file name.
fileFormatType - one of the FileFormatType values whcih specifies the file format.
Throws:
java.io.IOException - if an I/O error occurs.
See Also:
FileFormatType

getNumerOfSheets

@Deprecated
public int getNumerOfSheets()
Deprecated. Replaced by Worksheets.getNumerOfSheets().

Gets the number of sheets in the workbook.

Returns:
number of sheets.

getSheet

@Deprecated
public Worksheet getSheet(int index)
Deprecated. Replaced by Worksheets.getSheet(int).

Returns the sheet at the specified index.

Parameters:
index - index of the sheet.
Returns:
the sheet at the specified index.
Throws:
java.lang.IllegalArgumentException - if the index is out of range.

getSheet

@Deprecated
public Worksheet getSheet(java.lang.String name)
Deprecated. Replaced by Worksheets.getSheet(String).

Gets the sheet with the specified name.

Parameters:
name - name of the sheet.
Returns:
the sheet that has the specified name. Returns null if the sheet name is invalid.

getSheetIndex

@Deprecated
public int getSheetIndex(java.lang.String name)
Deprecated. Replaced by Worksheets.getSheetIndex(String).

Gets the sheet's index according to its name.

Parameters:
name - name of the sheet.
Returns:
index of the sheet. Returns -1 if the sheet name is invalid.

getSheetName

@Deprecated
public java.lang.String getSheetName(int index)
Deprecated. Replaced by Worksheets.getSheetName(int).

Returns the name of the sheet at the specified index.

Parameters:
index - index of the sheet.
Returns:
sheet name.
Throws:
java.lang.IllegalArgumentException - if the index is out of range.

createSheet

@Deprecated
public Worksheet createSheet()
Deprecated. Replaced by Worksheets.addSheet().

Creates a new worksheet in this workbook. The sheet name is assigned automatically.

Returns:
the created worksheet.

createSheet

@Deprecated
public Worksheet createSheet(java.lang.String sheetName)
Deprecated. Replaced by Worksheets.addSheet(String).

Creates a new worksheet in this workbook with the specified sheet name.

Parameters:
sheetName - name of the worksheet.
Returns:
the created worksheet.

swapSheet

@Deprecated
public void swapSheet(int idx1,
                                 int idx2)
Deprecated. Replaced by Worksheets.swapSheet(int,int).

Swaps the positions of two sheets.

Parameters:
idx1 - index of the first sheet
idx2 - index of the second sheet
Throws:
java.lang.IllegalArgumentException - if any of the positions is out of range.

moveSheet

@Deprecated
public void moveSheet(int origin,
                                 int dest)
Deprecated. Replaced by Worksheets.moveSheet(int,int).

Moves a worksheet.

Parameters:
origin - the original index of the sheet.
dest - the new index of the sheet.
Throws:
java.lang.IllegalArgumentException - if any of the indexes is out of range.

removeSheet

@Deprecated
public void removeSheet(int index)
Deprecated. Replaced by Worksheets.removeSheet(int).

Removes the sheet at the specified index. Once a sheet is removed, operations on it may cause an ExcelException.

Parameters:
index - index of the sheet.
Throws:
java.lang.IllegalArgumentException - if index is out of range.

removeSheet

@Deprecated
public boolean removeSheet(Worksheet sheet)
Deprecated. Replaced by Worksheets.removeSheet(Worksheet).

Removes the specified worksheet. Once a sheet is removed, operations on it may cause an ExcelException.

Parameters:
sheet - the sheet to remove.
Returns:
true if the sheet exists and is removed successfully.

removeSheet

@Deprecated
public boolean removeSheet(java.lang.String sheetName)
Deprecated. Replaced by Worksheets.removeSheet(String).

Removes the specified sheet from the workbook. Once a sheet is removed, operations on it may cause an ExcelException.

Parameters:
sheetName - name of the sheet to remove
Returns:
true if the sheet exists and is removed successfully.

getActiveSheetIndex

@Deprecated
public int getActiveSheetIndex()
Deprecated. Replaced by Worksheets.getActiveSheetIndex().

Gets the active sheet index.

Returns:
the active sheet index.

getActiveSheet

@Deprecated
public Worksheet getActiveSheet()
Deprecated. Replaced by Worksheets.getActiveSheet().

Gets the active sheet.

Returns:
the active sheet.