taktik-simple-spreadsheet-reader
v2.0.2
Published
Simple reader for public google spreadsheet
Downloads
54
Readme
simple-spreadsheet-reader
A simple reader for a Google spreadsheet publish on web.
See documentation at https://hubjac1.github.io/simple-spreadsheet-reader/
Usage
Install the module from npm with npm install --save simple-spreadsheet-reader
import { SpreadsheedReader } from 'simple-spreadsheet-reader'
// Initialize the SpreadsheedReader with the speadsheet Id of URL
const spreadsheedReader = new SpreadsheedReader('spreadsheets-randomID')
// Load spreadsheed data from google.
await spreadsheedReader.loadSpreadsheetData()
// get one cell value
const cellA1 = spreadsheedReader.getCellValue('A1')
console.log('A1') // text
// get list of cells
const cells = spreadsheedReader.cellsList()
console.log(cells)
// Compute Node elements of the table.
// In case of errors the node will contains the error message.
const tableElement = spreadsheedReader.getTable()
document.body.append(tableElement)
Result
<table class="ssr-table">
<thead>
<tr>
<td class="ssr-cell-head"></td>
<td class="ssr-cell-head">A</td>
<td class="ssr-cell-head">B</td>
</tr>
</thead>
<tbody>
<tr>
<td class="ssr-cell-head">1</td>
<td cell-id="A1" id="ssr-A1" class="ssr-cell-data">text</td>
<td cell-id="B1" id="ssr-B1" class="ssr-cell-data">value</td>
</tr>
<tr>
<td class="ssr-cell-head">2</td>
<td cell-id="A2" id="ssr-A2" class="ssr-cell-data"></td>
<td cell-id="B2" id="ssr-B2" class="ssr-cell-data">other</td>
</tr>
</tbody>
</table>
Publishing your Google Sheets to the web
Step 1:
Click File > Publish to the web…
Step 2:
Click Publish, then OK
Step 3:
Don't use the link from here.
But copy the URL or the spreadsheet ID form the sheet URL
Common Error
If you receive the response below, please go back to Section 2: Publishing your Google Sheets to the web.