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

  •        127

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.

https://github.com/bwmarrin/sql2xlsx

Tags
Implementation
License
Platform

   




Related Projects

excelize - Golang library for reading and writing Microsoft Excel™ (XLSX) files.

  •    Go

Excelize is a library written in pure Golang and providing a set of functions that allow you to write to and read from XLSX files. Support reads and writes XLSX file generated by Microsoft Excel™ 2007 and later. Support save file without losing original charts of XLSX. This library needs Go version 1.8 or later. The full API docs can be seen using go's built-in documentation tool, or online at godoc.org.Here is a minimal example usage that will create XLSX file.

docx4j - JAXB-based Java library for Word docx, Powerpoint pptx, and Excel xlsx files

  •    Java

docx4j is a library which helps you to work with the Office OpenXML file format as used in docx documents, pptx presentations, and xlsx spreadsheets.

libxlsxwriter - A C library for creating Excel XLSX files.

  •    C

Libxlsxwriter: A C library for creating Excel XLSX files. Libxlsxwriter is a C library that can be used to write text, numbers, formulas and hyperlinks to multiple worksheets in an Excel 2007+ XLSX file.

readxl - Read excel files (.xls and .xlsx) into R 🖇

  •    C++

The readxl package makes it easy to get data out of Excel and into R. Compared to many of the existing packages (e.g. gdata, xlsx, xlsReadWrite) readxl has no external dependencies, so it’s easy to install and use on all operating systems. It is designed to work with tabular data. readxl supports both the legacy .xls format and the modern xml-based .xlsx format. The libxls C library is used to support .xls, which abstracts away many of the complexities of the underlying binary format. To parse .xlsx, we use the RapidXML C++ library.

better-xlsx - A better xlsx library.

  •    Javascript

This project exists thanks to all the people who contribute. [Contribute]. better-xlsx is available under the terms of the MIT License.


Corrupt XLSX Salvager

  •    

Recover Data for Excel XLSX Files Excel Won't Open

xlsx - Google Go (golang) library for reading and writing XLSX files

  •    Go

xlsx is a library to simplify reading and writing the XML format used by recent version of Microsoft Excel in Go programs.The full API docs can be viewed using go’s built in documentation tool, or online at godoc.org.

spout - Read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way

  •    PHP

Spout is a PHP library to read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way. Contrary to other file readers or writers, it is capable of processing very large files while keeping the memory usage really low (less than 3MB).Full documentation can be found at http://opensource.box.com/spout/.

excel.js - Native node.js Excel file parser. Only supports xlsx for now.

  •    Javascript

Native node.js Excel file parser. Only supports *.xlsx files for now. MIT License.

node-xlsx - NodeJS excel file parser & builder

  •    Javascript

Excel file parser/builder that relies on js-xlsx. This library requires at lease nodeJS v4. For legacy versions, you can use this workaround before using the lib.

xlnt - :bar_chart: Cross-platform user-friendly xlsx library for C++14

  •    C++

xlnt is a modern C++ library for manipulating spreadsheets in memory and reading/writing them from/to XLSX files as described in ECMA 376 4th edition. The first public release of xlnt version 1.0 was on May 10th, 2017. Current work is focused on increasing compatibility, improving performance, and brainstorming future development goals. For a high-level summary of what you can do with this library, see the feature list. Contributions are welcome in the form of pull requests or discussions on the repository's Issues page. Documentation for the current release of xlnt is available here.

openxlsx - R package for .xlsx file reading and writing.

  •    R

This R package simplifies the creation of .xlsx files by providing a high level interface to writing, styling and editing worksheets. Through the use of Rcpp, read/write times are comparable to the xlsx and XLConnect packages with the added benefit of removing the dependency on Java. Please let me know which version of openxlsx you are using when posting bug reports.

TableExport - The simple, easy-to-implement library to export HTML tables to xlsx, xls, csv, and txt files

  •    Javascript

In order to provide Office Open XML SpreadsheetML Format ( .xlsx ) support, you must include the following third-party library in your project before both FileSaver.js and TableExport. To support legacy browsers ( Chrome < 20, Firefox < 13, Opera < 12.10, IE < 10, Safari < 6 ) include the Blob.js polyfill before the FileSaver.js script.

PyExcelerate - Accelerated Excel XLSX Writing Library for Python 2/3

  •    Python

PyExcelerate is a Python for writing Excel-compatible XLSX spreadsheet files, with an emphasis on speed. PyExcelerate is supported on Python 2.6, 2.7, 3.3, 3.4, and 3.5.

spreadsheet_architect - Spreadsheet Architect is a library that allows you to create XLSX, ODS, or CSV spreadsheets super easily from ActiveRecord relations, plain Ruby objects, or tabular data

  •    Ruby

Spreadsheet Architect is a library that allows you to create XLSX, ODS, or CSV spreadsheets super easily from ActiveRecord relations, plain Ruby objects, or tabular data. When NOT using the :data option, ie. on an AR Relation or using the :instances option, Spreadsheet Architect requires an instance method defined on the class to generate the data. It looks for the spreadsheet_columns method on the class. If you are using on an ActiveRecord model and that method is not defined, it would fallback to the models column_names method (not recommended). If using the :data option this is ignored.

rubyXL - Ruby lib for reading/writing/modifying .xlsx and .xlsm files

  •    Ruby

Ruby lib for reading/writing/modifying .xlsx and .xlsm files

Koogra Excel BIFF/XLSX Reader Library

  •    CSharp

.Net implementation of an Excel file reader for reading unencrypted Excel 97 and up BIFF and XLSX based files.

XOOXml library

  •    

A strong-typed library class based on OOXML SDK 2.0, to create Xlsx files

OfficeHelper

  •    DotNet

Wrapper around the open xml office package. You can easily generate xlsx documents based on a template xlsx document and reuse parts from that document, if you mark them as named ranges (i.e."names"). Requirement: .Net 3.5 or later. Microsoft Office does not need to be installed!





We have large collection of open source products. Follow the tags from Tag Cloud >>


Open source products are scattered around the web. Please provide information about the open source projects you own / you use. Add Projects.