高级xlsx电子表格格式

Is there some JavaScript or Golang lib that allows to create xlsx files using some custom heavy formatting?

I'm working on an Electron app and want to generate some reports but the most popular library doesn't provide cell formatting, that fork looses the ability to define page properties like margins and page orientation and that Golang lib as I see doesn't provide page properties too.

Can anybody show some good alternatives or show me I'm wrong? (no C-like langs and Python please)

I am myself looking for something similar to format docx documents and I have just started trying out gooxml.

Currently it has following capabilities for Excel:

  • Read/Write/Edit
  • Cell formatting including conditional formatting
  • Cell validation (drop down combobox, rules, etc.)
  • Retrieve cell values as formatted by Excel (e.g. retrieve a date or number as displayed in Excel)
  • Formula Evaluation (100+ functions supported currently, more will be added as required)
  • Embedded Images
  • All chart types

Edit to answer comment: As stated in the documentation, you may have to fall back to raw document manipulation should the library's API not cover a specific use case.

See CT_PageMargins.go and CT_PageSetup.go for margin and orientation...

Well it seems I've learned the lesson - after trying to use "super-hard-to-understand-and-use" jsreport-xlsx module I've remembered about one lib that didn't worked in Electron renderer and tried it to work from Electron main process.

And it works! Sometime it may be a little treaky to make it create doc exactly you want but it's much better than XLSX-style I've used before and have all features I want.

(it's second [and last I believe] time I've forget about Electron renderer is not Node.js, the true Node.js is main process)