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