Question: How to set right to left reading order?

[Mulli]

Just a question, cannot figure out how to set right to left column order in a sheet?

<ExcelFile element={<button>Download Data</button>}>
                <ExcelSheet data={dataSet1} name="לשונית ראשונה" horizontal={"right"} >
                    <ExcelColumn label="שדה 1" value="name"/>
                    <ExcelColumn label="שדה 2" value="amount"/>
                    <ExcelColumn label="שדה 3" value="sex"/>
                    <ExcelColumn label="הרבה מילים"
                                 value={(col) => col.is_married ? "Married" : "Single"}/>
                </ExcelSheet>
                <ExcelSheet data={dataSet2} name="לשונית שניה" readingOrder={{horizontal:"right"}}>
                    <ExcelColumn label="כאן יהיו" value="name"/>
                    <ExcelColumn label="עוד הרבה" value="total"/>
                    <ExcelColumn label="נתונים" value="remaining"/>
                </ExcelSheet>
            </ExcelFile>

[clleker]

Use "Excel Export with Dataset", then in style set

alignment: {wrapText: true, horizontal: 'center', vertical: 'top'}.

For example:

[
columns: [{…}],
data:[
[{
value: 'Text',
style: {
font: { sz: '12' },
alignment: {readingOrder:2 wrapText: true, horizontal: 'center', vertical: 'top' },
border: { bottom: { style: 'thin', color: { rgb: '000000' } }
}
}]
]

   alignment: {readingOrder:2