Read, manipulate and write spreadsheet data and styles to XLSX and JSON. Reverse engineered from Excel spreadsheet files as a project.
https://github.com/guyonroche/exceljsTags | xlsx json csv excel font border fill number format number-format alignment office spreadsheet workbook defined-names data-validations rich-text in-cell-format outlinelevel views frozen split pagesetup |
Implementation | Javascript |
License | MIT |
Platform | NodeJS |
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.
office-suite document office word excel graphics-editordocx4j is a library which helps you to work with the Office OpenXML file format as used in docx documents, pptx presentations, and xlsx spreadsheets.
document-processing document-conversion text-extraction microsoft-documentsCoreXLSX is a library focused on representing the low-level structure of XML-based XLSX spreadsheet format. It allows you to open a spreadsheet archive and map its XML structure into model types expressed directly in Swift. To run the example project, clone the repo, and run pod install from the Example directory first.
excel excelreader excel-import excelparser xml office ios tvos watchos parserThe 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.
r excel xlsx xls spreadsheetphpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.
database-front-end adminstration tool mysql-admin mysql-management mysql-toolONLYOFFICE Desktop Editors is a free and open source office suite comprises text documents, spreadsheets and presentations allowing to create, view and edit documents of any size and complexity, to easily switch to the online mode for real-time co-editing and collaboration. Features as reviewing, commenting and chat are available as well. Deal with multiple files within one and the same window thanks to the tab-based user interface
onlyoffice office word excel spreadsheet presentation desktop docx xlsx pptx doc xls ppt odt ods odp collaboration node nodejs office-suite document-editorA hierarchical note taking application, featuring rich text and syntax highlighting, storing data in a single xml or sqlite file.
notes note-taking todo-listIn 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.
jquery-plugin excel csv txt xlsx xls export html-table requirejs flask demo localstorage blob tableexport filetype filesaver bootstrap table ecosystem:jqueryPhonelib is a gem allowing you to validate phone number. All validations are based on Google libphonenumber. Currently it can make basic validations and formatting to e164 international number format and national number format with prefix. But it still doesn't include all Google's library functionality. Run the bundle command to install it.
google-libphonenumber phone-validation phone-parse phone-number parsingExcelize is a library written in pure Go providing a set of functions that allow you to write to and read from XLSX / XLSM / XLTM / XLTX files. Supports reading and writing spreadsheet documents generated by Microsoft Excel™ 2007 and later. Supports complex components by high compatibility, and provided streaming API for generating or reading data from a worksheet with huge amounts of data
microsoft golang excel xlsx spreadsheet office openxml ooxml excelize xlsm excel-libraryOpenMRS is a flexible electronic medical record platform that can be customized to the needs of clinical and research organizations. It supports Creation and maintenance of patient data, including demographics and clinical observations. It is based on the principle that information should be stored in a way which makes it easy to summarize and analyze.
medical-records records-management healthcare healthcare-information-system emr ehr hospital patient-recordsSpreadsheet 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.
spreadsheet xlsx ods csv export activerecord railsA JavaScript library for internationalization and localization that leverage the official Unicode CLDR JSON data. The library works both for the browser and as a Node.js module. Each language, and the countries that speak that language, have different expectations when it comes to how numbers (including currency and percentages) and dates should appear. Obviously, each language has different names for the days of the week and the months of the year. But they also have different expectations for the structure of dates, such as what order the day, month and year are in. In number formatting, not only does the character used to delineate number groupings and the decimal portion differ, but the placement of those characters differ as well.
i18n parser formatter l10n intl cldr cldr-data cldr-json utility globalization internationalization multilingualization localization g11n m17n localize format parse translate strings numbers dates times calendars plural plurals pluralize cultures languages locales unicode jsonApache Tika is a toolkit for detecting and extracting metadata and structured text content from various documents using existing parser libraries.
text-extraction document-extraction office-documents open-xml export conversionData Table package with server-side processing and VueJS components. Build fast any complex table based on a JSON template.
datatable datatables vue-datatable vuejs bulma json-template laravel-enso vue-table serverside vuejs-components pagination demoThis repo is an ESRI toolbox and tool(s) that exports ESRI Feature Classes to open data formats, CSV, JSON, SQLite, and GeoJSON. Much of the data in government coffers is contained in spatial databases. A large percentage of government spatial data is created and managed using ESRI software. While the common interchange format, the ESRI Shapefile, is easily exported and imported by many other softwares, this data file format (the Shapefile) is not intrinsically part of the www ecology. Moreover, ESRI software does not provide an export of its generic 'feature class' (shapefile, file geodatabase, and personal geodatabase) to the most common open data file formats, CSV, JSON, and/or GeoJSON. Finally while open source tools easily transform ESRI shapefiles to open data, most government geospatial infrastructures only have ESRI tools. Lacking this basic export feature presented here, means the lion's share of government spatial data users cannot export their data to the most common open data formats.
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.
excel xls spreadsheet ruby-spreadsheet gplv3Similar to FASTA/Q format in field of Bioinformatics, CSV/TSV formats are basic and ubiquitous file formats in both Bioinformatics and data sicence. People usually use spreadsheet softwares like MS Excel to do process table data. However it's all by clicking and typing, which is not automatically and time-consuming to repeat, especially when we want to apply similar operations with different datasets or purposes.
csv tsv cross-platform toolkit bioinformatics command-line tool
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.