22

GitHub - elis/djit: Excel-like Javascript Object

 4 years ago
source link: https://github.com/elis/djit
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.

README.md

Excel-like Javascript Object

Create an Excel-like object in Javascript that automagically computes itself whenever updated.

Basically a programitacally accessible Excel Spreadsheet.

Example:

import { djit } from 'djit'

const qdata = djit([[150, 33], [12.55, 'Yo!']])
/*
  qdata = {
    A1: { input: 150, type: 'integer', value: 150, listeners: [ 'A3' ] },
    B1: { input: 33, type: 'integer', value: 33 },
    A2: { input: 12.55, type: 'float', value: 12.55, listeners: [ 'A3' ] },
    B2: { input: 'Yo!', type: 'string', value: 'Yo!' }
  }
*/
qdata.toArray()
// [ [ 150, 33 ], [ 12.55, 'Yo!' ] ]

qdata.A3 = '=A1 + A2'
qdata.toArray()
// [ [ 150, 33 ], [ 12.55, 'Yo!' ], [ 162.55 ] ]

qdata.B3 = '=A3 / 6'
qdata.toArray()
// [ [ 150, 33 ], [ 12.55, 'Yo!' ], [ 162.55, 27.09166666666667 ] ]

console.log(qdata.B3) // 27.09166666666667

Installation and Usage

Add djit to your project:

$ yarn add djit

Import and initialize:

import { djit } from 'djit'

Create a new sheet object:

const data = [[], []]
const context = { Math }
// Math.* functions are available to be used in cells like so: `data.B1 = '=floor(random() * 100)'`

const onChange = (key, value, Data) => {
  console.log('Djit updated:', key, 'New value:', value)
}
// onChange will fire every time a cell value is updated

const qdata = djit(data, { context, onChange })

Interact with the data:

qdata.A1 = 100
qdata.B1 = 200
qdata.C1 = '=A1 + B1'

Explore data:

console.log('C1 cell:', qdata.C1) // 300

console.log('As array:', qdata.toArray()) // As array: [ [ 100, 200, 300 ] ]

report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK