Package com.tick42.glue.internal.excel
Class ShowGridOptionsBuilder<T,B extends ShowGridOptionsBuilder<T,B>>
java.lang.Object
com.tick42.glue.internal.excel.TableBuilderBase<T,B>
com.tick42.glue.internal.excel.ShowGridOptionsBuilder<T,B>
- All Implemented Interfaces:
ColumnsBuilder<B>,RowsBuilder<T,B>,SheetOptions.Builder<T,B>,TableBuilder<T,B>
public class ShowGridOptionsBuilder<T,B extends ShowGridOptionsBuilder<T,B>> extends TableBuilderBase<T,B> implements SheetOptions.Builder<T,B>, TableBuilder<T,B>
-
Field Summary
Fields Modifier and Type Field Description static StringDEFAULT_G4O_VERSION -
Method Summary
Modifier and Type Method Description BbuttonRange(String buttonRange)BbuttonText(String buttonText)BclearGrid(boolean flag)BdataRangeName(String dataRangeName)ExcelPad will create an Excel Named Range that defines the extent of the data written to the worksheet.Bg4oVersion(String version)Input custom g4oVersionBinhibitLocalSave(boolean flag)BnamedRange(String namedRange)BtemplateWorkbook(String name)BtemplateWorksheet(String name)BtopLeft(String position)Bwindow(WindowState window)Excel window activation/state optionsBworkbook(String name)Bworksheet(String worksheet)Methods inherited from class com.tick42.glue.internal.excel.TableBuilderBase
column, column, column, row, row, rows, rowsMethods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitMethods inherited from interface com.tick42.glue.office.spreadsheets.ColumnsBuilder
column, columnMethods inherited from interface com.tick42.glue.office.spreadsheets.RowsBuilder
row, row, rows, rows
-
Field Details
-
DEFAULT_G4O_VERSION
- See Also:
- Constant Field Values
-
-
Method Details
-
worksheet
- Specified by:
worksheetin interfaceSheetOptions.Builder<T,B extends ShowGridOptionsBuilder<T,B>>- Parameters:
worksheet- Name of the sheet to receive the data; else uses the first sheet in the workbook.- Returns:
- this builder, never
null
-
workbook
- Specified by:
workbookin interfaceSheetOptions.Builder<T,B extends ShowGridOptionsBuilder<T,B>>- Parameters:
name- Name of the workbook to reuse; otherwise a new temporary workbook will be created.- Returns:
- this builder, never
null
-
templateWorksheet
- Specified by:
templateWorksheetin interfaceSheetOptions.Builder<T,B extends ShowGridOptionsBuilder<T,B>>- Parameters:
name- Name of the worksheet to display; ignored if there is no template.- Returns:
- this builder, never
null
-
templateWorkbook
- Specified by:
templateWorkbookin interfaceSheetOptions.Builder<T,B extends ShowGridOptionsBuilder<T,B>>- Parameters:
name- Name of a template workbook to use when creating new workbooks.- Returns:
- this builder, never
null
-
inhibitLocalSave
- Parameters:
flag- Set to true to prevent the user from saving the temporary workbook.- Returns:
- this builder, never
null
-
clearGrid
- Parameters:
flag- Remove all existing rows before applying the new data; default true.- Returns:
- this builder, never
null
-
buttonRange
- Parameters:
buttonRange- The trigger button is placed over a range of cells; default is A1.- Returns:
- this builder, never
null
-
topLeft
- Parameters:
position- The top-left address of the data in the dataWorksheet; default is A1.- Returns:
- this builder, never
null
-
buttonText
- Parameters:
buttonText- The caption to use for a trigger button.- Returns:
- this builder, never
null
-
namedRange
- Parameters:
namedRange- The top-left address of the data in the dataWorksheet; default is A1.- Returns:
- this builder, never
null
-
dataRangeName
ExcelPad will create an Excel Named Range that defines the extent of the data written to the worksheet.- Parameters:
dataRangeName- the range name- Returns:
- this builder, never
null
-
window
Excel window activation/state options- Parameters:
window- the desired options- Returns:
- this builder, never
null
-
g4oVersion
Input custom g4oVersion- Parameters:
version- the desired version- Returns:
- this builder, never
null
-