Excelize

Excelize

 
 

Open Source Go Library for Spreadsheets

Read, Create, Merge & Filter Data in Excel XLSX / XLSM / XLTM Spreadsheet Files via Go API.

 

Excelize  is an Open source pure Go library provides functionality for reading and writing of Microsoft Excel XLSX / XLSM / XLTM spreadsheet files. Developers can read and write spreadsheet documents generated by Microsoft Excel™ 2007 and later inside their own applications. The library is very user-friendly and supports reading of large spreadsheet files.  It has provided streaming API for generating or reading data from a worksheet with huge amounts of data.

The library fully supports several important features related to Excel spreadsheet files manipulation and processing, such as reading and writing Excel files, working with cell ranges, Excel rows management, adding comments, merge cells, copy rows, conditional formatting, insert texts, manage tables in Excel files,  add images, add new sheets and many more.

Getting Started with Excelize

The recommended way to install Excelize is from GitHub, please use the following command for fasters installation.

Install via  GitHub Command

 go get github.com/360EntSecGroup-Skylar/excelize 

Generate Excel XLSX File via Go Library

Excelize enables programmers to generate an Excel XLSX spreadsheet inside their own Go applications. Once you have created the sheet you can also create a new sheet, set the value of a cell, define the number of rows and columns, Set an active sheet of the workbook, and more. You can also assign a name to a sheet and save the file to the path of your choice, set font type and text size for a created sheet. 

Insert Chart to an XLSX File

Excel Charts are visual representations of data from a worksheet that can convey more understanding to the data by summarizing large amounts of data within a small section of your worksheet. Charts allow users to visually display data in different formats such as Bar, Column, Pie, Line, Area or Radar, etc. Excelize library supports chart generation as well as control with just a few lines of code inside your own applications. It allows building charts based on data in a worksheet or generates charts without any data.

Creating PivotTable in Excel File

Excelize provides the capability for creating a pivot table inside an Excel spreadsheet with ease.  Pivot tables are one of the most powerful features of Microsoft Excel. It is a powerful tool to calculate, summarize, and analyze your data in an Excel sheet. You can create a simple pivot table by using the AddPivotTable function. Moreover, you can easily assign or edit data source to a pivot table.

Add Images to XLSX Spreadsheets

The Excelize library provides functionality for adding images to an Excel XLSX spreadsheet with just a couple of lines Go commands. You can also modify images according to your needs. You can insert a picture with scaling as well as with printing support.