How do I set Columnformats in multi-sheet excel workbooks?

Questions
1

I’m building Excel documents using svyUtils / svyUtils$Excel.

When I create workbook from a dataset I can set the column formats using

workbook.setFormatForColumn(2,'dd/MM/yyyy'); workbook.setFormatForColumn(4,'#############');

If I have workbook with multiple sheets, created like this:

var sheet = workbook.createSheet(“Stock”);

how do I format columns?

2

Hi Christian,

var sheet = workbook.createSheet( “Stock”);
var dateStyle = workbook,createCellStyle();
dateStyle.setDataFormat( ‘dd/MM/yyyy’);
sheet.setDefaultColumnStyle( 2, dateStyle);

Richard

3

I did not think of that. Great thanks.

Christian