Mirror of forum.nim-lang.org

9645 :: Open XML Spreadsheet (Excel) Library for Nim

• Ward (orginal) [2022-11-24T11:08:01+01:00] view original

  Xl is pure nim library to create, read, and modify open XML spreadsheet (Excel) files.

  https://github.com/khchen/xl

  Features

  • Pure nim, only dependency is zippy (pure nim too).
  • Support .xlsx and .xltx. format.
  • Read and write string, number, date, formula, hyperlink, rich string, and styles of cells, ranges, and collections.
  • Move range, copy range, merge/unmerge range, insert rows, insert columns, delete rows, delete columns.
  • Row height and style, column width and style.
  • All styles are supported (number format, font, fill, border, alignment, and protection).

---

• moigagoo (orginal) [2022-11-24T11:40:56+01:00] view original

  Thank you for the great package! It's packages like this that makes a difference between a mature ecosystem and an immature one.

---

• ducdetronquito (orginal) [2022-11-24T15:04:16+01:00] view original

  Looks like a very useful package with a nice API :)

  Do you think they would be possible performance improvements for read-only use cases ? I have seen many times at work people only willing to read Excel files in order to convert it to CSV.

---

• Ward (orginal) [2022-11-25T01:20:34+01:00] view original

  There is already a readonly iterator. It should be fast enough for most usage. I update the performance part of readme on the github. You can check and test it.

  The drawback is it may skip the empty cells. Check cell.rc carefully during iteration to avoid it. This may be changed in the future.

  Tools that convert xlsx to CSV should be easy to write with this library. I can add some example, but I have no plan to add it as API for this library. Thank for your suggestion.

---

• leeooox (orginal) [2022-11-25T01:44:01+01:00] view original

  Wow, another nice library! Thanks. BTW, wNim helps me a lot.

---

• giaco (orginal) [2022-11-25T04:40:54+01:00] view original

  Thanks! Those kind packages are very important for the Nim community

---

• ducdetronquito (orginal) [2022-11-25T09:13:10+01:00] view original

  Thanks for your answer !

  I do agree, converting to another format should not be your lib responsability.

  Have a nice day :)

---

• bobd (orginal) [2022-11-26T13:24:55+01:00] view original

  @Ward - Is it compatible with the JS backend? Or could it be made compatible? Would be nice to have this running in the browser.

---

• Ward (orginal) [2022-11-27T20:50:35+01:00] view original

  I think the code in Xl has no problem, but zippy may be not compatible with JS backend.

---