XLSheetMBS.AutoFilter as XLAutoFilterMBS

Creates it if it doesn't exist.
Only for xml based files.
(Read only property)

Some examples using this property:

• /XL/AutoFilter by Top10
• /XL/AutoFilter by Values
• /XL/AutoFilter Custom Filter
• /XL/AutoFilter Number Filter
• /XL/AutoFilter Sort

XLSheetMBS.Book as XLBookMBS

As a sheet is only valid with the owning book, we keep a back reference here.
(Read only property)

XLSheetMBS.DefaultRowHeight as Double

(Read and Write property)

XLSheetMBS.DisplayGridlines as boolean

True if gridlines are displayed and false if aren't.
(Assigning a value to this property calls setDisplayGridlines internally)
(Read and Write property)

Some examples using this property:

• /XL/Writing data

XLSheetMBS.FirstCol as Integer

(Read only property)

Some examples using this property:

• /XL/Extract

XLSheetMBS.FirstFilledCol as Integer

(Read only property)

XLSheetMBS.FirstFilledRow as Integer

(Read only property)

XLSheetMBS.FirstRow as Integer

(Read only property)

Some examples using this property:

• /XL/Extract

XLSheetMBS.Footer as string

The footer text appears at the bottom of every page when printed. The length of the text must be less than or equal to 255. The footer text can contain special commands, for example a placeholder for the page number, current date or text formatting attributes. Margin is specified in inches.

Code	Description
&L	specifies the beginning of the left section
&P	specifies the current page number
&N	specifies the total number of pages
&\d{1,3}	specifies the text font size, where font size is measured in points, for example: &9 or &36
&S	specifies whether the strikethrough text style is on or off
&X	specifies whether the superscript text style is on or off
&Y	specifies whether the subscript text style is on or off
&C	specifies the beginning of the center section
&D	specifies a date
&T	specifies a time
&G	specifies a picture
&U	specifies whether the single underline text style is on or off
&E	specifies whether the double underline text style is on or off
&R	specifies the beginning of the right section
&Z	specifies a workbook file path
&F	specifies a workbook file name
&A	specifies a sheet name
&"fontname"	specifies the text font, for example: &"Comic Sans MS"
&B	specifies whether the bold text style is on or off
&I	specifies whether the italic text style is on or off
&&	specifies an ampersand character (&)

(Read only property)

XLSheetMBS.FooterMargin as Double

(Read only property)

XLSheetMBS.FormControlCount as Integer

(Read only property)

XLSheetMBS.GetHorPageBreakCount as Integer

// new document
dim x as new XLBookMBS

// add a sheet
dim s as XLSheetMBS = x.AddSheet

// write a cell
call s.WriteString(5,5, "Hello")

// now put a page break there
if s.SetHorPageBreak(5, true) then
  // and now we have one at row 5
  MsgBox str(s.GetHorPageBreakCount)+" "+str(s.GetHorPageBreak(0))
end if

(Read only property)

XLSheetMBS.GetVerPageBreakCount as Integer

(Read only property)

XLSheetMBS.GroupSummaryBelow as boolean

True if summary is below and false if isn't.
(Read and Write property)

XLSheetMBS.GroupSummaryRight as boolean

Returns true if summary is right and false if isn't.
(Read and Write property)

XLSheetMBS.Handle as Integer

(Read and Write property)

XLSheetMBS.HCenter as boolean

(Read and Write property)

XLSheetMBS.Header as string

The text appears at the top of every page when printed. The length of the text must be less than or equal to 255. The header text can contain special commands, for example a placeholder for the page number, current date or text formatting attributes. Special commands are represented by single letter with a leading ampersand ("&"). Margin is specified in inches.

Code	Description
&L	specifies the beginning of the left section
&P	specifies the current page number
&N	specifies the total number of pages
&\d{1,3}	specifies the text font size, where font size is measured in points, for example: &9 or &36
&S	specifies whether the strikethrough text style is on or off
&X	specifies whether the superscript text style is on or off
&Y	specifies whether the subscript text style is on or off
&C	specifies the beginning of the center section
&D	specifies a date
&T	specifies a time
&G	specifies a picture
&U	specifies whether the single underline text style is on or off
&E	specifies whether the double underline text style is on or off
&R	specifies the beginning of the right section
&Z	specifies a workbook file path
&F	specifies a workbook file name
&A	specifies a sheet name
&"fontname"	specifies the text font, for example: &"Comic Sans MS"
&B	specifies whether the bold text style is on or off
&I	specifies whether the italic text style is on or off
&&	specifies an ampersand character (&)

(Read only property)

XLSheetMBS.HeaderMargin as Double

(Read only property)

XLSheetMBS.Hidden as Integer

See constants: SheetStateHidden, SheetStateVeryHidden, SheetStateVisible.
(Read and Write property)

XLSheetMBS.HyperlinkSize as Integer

(Read only property)

Some examples using this property:

• /XL/List Hyperlinks

XLSheetMBS.Landscape as boolean

true - pages are printed using landscape mode, false - pages are printed using portrait mode.
(Read and Write property)

XLSheetMBS.LastCol as Integer

dim book as XLBookMBS // your book instance

// get first sheet
dim sheet as XLSheetMBS = book.Sheet(0)

// show index of last column
dim LastCol as Integer = sheet.LastCol

MsgBox "LastCol: " + str(LastCol)

(Read only property)

Some examples using this property:

• /XL/Extract

XLSheetMBS.LastFilledCol as Integer

(Read only property)

XLSheetMBS.LastFilledRow as Integer

(Read only property)

XLSheetMBS.LastRow as Integer

dim book as XLBookMBS // your book instance

// get first sheet
dim sheet as XLSheetMBS = book.Sheet(0)

// show index of last row
dim LastRow as Integer = sheet.LastRow

MsgBox "LastRow: " + str(LastRow)

(Read only property)

Some examples using this property:

• /XL/Extract

XLSheetMBS.MarginBottom as Double

(Read and Write property)

XLSheetMBS.MarginLeft as Double

(Read and Write property)

XLSheetMBS.MarginRight as Double

(Read and Write property)

XLSheetMBS.MarginTop as Double

(Read and Write property)

XLSheetMBS.MergeSize as Integer

(Read only property)

XLSheetMBS.Name as string

(Read and Write property)

XLSheetMBS.NamedRangeCount as Integer

(Read only property)

XLSheetMBS.Paper as Integer

See Paper* constants.
(Read and Write property)

XLSheetMBS.PictureCount as Integer

(Read only property)

XLSheetMBS.PrintGridlines as boolean

True if gridlines are printed and false if aren't.
(Read and Write property)

XLSheetMBS.PrintRowCol as boolean

(Read and Write property)

XLSheetMBS.PrintZoom as Integer

(Read and Write property)

XLSheetMBS.Protect as boolean

(Read and Write property)

XLSheetMBS.RightToLeft as boolean

true - the text is displayed in right-to-left mode,
false - the text is displayed in left-to-right mode.
(Read and Write property)

XLSheetMBS.TabColor as Integer

For use with documents using indexed colors.
(Read and Write property)

XLSheetMBS.TableSize as Integer

(Read only property)

XLSheetMBS.VCenter as boolean

(Read and Write property)

XLSheetMBS.Zoom as Integer

100 is a usual view.
(Read and Write property)