Manukam
Elixir library to read and edit Excel files (xlsx)
I want to read an excel file, insert some data, add some data validation functions to the sheet and save the Excel file. I had a look at both [1] and [2]. [1] can read files but can’t edit. [2] can edit but can’t read an existing file. I tried using both to achieve what I want but still [1] can only read the cell values but don’t read the existing formulas. Is there any library that I can use to make this work in Elixir?
Or should I start looking at python to get this done?
Any help will be very appreciated
[1] - Xlsxir — Xlsxir v1.6.4
[2] - GitHub - xou/elixlsx: An Elixir XLSX writer · GitHub
Trending in Questions
Other Trending Topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Supporting innovation across the BEAM ecosystem.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #elixirconf-us
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #performance
- #security
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Bringing learning, work and compliance together since 1987.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Most Liked
paulsullivanjr
It’s been almost 15 years since I’ve messed with this but it may be worth spending some time looking at both of the repos to get a better understanding of how they work? It could lead you to coming up with a simple solution to achieve both of your goals. Just a thought.
Last Post!
user20230119
https://github.com/xavier/xlsx_reader