Is it possible to directly embed excel ?

[katrinrodkina]

When I'm trying to pass excel file's url into ExcelRenderer I'm getting the follow error: Unhandled Rejection (TypeError): Failed to execute 'readAsBinaryString' on 'FileReader': parameter 1 is not of type 'Blob'

Is it possible to embed it directly somehow?

[katrinrodkina]

I've found a way to get blob and display it.

Can I use canvas-datagrid library to style the rows and columns?

[ashishd751]

Sure. Regards, Ashish Deshpande

…

On Wed, 19 Oct, 2022, 8:28 pm katrinrodkina, ***@***.***> wrote: I've found a way to get blob and display it. Can I use canvas-datagrid library to style the rows and columns? — Reply to this email directly, view it on GitHub <#43 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACAIS6OGHXUPRYB6L5YD6WLWEAEBFANCNFSM6AAAAAARISD4HA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[katrinrodkina]

I got it, I used blob.. Weird thing is that when I use remote link to the file it works but is not working when I try to load local file:

` const ExcelRenderer = (file, callback) => {
return new Promise((resolve, reject) => {
const reader = new FileReader()
const isBinaryString = !!reader.readAsBinaryString
reader.onload = e => {
// parse data
const binaryString = e.target.result
try {
const extractedData = XLSX.read(binaryString, {
type: isBinaryString ? 'binary' : 'array',
})

                const sheetName = extractedData.SheetNames[0]
                const sheet = extractedData.Sheets[sheetName]

                const rows = XLSX.utils.sheet_to_json(sheet, { header: 1 })

                const columns = makeColumns(sheet['!ref'])
                const data = { rows, columns }

                resolve(data)
                return callback(null, data)
            } catch (e) {
                console.log(e)
            }
        }
        if (file && isBinaryString) reader.readAsBinaryString(file) 
        else reader.readAsArrayBuffer(file)
    })
}

const makeColumns = range => {
    const columns = []
    const columnsNum = XLSX.utils.decode_range(range).e.c + 1

    for (let i = 0; i < columnsNum; ++i) {
        columns[i] = { name: XLSX.utils.encode_col(i), key: i }
    }

    return columns
}

useEffect(() => {
    fetch(doc_original_link).then(res =>
        res.blob().then(blob => {
            ExcelRenderer(blob, (err, { rows, columns }) => {
                if (err) {
                    console.log(err)
                } else {
                    setRows(rows)
                    setColumns(columns)
                }
            })
        }),
    )
}, [])`