A writer for XLSX files.
Features:
- Multiple (named) sheets with custom column widths & column heights.
- (Unicode-)strings, Numbers, Dates
- Font formatting (size, bold, italic, underline, strike)
- Horizontal alignment and text wrapping
- Font and cell background color, borders
- Merged cells
Via hex, in mix.exs:
defp deps do
[{:elixlsx, "~> 0.3.0"}]
endVia github:
defp deps do
[{:elixlsx, git: "https://github.com/xou/elixlsx.git"}]
end1-Line tutorial:
(alias Elixlsx.Workbook, alias Elixlsx.Sheet)
iex(1)> Workbook.append_sheet(%Workbook{}, Sheet.with_name("Sheet 1") |> Sheet.set_cell("A1", "Hello", bold: true)) |> Elixlsx.write_to("hello.xlsx")See example.exs for examples how to use the various features.
A quick introduction how number formattings look like can be found here