How to conditionally hide a Workbook.Column from dispay

[coolbeatz71]

I would like to hide a column using a condition:

{colToExport.created_at && (
          <Workbook.Column
            label='Date Time'
            value={(params: any) =>
              moment(params.created_at).format('MMM Do, YYYY, HH:mm')
            }
          />
        )}

But I am getting an error can't find props of null.

A quick look at the code, I can see such code: column.props.label or column.props.value.

I want whether there is a better way of doing it, or if It is possible to add another prop like hide which will receive a boolean to hide or not the ExcelColumn from export

[dadamssg]

While not the most elegant solution you could put all of your columns in an array and filter out the nulls.

<Workbook.Sheet data={data1} name="Sheet A">
    {[
       <Workbook.Column key='foo' label="Foo" value="foo"/>,
       colToExport.created_at &&  <Workbook.Column key='created_at' label="Date Time" value={() => {}}/>,
       <Workbook.Column key='bar' label="Bar" value="bar"/>
     ].filter(Boolean)}
</Workbook.Sheet>

[coolbeatz71]

While not the most elegant solution you could put all of your columns in an array and filter out the nulls.

<Workbook.Sheet data={data1} name="Sheet A">
    {[
       <Workbook.Column key='foo' label="Foo" value="foo"/>,
       colToExport.created_at &&  <Workbook.Column key='created_at' label="Date Time" value={() => {}}/>,
       <Workbook.Column key='bar' label="Bar" value="bar"/>
     ].filter(Boolean)}
</Workbook.Sheet>

I will give it a try. But I was planning to raise a PR to solve this issue. But I don't know if the repo maintainer is active