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