Skip to content

Add style to column causes it to be hidden #458

Open
@AJamesPhillips

Description

@AJamesPhillips

Version: 0.8.0

const Excel = require('exceljs')

const workbook = new Excel.stream.xlsx.WorkbookWriter({
    filename: 'demo_hidden_columns_bug.xlsx', useStyles: true
})

const worksheet = workbook.addWorksheet('sheetName')
worksheet.columns = [
    { header: 'Header One' },
    { header: 'Header Two', style: { numFmt: '#,##0' } },
    { header: 'Header Three', style: { numFmt: 'General' }, hidden: false },
    { header: 'Header Four', width: 20 }
]
const dataRow = [ 1, 2, 3, 4 ]
worksheet.addRow(dataRow).commit()
worksheet.commit()

workbook.commit()

console.log('completed')

Columns 1 and 4 will be visible but 2 and 3 will be hidden.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions