Hello,
I've written a class that inherits from runbasebatch and I'm using it to fill up excel file. I use two classes - OXMLWorkbook_RU, OXMLWorksheet_RU. Here I open and close Excel document:
protected void printDocument(Common _caller)
{
this.makeDocument();
workbook = excelDocument.workbook();
worksheet = workbook.getWorksheet();
bookmark = '';
this.createTMPTable(_caller);
this.formatTitle(_caller);
this.formatHeader(taskDaysFactTmp_ICL);
this.formatBody(taskDaysFactTmp_ICL,taskDaysFactTmp_ICL_additional, _caller);
excelDocument.closeDocument(true);
comExcelDocument = new ComExcelDocument_RU();
comExcelDocument.open(excelDocument.fileName(), true);
}
BUt excel file opens with width of the columns not according to the contains of the columns. HOw to autofeet columns? I didn't find anything useful in classes OXMLWorkbook_RU, OXMLWorksheet_RU. I found googling that it can be done like that:
sysExcelWorksheet.columns().autoFit();
But I'm not using SysExcelWorksheet class at all. How to do that in my case?
Thanks.
