Displaying 1 to 20 from 182 results

tabula - Tabula is a tool for liberating data tables trapped inside PDF files

  •    CSS

Repo Note: The master branch is an in development version of Tabula. This may be substantially different from the latest releases of Tabula.As of August 2015, the master branch (and Tabula 1.1.X+) uses tabula-java instead of tabula-extractor under the hood. Previous versions of Tabula use tabula-extractor.

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.

excellentexport - Javascript export to Excel

  •    Javascript

A quick JavaScript library to create export to Excel/CSV from HTML tables in the browser. No server required. As part of the new version 3.0.0+, there is support for XLSX. The drawback is that the library is 600+ KB.

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.

spreadsheet - The Ruby Spreadsheet by ywesee GmbH

  •    Ruby

The Spreadsheet Library is designed to read and write Spreadsheet Documents. As of version 0.6.0, only Microsoft Excel compatible spreadsheets are supported. Spreadsheet is a combination/complete rewrite of the Spreadsheet::Excel Library by Daniel J. Berger and the ParseExcel Library by Hannes Wyss. Spreadsheet can read, write and modify Spreadsheet Documents. Alfred: a@boxbot.org: I think it should be noted in the README file that the library doesn't recognize cell formats in Excel created documents, which results in Floats returned for any number.

PhpSpreadsheet - A pure PHP library for reading and writing spreadsheet files

  •    PHP

PhpSpreadsheet is a library written in pure PHP and providing a set of classes that allow you to read from and to write to different spreadsheet file formats, like Excel and LibreOffice Calc. Read more about it, including install instructions, in the official documentation. Or check out the API documentation.

Handsontable - JavaScript/HTML5 UI Spreadsheet library for web apps. Available for React, Vue and Angular

  •    Javascript

Handsontable Community Edition (CE) is an open source JavaScript/HTML5 UI Spreadsheet component for web apps. It easily integrates with any data source and comes with a variety of useful features like data binding, validation, sorting or powerful context menu. It is available for Vue, React, Angular and Polymer.

EPPlus - Create advanced Excel spreadsheets using .NET

  •    CSharp

Create advanced Excel spreadsheets using .NET, without the need of interop. All support is currently referred to Stack overflow. A tutorial is available in the wiki and the sample project can be downloaded with each version. The old site at Codeplex also contains material that can be helpful. Bugs and new feature requests can be added to the issues tracker.

xlwings - xlwings is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa

  •    Python

Numpy arrays and Pandas Series/DataFrames are fully supported. xlwings-powered workbooks are easy to distribute and work on Windows and Mac. The Excel add-in is version controlled with xltrail. You can see the diffs on https://cloud.xltrail.com.

ImportExcel - PowerShell module to import/export Excel spreadsheets, without Excel

  •    PowerShell

Install from the PowerShell Gallery. This PowerShell Module allows you to read and write Excel files without installing Microsoft Excel on your system. No need to bother with the cumbersome Excel COM-object. Creating Tables, Pivot Tables, Charts and much more has just become a lot easier.

ClosedXML - The easy way to OpenXML

  •    CSharp

ClosedXML makes it easier for developers to create Excel 2007/2010 files. It provides a nice object oriented way to manipulate the files (similar to VBA) without dealing with the hassles of XML Documents. It can be used by any .NET language like C# and Visual Basic (VB).

LibreOffice - The Document foundation

  •    C

LibreOffice is the free power-packed Open Source personal productivity suite for Windows, Macintosh and Linux. LibreOffice is the perfect choice for home users, businesses, government and other organizations. It's native file format is the ISO standardized ODF (Open Document Format), but LibreOffice can open and save Microsoft Word, PowerPoint and Excel files, as well as many other formats, bringing you the widest-available compatibility with other products.

NPOI - a

  •    CSharp

This project is migrated from Tony Qu's NPOI by DotNETCore team.NPOI is the .NET version of POI Java project at http://poi.apache.org/. POI is an open source project which can help you read/write xls, doc, ppt files. It has a wide application.

Joeffice - Office Written in Java

  •    Java

Joeffice is the first open source office suite written in Java. Its features include Docking system. Visualize several documents in the same window, It can have a lot of documents open at the same time and easily switch from one to another. It works with Microsoft document formats (docx, xslx, pptx). It can get data through web services (RMI, SOAP, REST).

django-rest-pandas - 📊📈 Serves up Pandas dataframes via the Django REST Framework for use in client-side (i

  •    Python

Django REST Pandas (DRP) provides a simple way to generate and serve pandas DataFrames via the Django REST Framework. The resulting API can serve up CSV (and a number of other formats) for consumption by a client-side visualization tool like d3.js. The design philosophy of DRP enforces a strict separation between data and presentation. This keeps the implementation simple, but also has the nice side effect of making it trivial to provide the source data for your visualizations. This capability can often be leveraged by sending users to the same URL that your visualization code uses internally to load the data.

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.

janitor - simple tools for data cleaning in R

  •    R

Data scientists, according to interviews and expert estimates, spend from 50 percent to 80 percent of their time mired in this more mundane labor of collecting and preparing unruly digital data, before it can be explored for useful nuggets. janitor has simple functions for examining and cleaning dirty data. It was built with beginning and intermediate R users in mind and is optimized for user-friendliness. Advanced R users can already do everything covered here, but with janitor they can do it faster and save their thinking for the fun stuff.