Gridlines 0.4.2+

Facade API	Has Paid Plan	Univer Server	Univer on Node.js	Preset
✅	-	-	-	UniverSheetsCorePreset

From version 0.4.2, you can toggle the visibility of a Worksheet’s gridlines.

Facade API

Show or line gridlines of a worksheet


const fWorkSheet = univerAPI.getActiveWorkbook().getActiveSheet();
 
// hide
fWorkSheet.setHiddenGridlines(true); 
 
// show
fWorkSheet.setHiddenGridlines(false);

Get if the sheet’s gridlines or hidden


const fWorkSheet = univerAPI.getActiveWorkbook().getActiveSheet();
 
// check if the gridlines are hidden
if (fWorkSheet.hasHiddenGridLines()) {
  console.log('Gridlines are hidden');
}

Set the gridlines color


const fWorkSheet = univerAPI.getActiveWorkbook().getActiveSheet();
 
// set the gridlines color to red
fWorkSheet.setGridLinesColor('#ff0000');
console.log(fWorkSheet.getGridLinesColor()); // #ff0000