gooxml is a library for creation of Office Open XML documents (.docx, .xlsx and .pptx).

Status

• Documents (docx) work well, and there are no known issues.
• Spreadsheets (xlsx) support is new and the API may change.
• PowerPoint (pptx) is unsupported at the moment, the XML types exist and some prototype code is checked in but it will be reworked once docx/xlsx are 'finished'.

Installation

go get baliance.com/gooxml/
go build -i baliance.com/gooxml/...

Document Examples

• Simple Text Formatting Text font colors, sizes, highlighting, etc.
• Auto Generated Table of Contents Creating document headings with an auto generated TOC based off of the headingds
• Floating Image Placing an image somewhere on a page, absolutely positioned with different text wrapping.
• Header & Footer Creating headers and footers including page numbering.
• Multiple Headers & Footers Using different headers and footers depending on document section.
• Inline Tables Adding an table with and without borders.
• Using Existing Word Document as a Template Opening a document as a template to re-use the styles created in the document.
• Filling out Form Fields Opening a document with embedded form fields, filling out the fields and saving the result as a new filled form.

Spreadsheet Examples

• Simple A simple sheet with a few cells
• Named Cells Different ways of referencing rows and cells
• Cell Number/Date/Time Formats Creating cells with various number/date/time formats
• Line Chart/Line Chart 3D Line Charts
• Bar Chart Bar Charts
• Mutiple Charts Multiple charts on a single sheet
• Named Cell Ranges Naming cell ranges
• Merged Cells Merge and unmerge cells
• Conditional Formatting Conditionally formatting cells, styling, gradients, icons, data bar
• Complex Multiple charts, auto filtering and conditional formatting

Raw Types

The OOXML specification is large and creating a friendly API to cover the entire specification is a very time consuming endeavor. This library attempts to provide an easy to use API for common use cases in creating OOXML documents while allowing users to fall back to raw document manipulation should the library's API not cover a specific use case.

The raw XML based types reside in the schema/ directory. These types are accessible from the wrapper types via a X() method that returns the raw type.

For example, the library currently doesn't have an API for setting a document background color. However it's easy to do manually via editing the CT_Background element of the document.

dox := document.New()
doc.X().Background = wordprocessingml.NewCT_Background()
doc.X().Background.ColorAttr = &wordprocessingml.ST_HexColor{}
doc.X().Background.ColorAttr.ST_HexColorRGB = color.RGB(50, 50, 50).AsRGBString()

Contribution guidelines

All contributors are must sign a contributor license agreement before their code will be reviewed and merged.

Licensing

This library is offered under a dual license. It is freely available for use under the terms of AGPLv3. If you would like to use this library for a closed source project, please contact [email protected].

There are no differences in functionality between the open source and commercial versions. You are encouraged to use the open source version to evaluate the library before purchasing a commercial license.

Consulting

Baliance also offers consulting services related to enhancing the gooxml library on a case by case basis. Please contact [email protected] if interested.