ProductPromotion
Logo

Elixir

made by https://0x3d.site

GitHub - leifg/excellent: Excel Parser written in Elixir (currently only Excel 2000)
Excel Parser written in Elixir (currently only Excel 2000) - leifg/excellent
Visit Site

GitHub - leifg/excellent: Excel Parser written in Elixir (currently only Excel 2000)

GitHub - leifg/excellent: Excel Parser written in Elixir (currently only Excel 2000)

Excellent

Build Status Coverage Status hex.pm version

DISCLAIMER: Completely abandoned. No further development will take place. If you're looking for an xlxs parsing library, consider using xlsxir

This is a library for parsing .xlsx files (Open XML format). It is targeted for reading Excel 2000 files into a list of lists.

Sample output:

[
  ["A1", "B1", "C1", "D1"],
  ["A2", "B2", "C2", "D2"],
  ["A3", "B3", "C3", "D3"],
  ["A4", "B4", "C4", "D4"],
  ["A5", "B5", "C5", "D5"],
]

Installation

You can add Excellent as a dependency in your mix.exs file. Since it only requires Elixir and Erlang there are no other dependencies.

def deps do
  [ { :excellent, "~> 0.0.1" } ]
end

If you aren't using hex, add the a reference to the github repo.

def deps do
  [ { :excellent, github: "leifg/excellent" } ]
end

Then run mix deps.get in the shell to fetch and compile the dependencies

Usage

The top level funtion takes 2 arguments: the filename and the number of the worksheet you want to parse (zero based).

Excellent.parse('spreadsheet.xlsx', 0)

=> [
  ["A1", "B1", "C1", "D1"],
  ["A2", "B2", "C2", "D2"],
  ["A3", "B3", "C3", "D3"],
  ["A4", "B4", "C4", "D4"],
  ["A5", "B5", "C5", "D5"],
]

There is also a function to return the names of the worksheets as a tuple:

Excellent.worksheet_names('spreadsheet.xlsx')

=> {"Worksheet 1", "Worksheet 2"}

TODO

  • Read worksheets as stream from ZIP archive
  • Implement different data types (curently only strings and numbers are supported)

Articles
to learn more about the elixir concepts.

Resources
which are currently available to browse on.

mail [email protected] to add your project or resources here 🔥.

FAQ's
to know more about the topic.

mail [email protected] to add your project or resources here 🔥.

Queries
or most google FAQ's about Elixir.

mail [email protected] to add more queries here 🔍.

More Sites
to check out once you're finished browsing here.

0x3d
https://www.0x3d.site/
0x3d is designed for aggregating information.
NodeJS
https://nodejs.0x3d.site/
NodeJS Online Directory
Cross Platform
https://cross-platform.0x3d.site/
Cross Platform Online Directory
Open Source
https://open-source.0x3d.site/
Open Source Online Directory
Analytics
https://analytics.0x3d.site/
Analytics Online Directory
JavaScript
https://javascript.0x3d.site/
JavaScript Online Directory
GoLang
https://golang.0x3d.site/
GoLang Online Directory
Python
https://python.0x3d.site/
Python Online Directory
Swift
https://swift.0x3d.site/
Swift Online Directory
Rust
https://rust.0x3d.site/
Rust Online Directory
Scala
https://scala.0x3d.site/
Scala Online Directory
Ruby
https://ruby.0x3d.site/
Ruby Online Directory
Clojure
https://clojure.0x3d.site/
Clojure Online Directory
Elixir
https://elixir.0x3d.site/
Elixir Online Directory
Elm
https://elm.0x3d.site/
Elm Online Directory
Lua
https://lua.0x3d.site/
Lua Online Directory
C Programming
https://c-programming.0x3d.site/
C Programming Online Directory
C++ Programming
https://cpp-programming.0x3d.site/
C++ Programming Online Directory
R Programming
https://r-programming.0x3d.site/
R Programming Online Directory
Perl
https://perl.0x3d.site/
Perl Online Directory
Java
https://java.0x3d.site/
Java Online Directory
Kotlin
https://kotlin.0x3d.site/
Kotlin Online Directory
PHP
https://php.0x3d.site/
PHP Online Directory
React JS
https://react.0x3d.site/
React JS Online Directory
Angular
https://angular.0x3d.site/
Angular JS Online Directory