高级xlsx电子表格格式

Question

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)

Answer 1

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...