ExcelReader Xojo Component

Workbook.Open Method

Opens a Excel workbook from a valid FolderItem.

shared Open(
   f as FolderItem) as Workbook

Parameters

f
The Excel document to open.

Returns

Workbook

Remarks


Dim f as FolderItem
Dim ft as FileType = new FileType()
ft.Extensions = "xlsx"
ft.Name = "Excel document"

f = GetOpenFolderItem(ft)

if f <> nil then
    Dim reader as ExcelReader.Workbook = ExcelReader.Workbook.Open(f)
   
    if reader <> nil then
       // Do something here with the content of the document
    end if
end if

See Also

Workbook Class