Logo Deedle

ExcelFrame Type

Static factory methods for reading Excel files, accessible from C# as ExcelFrame.ReadExcel(path) etc.

Static members

Static member Description

ExcelFrame.ReadExcel(path)

Full Usage: ExcelFrame.ReadExcel(path)

Parameters:
    path : string

Returns: Frame<int, string>

Read the first worksheet of an Excel file (.xls or .xlsx) as a Frame<int, string>. The first row is treated as column headers.

path : string
Returns: Frame<int, string>

ExcelFrame.ReadExcelSheet(path, sheetName)

Full Usage: ExcelFrame.ReadExcelSheet(path, sheetName)

Parameters:
    path : string
    sheetName : string

Returns: Frame<int, string>

Read a specific worksheet by name from an Excel file (.xls or .xlsx). The first row is treated as column headers.

path : string
sheetName : string
Returns: Frame<int, string>

ExcelFrame.ReadExcelSheetByIndex(path, sheetIndex)

Full Usage: ExcelFrame.ReadExcelSheetByIndex(path, sheetIndex)

Parameters:
    path : string
    sheetIndex : int

Returns: Frame<int, string>

Read a specific worksheet by zero-based index from an Excel file (.xls or .xlsx). The first row is treated as column headers.

path : string
sheetIndex : int
Returns: Frame<int, string>

ExcelFrame.SheetNames(path)

Full Usage: ExcelFrame.SheetNames(path)

Parameters:
    path : string

Returns: string list

Return the names of all worksheets in an Excel file.

path : string
Returns: string list

Type something to start searching.