node-mssql
SheetJS js-xlsx
node-mssql | SheetJS js-xlsx | |
---|---|---|
14 | 61 | |
2,209 | 34,479 | |
0.2% | 0.3% | |
8.2 | 2.4 | |
14 days ago | 14 days ago | |
JavaScript | JavaScript | |
MIT License | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
node-mssql
-
Ask HN: Are you using MSSQL at work, is it popular?
Not that often. They're more likely to be c#/java/native places. But there's no barrier really: https://www.npmjs.com/package/mssql
-
Anybody using Node with Microsoft SQL server? What's your experience been like?
https://www.npmjs.com/package/mssql works like a charm. I have a lambda-based API that uses that library and does about 50k lookups per day with a 0% failure rate.
-
How does the backend stack work with NodeJS and SQL?
See this package for mssql example https://www.npmjs.com/package/mssql
-
Understanding Connection Pools with Node MSSQL
I have an internal site that I develop that's a node.js server with express, reading from a SQL database. Currently using the mssql package to interact with the db. At different routes within the app, the route handlers read from the database and work their magic and render html. Super basic, there.
-
Node.js vs Python Flask
Here's a link to a package that allows you to connect Node with MSSQL: https://tediousjs.github.io/node-mssql/
-
Need some guidance - Web browser based apps with MS SQL
What you can do is use Node.js along with the mssql library to build your site. You can either use templates and render pages on the server, or you can build out an API and write your browser client in a framework like React or Angular.
- Installing from NPM on Existing Project
- Imperative Thinking and the Making of Sandwiches
-
Best pure-node migration library that's pure SQL and supports multiple db's?
Microsoft SQL Server https://www.npmjs.com/package/mssql
-
SQL SERVER POOL
I am developing an API using nodeJS and Typescript. I was looking for documentation/tutorials (like mssql - npm (npmjs.com) ) to implement a sql server pool with the sql server I have, but there´s a lot of ways to do it and it doesn´t works for me and does not used pool connection, only directly queries, so I will be so glad with you if you can help me. I've been stuck in this 2 days.
SheetJS js-xlsx
-
how to work with .xlsx files?
ExcelJS and XLSX (SheetJS) are great libraries to work with XLSX files. The former I've found a bit easier to work with but less efficient in general.
-
What kind of Programmer / language should I be looking for?
Sure. I manipulate excel files programatically in the browser all the time. I don't really understand your exact workflow, but I use Javascript with xlsx and React.
- Excel To Json ?
-
React App Won't Read xlsx File
Looking at the xlsx documentation, to parse files in the browser, rather than readFile, you use read, which is designed to parse binary data directly, rather than read from disk. There are a bunch of different formats if you go to the XLSX NPM page and scroll down to "Acquiring and Extracting Data". Importantly, it seems the data must already be serialized, so a Blob won't work, but we can work with that.
-
We compete with GitHub. Bing does not show our website
Last year, Bing and Edge erroneously flagged our website https://sheetjs.com/ as "dangerous": https://i.imgur.com/BvA3zrk.png
At the time, there was no "Safety Report" to indicate why Bing thought it was dangerous. The report page linked to https://www.bing.com/toolbox/bing-site-safety?url=https%3a%2... and it said "That web page doesn't exist"
To fix it, we had to register with "Bing Webmaster Tools" (https://www.bing.com/webmasters/about) and raise a support ticket.
Within a few days, the issue "resolved itself". It's possible that raising a ticket forced some automatic refresh of the indexed data for the domain.
-
Product Comparison App (JS Demo Project)
xlsx.
-
Ask HN: Who is hiring? (February 2023)
SheetJS | https://sheetjs.com/ | Software Developer | Full time, Remote (US) | $165K - $240K
We're a bootstrapped company building open source solutions for spreadsheets and structured data. With over 1.5M unique monthly visitors, companies across the business world turn to us for challenging data processing problems. Over the last 10 years, we have pushed the boundaries of JavaScript and the web.
In this role, you will master new and established technologies while working on high-impact projects used by millions of people across the world. Balancing research and engineering, you will design and implement creative solutions that draw from your academic and professional experience.
https://sheetjs.com/careers/ more details
- Help to draw graph in reactjs from data in excel sheet
-
PDF, Excel, Docx generate on React and Node js
For more, you can visit xlsx documentation Link.
-
Active data pull from excel to html charts
There are libraries like https://github.com/SheetJS/sheetjs to parse excel and https://www.chartjs.org/ for all kinds of charts/graphs. Not really much HTML involved here.. the markup gets generated by the chart library.
What are some alternatives?
TypeORM - ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
ExcelJS - Excel Workbook Manager
Sequelize - Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.
HANDSONTABLE - JavaScript data grid with a spreadsheet look & feel. Works with React, Angular, and Vue. Supported by the Handsontable team âš¡
Objection.js - An SQL-friendly ORM for Node.js
Jspreadsheet CE - Jspreadsheet is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with other spreadsheet software.
Mongoose - MongoDB object modeling designed to work in an asynchronous environment.
Luckysheet - Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.
MikroORM - TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, MS SQL Server, PostgreSQL and SQLite/libSQL databases.
ag-Grid - The best JavaScript Data Table for building Enterprise Applications. Supports React / Angular / Vue / Plain JavaScript.
MySQL - A pure node.js JavaScript Client implementing the MySQL protocol.
React Data Grid - Feature-rich and customizable data grid React component