How take column width to my file

[pacograndez]

Hi Luwojtaszek,

I have a query, I'm trying to give width to my column with the following code, but it does not work for me. Thanks for the reply.

const worksheet: XLSX.WorkSheet = XLSX.utils.json_to_sheet(json);
this.colSubDiario(worksheet.A1);
private colSubDiario(col: XLSX.ColInfo) {
col.width = 100;
}

[shlomiah]

I don't know how to set a column width but you can change the base column width to all columns like that:

const worksheet: XLSX.WorkSheet = XLSX.utils.json_to_sheet(json);
const workbook: XLSX.WorkBook = { Sheets: { 'data': worksheet }, SheetNames: ['data'] };
const opts: any = { sheetFormat: { baseColWidth: '20' } };
XLSX.writeFile(workbook, ExcelService.toExportFileName(excelFileName), opts);