Table Cell Color Border

Hello Roy,

Please copy and paste this simple code in a new script. Try it.

main();

function main(){

    var wb = Context.createExcelWorkbook("ArisStructureExtraction.xls");

    var sheet = wb.createSheet("info");

    var stdStyle = sheet.cell(1, 1).getCellStyle();

    var cellStyle = wb.createCellStyle(wb.getFontAt(stdStyle.getFontIndex()), 5, 5, 5, 5, Constants.C_GREEN, Constants.C_GREEN, Constants.C_GREEN, Constants.C_GREEN, 1, 1, Constants.C_TRANSPARENT, Constants.C_TRANSPARENT, 0);

    sheet.cell(2, 2).setCellStyle(cellStyle);

    wb.write();

};

I hope it will help you.

Best Regards

Romain Tricarico

http://www.bpmap.fr