Hi All ,
When I try the example as given on your page https://ko.infragistics.com/products/ignite-ui-react/react/components/spreadsheet-overview
with an excel with charts. the output ui is not able to render the chart but I just see chart data.
My particular requirement is to create a read only excel viewer on my react web page that should render excel files as is (i.e. along with charts graphs images and all) .
Please let me know if this is possible via Ignite UI libraries.
Thanks
Kaveri M.
Hi ,
Thanks for this Information.
We tried to implement the same but when we try to open large spreadsheets ~5mb in size the app fails to render the same on UI . Pls check following code in Exceluitlity
Workbook.load(data, new WorkbookLoadOptions(), (w) => {
resolve(w);
}, (e) => {
reject(e);
});
We are getting this error :
Index was out of range. It must be non-negative and less than the size of the collection.
Hello and thank you for contacting Infragistics. Our Excel API lets you add charts to the Spreadsheet using our chart adapter module. It can also import/export charts to and from the spreadsheet and Excel.
eg. Export a standalone chart to Excel
https://ko.infragistics.com/reactsite/components/excel-library-working-with-charts
eg. Load a chart in the Spreadsheet
https://ko.infragistics.com/reactsite/components/spreadsheet-chart-adapter
You may use the CodeSandbox buttons to see the code. If you want to debug the applications I would use the down arrow in the editor in the left pane to download the projects locally and run them that way then rely on the editor.
Let me know if you have any questions.