一个简单的Go程序将SQL行转换成Microsoft Excel XLSX文件

一个简单的Go程序将SQL行转换成Microsoft Excel XLSX文件

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.gitcd sql2xlsxgo 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/csv2xlsxhttps://github.com/tealeg/xlsx2csv

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。