ExcelExporter REALbasic Classes

ExcelExporterSheet Class

A class that represents a Excel Worksheet.

Object
   ExcelExporterSheet

class ExcelExporterSheet

Constructors

ExcelExporterSheetThe default constructor.
ExcelExporterSheetA constructor that takes a name for the Worksheet as parameter.

Properties

FitToPage
FooterCenterSets center footer text.
FooterLeftSets left footer text.
FooterRightSets right footer text.
HeaderCenterSets center header text.
HeaderLeftSets left header text.
HeaderRightSets right header text.
Name
PageLayoutView
PageSetupLandscape
PrintFitHeight
PrintFitWidth
PrintScale
SelectedColumn
SelectedRow

Methods

AppendRowAppends a row to the worksheet.
ColsReturns the number of columns in the worksheet.
ColumnReturns a column at a given index.
DateMacroReturns a DateMacro to be used in headers and footers
FileNameMacroReturns a FileNameMacro to be used in headers and footers
GenerateXmlUndocumented and only for Internal use.
PageCountMacroReturns a PageCountMacro to be used in headers and footers
PageNumberMacroReturns a PageNumberMacro to be used in headers and footers
RowReturns a row at a given index.
RowsReturns the number of rows in the worksheet.
SetColumnsToRepeatAtLeftSets column repeat in Page Setup - Sheet
SetRowsToRepeatAtTopSets row repeat in Page Setup - Sheet
SheetNameMacroReturns a SheetNameMacro to be used in headers and footers
TimeMacroReturns a TimeMacro to be used in headers and footers

Supported Platforms:

  • PPC - MacOS 9
  • Carbon - MacOS 9 and MacOS X (PEF)
  • MacOS X PPC - (Mach-O)
  • MacOS X Universal Binary (Mach-O)
  • Win32 - Windows
  • Linux x86