i have created table using office api, , dont want have style on it. default when table created using office api, see default table style applied, want plain data.
to workaround 1. tried change border color , range fill area using color doesn't have style.
i have 2 questions ask. 1. how remove default style on excel table when created using office.js apis 2. if 1st not possible how give no border range,
i tried using hairline , thin border described in https://github.com/officedev/office-js-docs/blob/master/reference/excel/rangeborder.md
but looks hairline not working, hairline , thin gives same border
excel.run(function (ctx) { var sheetname = "sheet1"; var rangeaddress = "a1:f8"; var range = ctx.workbook.worksheets.getitem(sheetname).getrange(rangeaddress); range.format.borders.getitem('insidehorizontal').weight = "hairline"; range.format.borders.getitem('insidevertical').weight = "hairline"; range.format.borders.getitem('edgebottom').weight = "hairline"; range.format.borders.getitem('edgeleft').weight = "hairline"; range.format.borders.getitem('edgeright').weight = "hairline"; range.format.borders.getitem('edgetop').weight = "hairline"; //range.format.borders.getitem('insidehorizontal').style = "no border"; //range.format.borders.getitem('insidevertical').style = 'no border'; //range.format.borders.getitem('edgebottom').style = 'no border'; //range.format.borders.getitem('edgeleft').style = 'no border'; //range.format.borders.getitem('edgeright').style = 'no border'; //range.format.borders.getitem('edgetop').style = 'no border'; range.format.borders.getitem('insidehorizontal').color = 'gray'; range.format.borders.getitem('insidevertical').color = 'gray'; range.format.borders.getitem('edgebottom').color = 'gray'; range.format.borders.getitem('edgeleft').color = 'gray'; range.format.borders.getitem('edgeright').color = 'gray'; range.format.borders.getitem('edgetop').color = 'gray'; return ctx.sync(); }).catch(function(error) { console.log("error: " + error); if (error instanceof officeextension.error) { console.log("debug info: " + json.stringify(error.debuginfo)); } }); my code similar this.
please guide me on how remove border table
you need set style 'none' rather 'no border'.
range.format.borders.getitem('insidehorizontal').style = "none"; range.format.borders.getitem('insidevertical').style = 'none'; range.format.borders.getitem('edgebottom').style = 'none'; range.format.borders.getitem('edgeleft').style = 'none'; range.format.borders.getitem('edgeright').style = 'none'; range.format.borders.getitem('edgetop').style = 'none'; the possible values documented @ rangeborder object (javascript api excel)
edit: above applies newer excel api. when working classic table bindings, there alternative method. there walkthough of process available @ http://dev.office.com/docs/add-ins/excel/format-tables-in-add-ins-for-excel.
