com.moyosoft.connector.ms.excel
Class Worksheets

java.lang.Object
  |
  +--java.util.AbstractCollection
        |
        +--com.moyosoft.connector.ms.excel.ExcelCollection
              |
              +--com.moyosoft.connector.ms.excel.Worksheets

All Implemented Interfaces:

java.util.Collection

Direct Known Subclasses:

Sheets

public class Worksheets

extends ExcelCollection

Constructor Summary

Worksheets(Dispatch dispatch)

Method Summary

Worksheet	add()
Sheet	add(SheetType sheetType)
Worksheet	addAfter(Sheet afterSheet)
Sheet	addAfter(Sheet afterSheet, SheetType sheetType)
Worksheet	addBefore(Sheet beforeSheet)
Sheet	addBefore(Sheet beforeSheet, SheetType sheetType)
void	copy()
void	copyAfter(Sheet afterSheet)
void	copyBefore(Sheet beforeSheet)
void	delete()
void	fillAcrossSheets(Range range)
void	fillAcrossSheets(Range range, FillWith value)
int	getCount()
HPageBreaks	getHPageBreaks()
Worksheet	getItem(int index)
Worksheet	getItem(java.lang.String name)
VPageBreaks	getVPageBreaks()
boolean	isVisible()
void	move()
void	moveAfter(Sheet after)
void	moveBefore(Sheet before)
void	printOut()
void	printOut(int copies, boolean preview, boolean collate)
void	printOut(int copies, boolean preview, java.lang.String activePrinter, boolean printToFile, boolean collate, java.lang.String printToFilename)
void	printOut(int fromPage, int toPage, int copies)
void	printOut(int fromPage, int toPage, int copies, boolean preview)
void	printOut(int fromPage, int toPage, int copies, boolean preview, java.lang.String activePrinter)
void	printOut(int fromPage, int toPage, int copies, boolean preview, java.lang.String activePrinter, boolean printToFile, boolean collate, java.lang.String printToFilename)
void	printPreview()
void	select()
void	setVisible(boolean visible)

Methods inherited from class com.moyosoft.connector.ms.excel.ExcelCollection

getDispatch, iterator, remove, size

Methods inherited from class java.util.AbstractCollection

add, addAll, clear, contains, containsAll, isEmpty, removeAll, retainAll, toArray, toArray, toString

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.util.Collection

equals, hashCode

Constructor Detail

Worksheets

public Worksheets(Dispatch dispatch)

Method Detail

add

public Worksheet add()

add

public Sheet add(SheetType sheetType)

addBefore

public Worksheet addBefore(Sheet beforeSheet)

addAfter

public Worksheet addAfter(Sheet afterSheet)

addBefore

public Sheet addBefore(Sheet beforeSheet,
                       SheetType sheetType)

addAfter

public Sheet addAfter(Sheet afterSheet,
                      SheetType sheetType)

copy

public void copy()

copyBefore

public void copyBefore(Sheet beforeSheet)

copyAfter

public void copyAfter(Sheet afterSheet)

getCount

public int getCount()

delete

public void delete()

fillAcrossSheets

public void fillAcrossSheets(Range range)

fillAcrossSheets

public void fillAcrossSheets(Range range,
                             FillWith value)

getItem

public Worksheet getItem(int index)

getItem

public Worksheet getItem(java.lang.String name)

move

public void move()

moveBefore

public void moveBefore(Sheet before)

moveAfter

public void moveAfter(Sheet after)

printPreview

public void printPreview()

select

public void select()

getHPageBreaks

public HPageBreaks getHPageBreaks()

getVPageBreaks

public VPageBreaks getVPageBreaks()

isVisible

public boolean isVisible()

setVisible

public void setVisible(boolean visible)

printOut

public void printOut()

printOut

public void printOut(int fromPage,
                     int toPage,
                     int copies)

printOut

public void printOut(int fromPage,
                     int toPage,
                     int copies,
                     boolean preview)

printOut

public void printOut(int fromPage,
                     int toPage,
                     int copies,
                     boolean preview,
                     java.lang.String activePrinter)

printOut

public void printOut(int fromPage,
                     int toPage,
                     int copies,
                     boolean preview,
                     java.lang.String activePrinter,
                     boolean printToFile,
                     boolean collate,
                     java.lang.String printToFilename)

printOut

public void printOut(int copies,
                     boolean preview,
                     boolean collate)

printOut

public void printOut(int copies,
                     boolean preview,
                     java.lang.String activePrinter,
                     boolean printToFile,
                     boolean collate,
                     java.lang.String printToFilename)