All Projects → sdllc → Basic Excel R Toolkit

sdllc / Basic Excel R Toolkit

Programming Languages

r
7636 projects
julia
2034 projects

Labels

Projects that are alternatives of or similar to Basic Excel R Toolkit

Pylightxl
A light weight, zero dependency, minimal functionality excel read/writer python library
Stars: ✭ 134 (-19.28%)
Mutual labels:  excel
Xlsx.jl
Excel file reader and writer coded in pure Julia.
Stars: ✭ 145 (-12.65%)
Mutual labels:  excel
Weihanli.npoi
NPOI Extensions, excel/csv importer/exporter for IEnumerable<T>/DataTable, fluentapi(great flexibility)/attribute configuration
Stars: ✭ 157 (-5.42%)
Mutual labels:  excel
X Spreadsheet
A web-based JavaScript(canvas) spreadsheet
Stars: ✭ 12,046 (+7156.63%)
Mutual labels:  excel
Tui.grid
🍞🔡 The Powerful Component to Display and Edit Data. Experience the Ultimate Data Transformer!
Stars: ✭ 1,859 (+1019.88%)
Mutual labels:  excel
Docxtemplater
Generate docx pptx and xlsx (Microsoft Word, Powerpoint, Excel documents) from templates, from Node.js, the Browser and the command line / Demo: https://www.docxtemplater.com/demo
Stars: ✭ 1,990 (+1098.8%)
Mutual labels:  excel
Jxls
Java library for creating Excel reports using Excel templates
Stars: ✭ 128 (-22.89%)
Mutual labels:  excel
Xresloader
跨平台Excel导表工具(Excel=>protobuf/msgpack/lua/javascript/json/xml)
Stars: ✭ 161 (-3.01%)
Mutual labels:  excel
Libxls
Read binary Excel files from C/C++
Stars: ✭ 142 (-14.46%)
Mutual labels:  excel
Yii2 Export
A library to export server/db data in various formats (e.g. excel, html, pdf, csv etc.)
Stars: ✭ 153 (-7.83%)
Mutual labels:  excel
Elasticsearch Dataformat
Excel/CSV/BulkJSON downloads on Elasticsearch.
Stars: ✭ 135 (-18.67%)
Mutual labels:  excel
Sqlite2xl
Library to Convert SQLite to Excel and Vice-Versa
Stars: ✭ 136 (-18.07%)
Mutual labels:  excel
Unpivotr
Unpivot complex and irregular data layouts in R
Stars: ✭ 148 (-10.84%)
Mutual labels:  excel
Npoi
A .NET library for reading and writing Microsoft Office binary and OOXML file formats.
Stars: ✭ 1,751 (+954.82%)
Mutual labels:  excel
Excel Plus
❇️ Improve the productivity of the Excel operation library. https://git.io/vNjQy
Stars: ✭ 160 (-3.61%)
Mutual labels:  excel
Xlsx
Fast and reliable way to work with Microsoft Excel™ [xlsx] files in Golang
Stars: ✭ 132 (-20.48%)
Mutual labels:  excel
Masuit.tools
ldqk.xyz/55
Stars: ✭ 2,539 (+1429.52%)
Mutual labels:  excel
Xlwings
xlwings is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa. It works with Microsoft Excel on Windows and macOS.
Stars: ✭ 2,181 (+1213.86%)
Mutual labels:  excel
Writexl
Portable, light-weight data frame to xlsx exporter for R
Stars: ✭ 162 (-2.41%)
Mutual labels:  excel
Test files
📚 SheetJS Test Files (XLS/XLSX/XLSB and other spreadsheet formats)
Stars: ✭ 150 (-9.64%)
Mutual labels:  excel

The most up-to-date documentation for BERT is on the website (https://bert-toolkit.com):

To install BERT, download the latest release.

Overview

BERT is a connector for Excel and the programming languages R and Julia. Put some R functions in a file; open Excel, and use those functions in your spreadsheets. Essentially anything you can do in R or Julia, you can call from an Excel spreadsheet cell.

There's also a console for talking to Excel from these programming languages, and (if you want) you can run R or Julia code from VBA as well.

Verion 2

The new version of BERT moves R out of process for better stability, code separation, and future feature development (abortable/restartable code service, additional languages). We're also rewriting a lot of stuff just to remove cruft and use more modern C++.

The new version uses a monorepo so we can tie together the various components, instead of having mutliple repos. Once this is the active version we will shut down the separate components.

Roadmap

  • Full replacement for BERTv1

    Most of BERT has been rewritten from scratch for the new version. The result is a more stable and extensible base, with better structure and generally cleaner and more consistent code.

  • Console rewrite

    The console has also been rewritten in typescript, which is a better foundation for what is now a fairly large project.

  • Additional language(s)

    Separation between the interface (Excel) and the language services means we can support more than one language. BERT currently supports R and Julia, and we can add more languages in the future.

Requirements (Runtime)

  • Excel

    BERT supports Excel 2010, 2013 and 2016, both 32-bit and 64-bit (but only on 64-bit Windows).

  • R 3.4.x (optional)

    This version of BERT does not (at the moment) include R, so you will need an R installation. A plain-vanilla Windows R install is fine, as long as it is version 3.4.0 or later.

  • Julia 0.6.2 (optional)

    The same applies to Julia; if you want to integrate Julia, use a plain- vanilla Windows install of Julia. You must use the current release (0.6.2); When Julia releases 0.7, we will update to match.

Requirements (Building)

There are several third party tools and libraries used to build BERT:

  • Protocol Buffers

    BERT uses Protocol Buffers for IPC. This requires the protoc compiler (to compile .proto files) as well as runtime libraries, which must be built by compiling the protobuf library. We're currently using version 3.5.0 and the version 3 syntax.

  • Excel SDK

    The Excel SDK provides XLCALL.cpp and XLCALL.h for Excel integration.

  • R, including headers and .libs

    To build R components, you will need R. A standard R distribution includes headers and DLLs, but you need to build libs for linking. For tips on how to do this, see (e.g.) this mailing list post.

  • Julia

    A plain-vanilla Windows install of Julia is sufficient.

  • Node and Yarn (or npm)

    Building the console requires a recent version of node and yarn (or npm), plus the libraries specified in dependencies and devDependencies.

License

BERT is provided under the GPL (v3). Contact us for alternate licensing options.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].