Excel Style Spreadsheet App With Vue.js
Description:
A JavaScript library to create an online spreadsheet app using Vue.js.
Install & Download:
# Yarn
$ yarn add vuejs-spreadsheet
# NPM
$ npm install vuejs-spreadsheet --save
How to use it:
- Install and import the vuejs-spreadsheet package.
import VueTable from "vuejs-spreadsheet";
- Define your data for the spreadsheet.
/ data.js
export default {
customOptions: {
tbodyIndex: true,
tbodyCheckbox: true,
sortHeader: true,
trad: {
lang: "fr",
en: {
select: {
placeholder: "Search by typing"
}
},
fr: {
select: {
placeholder: "Taper pour chercher"
}
}
},
newData: {
type: "input",
value: "",
active: false,
style: {
color: "#000"
}
},
fuseOptions: {
shouldSort: true,
threshold: 0.2,
location: 0,
distance: 30,
maxPatternLength: 64,
minMatchCharLength: 1,
findAllMatches: false,
tokenize: false,
keys: ["value"]
}
},
loading: false,
disableCells: ["a"],
parentScrollElement: {
attribute: "html",
positionTop: 0
},
selectPosition: {
top: 0,
left: 0
},
disableSortThead: ["a"],
styleWrapVueTable: {
height: "400px",
overflow: "visible",
fontSize: "12px",
comment: {
borderColor: "#696969",
borderSize: "8px",
widthBox: "120px",
heightBox: "80px"
}
},
headers: [
{
headerName: "A",
headerKey: "a",
style: {
width: "200px",
minWidth: "200px",
color: "#000"
}
},
{
headerName: "B",
headerKey: "b",
style: {
width: "200px",
minWidth: "200px",
color: "#000"
}
},
{
headerName: "C",
headerKey: "c",
style: {
width: "200px",
minWidth: "200px",
color: "#000"
}
},
{
headerName: "D",
headerKey: "d",
style: {
width: "200px",
minWidth: "200px",
color: "#000"
}
},
{
headerName: "E",
headerKey: "e",
style: {
width: "200px",
minWidth: "200px",
color: "#000"
}
},
{
headerName: "F",
headerKey: "f",
style: {
width: "200px",
minWidth: "200px",
color: "#000"
}
},
{
headerName: "G",
headerKey: "g",
style: {
width: "200px",
minWidth: "200px",
color: "#000"
}
}
],
products: [
{
a: {
type: "img",
value: "https://via.placeholder.com/350x150",
active: false
},
c: {
type: "input",
value:
"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis nec aliquam magna. Sed consequat amet..",
active: false,
style: {
color: "#000"
}
},
d: {
type: "input",
value: "France",
active: false,
style: {
color: "#000"
}
},
e: {
type: "input",
value: "Boe",
active: false,
style: {
color: "#000"
}
},
f: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#eee"
},
selectOptions: [
{
value: "Harry Potter",
label: "harry potter"
},
{
value: "Hermione Granger",
label: "hermione granger"
},
{
value: "Ron Whisley",
label: "ron whisley"
},
{
value: "Dobby",
label: "dobby"
},
{
value: "Hagrid",
label: "hagrid"
},
{
value: "Professeur Rogue",
label: "professeur rogue"
},
{
value: "Professeur Mcgonagal",
label: "professeur mcgonagal"
},
{
value: "Professeur Dumbledor",
label: "professeur dumbledor"
}
],
value: "professeur dumbledor",
active: false
},
g: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#eee"
},
selectOptions: [
{
value: 1980,
label: 1980
},
{
value: 1981,
label: 1981
},
{
value: 1982,
label: 1982
},
{
value: 1983,
label: 1983,
active: true
},
{
value: 1984,
label: 1984
}
],
value: 1983,
active: false
}
},
{
a: {
type: "img",
value: "https://via.placeholder.com/350x150",
active: false
},
b: {
type: "input",
value: "Jane",
active: false,
style: {
color: "#000"
}
},
d: {
type: "input",
value: "France",
active: false,
style: {
color: "#000"
}
},
e: {
type: "input",
value: "Boe",
active: false,
style: {
color: "#000"
}
},
f: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#eee"
},
selectOptions: [
{
value: "Harry Potter",
label: "harry potter"
},
{
value: "Hermione Granger",
label: "hermione granger"
},
{
value: "Ron Whisley",
label: "ron whisley"
},
{
value: "Dobby",
label: "dobby"
},
{
value: "Hagrid",
label: "hagrid"
},
{
value: "Professeur Rogue",
label: "professeur rogue"
},
{
value: "Professeur Mcgonagal",
label: "professeur mcgonagal"
},
{
value: "Professeur Dumbledor",
label: "professeur dumbledor"
}
],
value: "Harry Potter",
active: false
},
g: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#eee"
},
selectOptions: [
{
value: 1980,
label: 1980
},
{
value: 1981,
label: 1981
},
{
value: 1982,
label: 1982
},
{
value: 1983,
label: 1983,
active: true
},
{
value: 1984,
label: 1984
}
],
value: 1983,
active: false
}
},
{
a: {
type: "img",
value: "https://via.placeholder.com/350x150",
active: false
},
b: {
type: "input",
value: "Jane",
active: false,
style: {
color: "#000"
}
},
c: {
type: "input",
value: "Paris",
active: false,
style: {
color: "#000"
}
},
d: {
type: "input",
value: "France",
active: false,
style: {
color: "#000"
}
},
e: {
type: "input",
value: "Boe",
active: false,
style: {
color: "#000"
}
},
f: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: "Harry Potter",
label: "harry potter"
},
{
value: "Hermione Granger",
label: "hermione granger"
},
{
value: "Ron Whisley",
label: "ron whisley"
},
{
value: "Dobby",
label: "dobby"
},
{
value: "Hagrid",
label: "hagrid"
},
{
value: "Professeur Rogue",
label: "professeur rogue"
},
{
value: "Professeur Mcgonagal",
label: "professeur mcgonagal"
},
{
value: "Professeur Dumbledor",
label: "professeur dumbledor"
}
],
value: "Hermione Granger",
active: false
},
g: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: 1980,
label: 1980
},
{
value: 1981,
label: 1981
},
{
value: 1982,
label: 1982
},
{
value: 1983,
label: 1983,
active: true
},
{
value: 1984,
label: 1984
}
],
value: 1983,
active: false
}
},
{
a: {
type: "img",
value: "https://via.placeholder.com/350x150",
active: false
},
b: {
type: "input",
value: "Jane",
active: false,
style: {
color: "#000"
}
},
c: {
type: "input",
value: "Paris",
active: false,
style: {
color: "#000"
}
},
d: {
type: "input",
value: "France",
active: false,
style: {
color: "#000"
}
},
e: {
type: "input",
value: "Boe",
active: false,
style: {
color: "#000"
}
},
f: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: "Harry Potter",
label: "harry potter"
},
{
value: "Hermione Granger",
label: "hermione granger"
},
{
value: "Ron Whisley",
label: "ron whisley"
},
{
value: "Dobby",
label: "dobby"
},
{
value: "Hagrid",
label: "hagrid"
},
{
value: "Professeur Rogue",
label: "professeur rogue"
},
{
value: "Professeur Mcgonagal",
label: "professeur mcgonagal"
},
{
value: "Professeur Dumbledor",
label: "professeur dumbledor"
}
],
value: "Professeur Rogue",
active: false
},
g: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: 1980,
label: 1980
},
{
value: 1981,
label: 1981
},
{
value: 1982,
label: 1982
},
{
value: 1983,
label: 1983,
active: true
},
{
value: 1984,
label: 1984
}
],
value: 1983,
active: false
}
},
{
a: {
type: "img",
value: "https://via.placeholder.com/350x150",
active: false
},
b: {
type: "input",
value: "Jane",
active: false,
style: {
color: "#000"
}
},
c: {
type: "input",
value: "Paris",
active: false,
style: {
color: "#000"
}
},
d: {
type: "input",
value: "France",
active: false,
style: {
color: "#000"
}
},
e: {
type: "input",
value: "Boe",
active: false,
style: {
color: "#000"
}
},
f: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: "Harry Potter",
label: "harry potter"
},
{
value: "Hermione Granger",
label: "hermione granger"
},
{
value: "Ron Whisley",
label: "ron whisley"
},
{
value: "Dobby",
label: "dobby"
},
{
value: "Hagrid",
label: "hagrid"
},
{
value: "Professeur Rogue",
label: "professeur rogue"
},
{
value: "Professeur Mcgonagal",
label: "professeur mcgonagal"
},
{
value: "Professeur Dumbledor",
label: "professeur dumbledor"
}
],
value: "Dobby",
active: false
},
g: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: 1980,
label: 1980
},
{
value: 1981,
label: 1981
},
{
value: 1982,
label: 1982
},
{
value: 1983,
label: 1983,
active: true
},
{
value: 1984,
label: 1984
}
],
value: 1983,
active: false
}
},
{
a: {
type: "img",
value: "https://via.placeholder.com/350x150",
active: false
},
b: {
type: "input",
value: "Jane",
active: false,
style: {
color: "#000"
}
},
c: {
type: "input",
value: "Paris",
active: false,
style: {
color: "#000"
}
},
d: {
type: "input",
value: "France",
active: false,
style: {
color: "#000"
}
},
e: {
type: "input",
value: "Boe",
active: false,
style: {
color: "#000"
}
},
f: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: "Harry Potter",
label: "harry potter"
},
{
value: "Hermione Granger",
label: "hermione granger"
},
{
value: "Ron Whisley",
label: "ron whisley"
},
{
value: "Dobby",
label: "dobby"
},
{
value: "Hagrid",
label: "hagrid"
},
{
value: "Professeur Rogue",
label: "professeur rogue"
},
{
value: "Professeur Mcgonagal",
label: "professeur mcgonagal"
},
{
value: "Professeur Dumbledor",
label: "professeur dumbledor"
}
],
value: "Professeur Dumbledor",
active: false
},
g: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: 1980,
label: 1980
},
{
value: 1981,
label: 1981
},
{
value: 1982,
label: 1982
},
{
value: 1983,
label: 1983,
active: true
},
{
value: 1984,
label: 1984
}
],
value: 1983,
active: false
}
},
{
a: {
type: "img",
value: "https://via.placeholder.com/350x150",
active: false
},
b: {
type: "input",
value: "Jane",
active: false,
style: {
color: "#000"
}
},
c: {
type: "input",
value: "Paris",
active: false,
style: {
color: "#000"
}
},
d: {
type: "input",
value: "France",
active: false,
style: {
color: "#000"
}
},
e: {
type: "input",
value: "Boe",
active: false,
style: {
color: "#000"
}
},
f: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: 26,
label: 26
},
{
value: 27,
label: 27
},
{
value: 28,
label: 28
},
{
value: 29,
label: 29
},
{
value: 30,
label: 30,
active: true
}
],
value: 30,
active: false
},
g: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: 1980,
label: 1980
},
{
value: 1981,
label: 1981
},
{
value: 1982,
label: 1982
},
{
value: 1983,
label: 1983,
active: true
},
{
value: 1984,
label: 1984
}
],
value: 1983,
active: false
}
},
{
a: {
type: "img",
value: "https://via.placeholder.com/350x150",
active: false
},
b: {
type: "input",
value: "Jane",
active: false,
style: {
color: "#000"
}
},
c: {
type: "input",
value: "Paris",
active: false,
style: {
color: "#000"
}
},
d: {
type: "input",
value: "France",
active: false,
style: {
color: "#000"
}
},
e: {
type: "input",
value: "Boe",
active: false,
style: {
color: "#000"
}
},
f: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: 26,
label: 26
},
{
value: 27,
label: 27
},
{
value: 28,
label: 28
},
{
value: 29,
label: 29
},
{
value: 30,
label: 30,
active: true
}
],
value: 30,
active: false
},
g: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: 1980,
label: 1980
},
{
value: 1981,
label: 1981
},
{
value: 1982,
label: 1982
},
{
value: 1983,
label: 1983,
active: true
},
{
value: 1984,
label: 1984
}
],
value: 1983,
active: false
}
},
{
a: {
type: "img",
value: "https://via.placeholder.com/350x150",
active: false
},
b: {
type: "input",
value: "Jane",
active: false,
style: {
color: "#000"
}
},
c: {
type: "input",
value: "Paris",
active: false,
style: {
color: "#000"
}
},
d: {
type: "input",
value: "France",
active: false,
style: {
color: "#000"
}
},
e: {
type: "input",
value: "Boe",
active: false,
style: {
color: "#000"
}
},
f: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: 26,
label: 26
},
{
value: 27,
label: 27
},
{
value: 28,
label: 28
},
{
value: 29,
label: 29
},
{
value: 30,
label: 30,
active: true
}
],
value: 30,
active: false
},
g: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: 1980,
label: 1980
},
{
value: 1981,
label: 1981
},
{
value: 1982,
label: 1982
},
{
value: 1983,
label: 1983,
active: true
},
{
value: 1984,
label: 1984
}
],
value: 1983,
active: false
}
},
{
a: {
type: "img",
value: "https://via.placeholder.com/350x150",
active: false
},
b: {
type: "input",
value: "Jane",
active: false,
style: {
color: "#000"
}
},
c: {
type: "input",
value: "Paris",
active: false,
style: {
color: "#000"
}
},
d: {
type: "input",
value: "France",
active: false,
style: {
color: "#000"
}
},
e: {
type: "input",
value: "Boe",
active: false,
style: {
color: "#000"
}
},
f: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: 26,
label: 26
},
{
value: 27,
label: 27
},
{
value: 28,
label: 28
},
{
value: 29,
label: 29
},
{
value: 30,
label: 30,
active: true
}
],
value: 30,
active: false
},
g: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: 1980,
label: 1980
},
{
value: 1981,
label: 1981
},
{
value: 1982,
label: 1982
},
{
value: 1983,
label: 1983,
active: true
},
{
value: 1984,
label: 1984
}
],
value: 1983,
active: false
}
},
{
a: {
type: "img",
value: "https://via.placeholder.com/350x150",
active: false
},
b: {
type: "input",
value: "Jane",
active: false,
style: {
color: "#000"
}
},
c: {
type: "input",
value: "Paris",
active: false,
style: {
color: "#000"
}
},
d: {
type: "input",
value: "France",
active: false,
style: {
color: "#000"
}
},
e: {
type: "input",
value: "Boe",
active: false,
style: {
color: "#000"
}
},
f: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: 26,
label: 26
},
{
value: 27,
label: 27
},
{
value: 28,
label: 28
},
{
value: 29,
label: 29
},
{
value: 30,
label: 30,
active: true
}
],
value: 30,
active: false
},
g: {
type: "select",
handleSearch: true,
comment: {
value: "comment",
borderColor: "#000"
},
selectOptions: [
{
value: 1980,
label: 1980
},
{
value: 1981,
label: 1981
},
{
value: 1982,
label: 1982
},
{
value: 1983,
label: 1983,
active: true
},
{
value: 1984,
label: 1984
}
],
value: 1983,
active: false
}
}
],
submenuThead: [
{
type: "button",
value: "change color",
function: "change-color",
disabled: ["a"]
},
{
type: "select",
disabled: ["a"],
subtitle: "Select state:",
selectOptions: [
{
value: "new-york",
label: "new-york"
},
{
value: "france",
label: "france"
}
],
value: "new-york",
buttonOption: {
value: "change city",
function: "change-city",
style: {
display: "block"
}
}
},
{
type: "button",
value: "change value",
function: "change-value",
disabled: ["a", "b"]
}
],
submenuTbody: [
{
type: "button",
value: "change color",
function: "change-color",
disabled: ["img"]
},
{
type: "button",
value: "change value",
function: "change-value",
disabled: ["img", "name"]
}
]
};
- Import the data.
import exempleData from "./data";
- Create a new spreadsheet in your template.
<template>
<div id="app">
<vue-table
:tbody-data="products"
:headers="headers"
:custom-options="customOptions"
:style-wrap-vue-table="styleWrapVueTable"
:disable-cells="disableCells"
:disable-sort-thead="disableSortThead"
:loading="loading"
:parent-scroll-element="parentScrollElement"
:select-position="selectPosition"
:submenu-tbody="submenuTbody"
:submenu-thead="submenuThead"
@tbody-checked-row="checkedData"
@tbody-all-checked-row="checkedAllData"
@tbody-change-data="changeData"
@tbody-submenu-click-change-color="changeColorTbody"
@tbody-submenu-click-change-value="changeValueTbody"
@thead-submenu-click-change-color="changeColorThead"
@thead-submenu-click-change-value="changeValueThead"
@thead-td-sort="sortProduct">
<div slot="header">
Specific Header
</div>
<div slot="loader">
Loader
</div>
</vue-table>
</div>
</template>
- Render the spreadsheet.
export default {
name: 'app',
data() {
return exempleData;
},
components: {
VueTable,
},
mounted() {
this.loading = true;
setTimeout(() => {
this.loading = false;
}, 300);
},
methods: {
checkedAllData(isChecked) {
console.log('checked all data', isChecked)
},
checkedData(row) {
console.log('checked data', row)
},
changeData(row, header) {
console.log(row, header);
},
sortProduct(event, header, colIndex) {
console.log('sort product');
},
// callback
changeColorThead(event, header, colIndex) {
this.headers[colIndex].style.color = '#e40000';
},
changeValueThead(event, header, colIndex) {
this.headers[colIndex].headerName = 'T-shirt';
},
changeColorTbody(event, header, rowIndex, colIndex) {
this.products[rowIndex][header].style = {};
this.products[rowIndex][header].style.color = '#e40000';
},
changeValueTbody(event, header, rowIndex, colIndex) {
this.products[rowIndex][header].value = 'T-shirt';
},
},
};
- All default props.
headers: {
type: Array,
required: true,
},
tbodyData: {
type: Array,
required: true,
},
customOptions: {
type: Object,
required: true,
},
styleWrapVueTable: {
type: Object,
required: true,
},
submenuThead: {
type: Array,
required: true,
},
disableSortThead: {
type: Array,
required: true,
},
loading: {
type: Boolean,
required: true,
},
selectPosition: {
type: Object,
required: true,
},
parentScrollElement: {
type: Object,
required: true,
},
disableCells: {
type: Array,
required: false,
},
submenuTbody: {
type: Array,
required: false,
},
Download Details:
Author: joffreyBerrier
Live Demo: https://codesandbox.io/s/vuejs-spreadsheet-wctsv?fontsize=14
Download Link: https://github.com/joffreyBerrier/vue-spreadsheet/archive/master.zip
Official Website: https://github.com/joffreyBerrier/vue-spreadsheet
#vuejs #javascript #vue-js
75.15 GEEK