- I am working on multiple sheets . I want to style them like background color , border. How it can be done. As my all sheets are dynamic , values to spreadsheet are coming from database. here I am sharing my code for json array which I am passing to webix UI.
2.Also, How to disable or change only 2 columns of the sheet to readonly. I don’t want user to enter anything to these 2 columns. Following is my json array.
var data= {
sheets: [
{
name: “Tab_1”,
content:{
data:[
[1,1,"ID","disable:true"],
[1,2,"Value 1"],
[1,3,"Value 2"],
[1,4,"Result"],
<?php
$r=2;
foreach($arr as $record){
echo "[".$r.",1,". $record['ID']."],";
echo "[".$r.",2,". $record['value1']."],";
echo "[".$r.",3,". $record['value2']."],";
echo '['.$r.',4,'. $record['result'].'],';
$r++;
} ?>]
}
},
{
name: "Tab_2",
content:{
data:[
[1,1,"7"],
[1,2,"8"],
[1,3,"=a1+b1"]
]
}
},
{
name: "Tab_3",
content:{
data:[
[1,1,"20"]
]
}
}
]
};