securedeveloper/react-data-export

how to add 2 cells at the end of my sheet, one with static text and the other with a summed total?

DeanVanGreunen opened this issue · 0 comments

My reason:

I would like to add 2 cells at the end of the sheet from my dataset, a "total" and a "value"

image

here is my code

<ExcelSheet data={this.state.dataset} name="Resellers">
    <ExcelColumn label="Month" value="month"/>
    <ExcelColumn label="Name (ID)" value="name_and_id"/>
    <ExcelColumn label="Promo Code" value="promocode"/>
    <ExcelColumn label="Money Earned" value={(col)=>{
        return "R" + (col.amount / 100);
    }}/>
</ExcelSheet>  

Lib Version:

latest