// create new xls file
dim book as new XLBookMBS(false)

// create sheet
dim sheet as XLSheetMBS = book.AddSheet("Sheet1")

MsgBox sheet.RowColToAddr(5,5) // shows F6
MsgBox sheet.RowColToAddr(5,5,false,false) // shows $F$6

// 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

// create new xls file
Dim book As New XLBookMBS(True)

// create sheet
dim sheet as XLSheetMBS = book.AddSheet("Sheet1")

// create a format with border
Dim borderFormat As XLFormatMBS = book.AddFormat
borderFormat.SetBorder 2
borderFormat.SetBorderColor &hFF0000

// now fill a cell and merge a few more cells.
Dim r1 As Boolean = sheet.WriteString(2, 2, "Hello World", borderFormat)
Dim r2 As Boolean = sheet.SetMerge(2, 4, 2, 4)

// write file
Dim file As FolderItem = SpecialFolder.Desktop.Child("Generate.xlsx")

if book.Save(file) then
  file.Launch
else
  MsgBox "Failed to create file."+EndOfLine+EndOfLine+book.ErrorMessage
end if

// create new xls file
dim book as new XLBookMBS(false)

// create sheet
dim sheet as XLSheetMBS = book.AddSheet("Sheet1")

// set top left view
sheet.SetTopLeftView(2,3)

// read values
dim col, row as Integer
sheet.GetTopLeftView(row, col)

MsgBox str(Row)+", "+str(col) // shows 2, 3

Dim Sheet as XLSheetMBS // your current sheet
Dim format as XLFormatMBS // optional format

Dim Success as Boolean = Sheet.WriteBoolean(2, 5, true, format)