UmyaSpreadsheet.BorderFunctions (umya_spreadsheet_ex v0.7.0)
View SourceFunctions for manipulating cell borders in a spreadsheet.
Summary
Functions
Sets the border style for a cell.
Functions
Sets the border style for a cell.
Parameters
spreadsheet
- The spreadsheet structsheet_name
- The name of the sheetcell_address
- The cell address (e.g., "A1", "B5")border_position
- The border position ("top", "right", "bottom", "left", "diagonal", "outline", "all")border_style
- The border style ("thin", "medium", "thick", "dashed", "dotted", "double", "none")
Returns
:ok
on success{:error, reason}
on failure
Examples
{:ok, spreadsheet} = UmyaSpreadsheet.read_file("input.xlsx")
# Set top border to thick
:ok = UmyaSpreadsheet.BorderFunctions.set_border_style(spreadsheet, "Sheet1", "A1", "top", "thick")
# Set all borders to thin
:ok = UmyaSpreadsheet.BorderFunctions.set_border_style(spreadsheet, "Sheet1", "B2", "all", "thin")