I am creating an excel template from JSON data using npm package 'excel4node' I am wondering if I can restrict user to enter any value in a particular cell.
For example, this is code for my one cell's representation. How can I config this to restrict any entry?
import * as excel from 'excel4node';
const disabledStyle = {
fill: {
type: 'pattern',
patternType: 'darkGray',
bgColor: '#808080',
fgColor: '#808080',
},
};
const workbook = new excel.Workbook();
const worksheet = workbook.addWorksheet('Performance');
worksheet.cell(1, 1).style(disabledStyle);
workbook.write('template.xlsx');