Skip to content
An Elixir XLSX writer
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
config Initial commit, generates valid xlsx file Nov 17, 2015
lib Merge pull request #80 from ryanhart2/split_into_content_style Feb 28, 2019
test
.gitignore removed duplicated line from .gitignore; added mix.lock Nov 24, 2016
.travis.yml
CHANGES.md Bump version to 0.4.1 Jan 8, 2019
LICENSE Added LICENSE Nov 24, 2015
README.md Bump version to 0.4.1 Jan 8, 2019
example.exs
mix.exs
mix.lock

README.md

Elixlsx

Hex Version Build Status

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

Installation

Elixir 1.3 and above

Via hex, in mix.exs:

defp deps do
  [{:elixlsx, "~> 0.4.1"}]
end

Via github:

defp deps do
  [{:elixlsx, github: "xou/elixlsx"}]
end

Elixir pre 1.3

defp deps do
  [{:elixlsx, "~> 0.3.1"}]
end

Via github:

defp deps do
  [{:elixlsx, github: "xou/elixlsx", tag: "v0.3.1"}]
end

Usage

1-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.

Number and date formatting reference

A quick introduction how number formattings look like can be found here

You can’t perform that action at this time.