Logo Deedle

Frame Module

F# module extensions for writing Excel files. Open Deedle.ExcelWriter and then call these as Frame.writeExcel, Frame.writeExcelSheet, etc.

Functions and values

Function or value Description

writeExcel path frame

Full Usage: writeExcel path frame

Parameters:
    path : string
    frame : Frame<'R, string>

Type parameters: 'R (requires equality)

Write a frame to the first sheet of an Excel (.xlsx) file. Column keys become the header row. Any existing file is overwritten.

path : string
frame : Frame<'R, string>

writeExcelSheet path sheetName frame

Full Usage: writeExcelSheet path sheetName frame

Parameters:
    path : string
    sheetName : string
    frame : Frame<'R, string>

Type parameters: 'R (requires equality)

Write a frame to a named sheet of an Excel (.xlsx) file. Any existing file is overwritten.

path : string
sheetName : string
frame : Frame<'R, string>

writeExcelSheetStream stream sheetName frame

Full Usage: writeExcelSheetStream stream sheetName frame

Parameters:
    stream : Stream
    sheetName : string
    frame : Frame<'R, string>

Type parameters: 'R (requires equality)

Write a frame to a named sheet of an Excel (.xlsx) stream.

stream : Stream
sheetName : string
frame : Frame<'R, string>

writeExcelSheets path sheets

Full Usage: writeExcelSheets path sheets

Parameters:
    path : string
    sheets : (string * Frame<'R, string>) seq

Type parameters: 'R (requires equality)

Write multiple frames to separate sheets of a single Excel (.xlsx) file. Provide a sequence of (sheetName, frame) pairs. Any existing file is overwritten.

path : string
sheets : (string * Frame<'R, string>) seq

writeExcelStream stream frame

Full Usage: writeExcelStream stream frame

Parameters:
Type parameters: 'R (requires equality)

Write a frame to an Excel (.xlsx) stream (first sheet, default name).

stream : Stream
frame : Frame<'R, string>

Type something to start searching.