sql2xlsx

A simple program to convert SQL rows into Microsoft Excel XLSX files.

This example is built to work with MS SQL driver however it can easily be modified to function with any other Go SQL driver.

For help with this program or general Go discussion, please join the Discord Gophers chat server.

Install & Build

This assumes you already have a working Go environment, if not please see this page first.

go get https://github.com/bwmarrin/sql2xlsx.git
cd sql2xlsx
go build

Usage

All options are required.

Usage of ./sql2xlsx:
  -h string
        SQL Server hostname or IP
  -u string
        User ID
  -p string
        Password
  -s string
        SQL Query filename
  -o string
        Output filename

Other handy tools

• https://github.com/tealeg/csv2xlsx
• https://github.com/tealeg/xlsx2csv