ashishd751 / React Excel Renderer
Licence: mit
A react library to render and display excel sheets on webpage
Stars: ✭ 108
Programming Languages
javascript
184084 projects - #8 most used programming language
Projects that are alternatives of or similar to React Excel Renderer
Excelcy
Excel Integration with spaCy. Training NER using Excel/XLSX from PDF, DOCX, PPT, PNG or JPG.
Stars: ✭ 89 (-17.59%)
Mutual labels: excel
Vbasync
Cross-platform tool to synchronize macros from an Office VBA-enabled file with a version-controlled folder
Stars: ✭ 98 (-9.26%)
Mutual labels: excel
Dbwebapi
(Migrated from CodePlex) DbWebApi is a .Net library that implement an entirely generic Web API (RESTful) for HTTP clients to call database (Oracle & SQL Server) stored procedures or functions in a managed way out-of-the-box without any configuration or coding.
Stars: ✭ 84 (-22.22%)
Mutual labels: excel
Php xlsxwriter
Lightwight XLSX Excel Spreadsheet Writer in PHP
Stars: ✭ 1,376 (+1174.07%)
Mutual labels: excel
Excelplus
DEPRECATED PROJECT — a cross-browser solution to read/write an Excel file with JavaScript
Stars: ✭ 88 (-18.52%)
Mutual labels: excel
Jupyterlab Spreadsheet
JupyterLab plugin for viewing spreadsheets, such as Excel .xls/.xlsx workbooks and OpenOffice .ods files
Stars: ✭ 95 (-12.04%)
Mutual labels: excel
Evilclippy
A cross-platform assistant for creating malicious MS Office documents. Can hide VBA macros, stomp VBA code (via P-Code) and confuse macro analysis tools. Runs on Linux, OSX and Windows.
Stars: ✭ 1,224 (+1033.33%)
Mutual labels: excel
Psychrolib
📚 Library of psychrometric functions to calculate 🌡️ thermodynamic properties of air for Python, C, C#, Fortran, R, JavaScript and VBA/Excel
Stars: ✭ 83 (-23.15%)
Mutual labels: excel
Filecontextcore
FileContextCore is a "Database"-Provider for Entity Framework Core and adds the ability to store information in files instead of being limited to databases.
Stars: ✭ 91 (-15.74%)
Mutual labels: excel
Axel F
Friendly language for data manipulation inspired by Microsoft Excel ™
Stars: ✭ 79 (-26.85%)
Mutual labels: excel
Java Read Write Excel File Using Apache Poi
How to Read and Write Excel Files in Java using Apache POI
Stars: ✭ 100 (-7.41%)
Mutual labels: excel
Magicodes.ie
Import and export general library, support Dto import and export, template export, fancy export and dynamic export, support Excel, Csv, Word, Pdf and Html.
Stars: ✭ 1,198 (+1009.26%)
Mutual labels: excel
Phpspreadsheet
A pure PHP library for reading and writing spreadsheet files
Stars: ✭ 10,627 (+9739.81%)
Mutual labels: excel
Bookfx
Composing Excel spreadsheets based on a tree of nested components like the HTML DOM.
Stars: ✭ 102 (-5.56%)
Mutual labels: excel
Combine Csv Files In The Folder
Tiny script to automate everyday task
Stars: ✭ 91 (-15.74%)
Mutual labels: excel
react-excel-renderer
A react library to render and display excel sheets on webpage
Demo
Installation
npm install react-excel-renderer --save
Usage
- Import the primary module ExcelRenderer to convert sheet data into JSON format.
- Also import OutTable to display the obtained JSON into a HTML Table.
import {OutTable, ExcelRenderer} from 'react-excel-renderer';
- Place a simple
input
element in the render function of your class and pass anonChange
handler
<input type="file" onChange={this.fileHandler.bind(this)} style={{"padding":"10px"}} />
- In the
onChange
handler, invoke theExcelRenderer
function and provide file object from the event handler to theExcelRenderer
function to obtain JSON data from sheet
fileHandler = (event) => {
let fileObj = event.target.files[0];
//just pass the fileObj as parameter
ExcelRenderer(fileObj, (err, resp) => {
if(err){
console.log(err);
}
else{
this.setState({
cols: resp.cols,
rows: resp.rows
});
}
});
}
- Use the OutTable component to render obtained JSON data into HTML table, and provide classnames as props to make table look alike an Excel Sheet
<OutTable data={this.state.rows} columns={this.state.cols} tableClassName="ExcelTable2007" tableHeaderRowClass="heading" />
- To make this table look more like an excel sheet, follow this article - Quick CSS Tools to make your web page tables to look just like excel
Note: Once the JSON data is obatined, you can also use other options to render them instead of the OutTable component. For example, CanvasDataGrid provides various features to render tabular data.
Built With
- SheetJS - The web page sheet framework used
Authors
Ashish Deshpande - Initial work - Ashish's Github Profile
License
This project is licensed under the MIT License - see the LICENSE.md file for details
Acknowledgments
- Special shout out to the guys at Sheet JS for developing the parent library
- High gratitude towards Bernard Bado to help me publish my first npm package
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].