search

protobi / js-xlsx

XLSX / XLSM / XLSB (Excel 2007+ Spreadsheet) / ODS parser and writer
http://oss.sheetjs.com/js-xlsx
Other
814 stars 416 forks source link

Style Gridlines not working #147

Open surya270696 opened 4 years ago

surya270696 commented 4 years ago

I had written {showGridLines : false}, in the options while creating the worksheet in javascript. It did not get implemented in the excel document

RimaCiklum commented 3 years ago

could you please provide workbook creation and writing portion of the code? I tried the following and it works for me. Hope this helps!

var XLSX = require('./xlsx'); var INFILE = 'tmp/file.xlsx'; var OUTFILE = 'tmp/file-styling.xlsx'; var filedata = XLSX.readFile(INFILE); XLSX.writeFile(filedata, OUTFILE, {showGridLines: false});