I have put download which can download the sheet data with chart here https://codesandbox.io/s/excel-with-chart-export-ksj68j?file=/src/index.tsxIf I download the sheet and want my chart back while uploading here https://www.infragistics.com/products/ignite-ui-react/react/components/spreadsheet-overview#react-spreadsheet-example
I can't see my charts. Only data is visible.I think without any extra code the chart should get display while to upload it back to the component.
Hello,
Thank you for contacting Infragistics. I modified your sandbox demo to include an upload button. The downloaded worksheet uploads fine with the charts rendering in the spreadsheet.
https://codesandbox.io/s/excel-with-chart-export-forked-y995q3
Let me know if you have any questions.
Thanks for your response on this. But I can see that you have added code to render chart. I need to upload any xls file which may have any chart so how that fill will get load into your component. Basically its dynamic data file with any chart?
It looks like you are adding sourceSheet that already exists in the workbook, which is why New_Sheet is okay. I recommend if you attach a modified sample if you continue to have issues.
Here I am trying to append same fetched sheet to another sheet but code shared by you is not working for me. Please help here codesandbox.io/.../excel-with-chart-export-forked-kjjfm7
After further investigating this joining worksheets into one workbooks is not possible. The worksheets add method expects a string only which is for new worksheets only.
Eg.
https://www.infragistics.com/community/forums/f/ultimate-ui-for-wpf/96033/combining-two-workbooks
I suggest submitting a feature request using the link below so this gets applied to all of our platforms
https://github.com/IgniteUI/igniteui-angular/issues
I see this URL is for Angular: https://github.com/IgniteUI/igniteui-angular/issues and I am trying to do it with React. Could you please help me with link for React? I am wondering as we are just trying to put new sheet2 with content of sheet1. Is very basic stuff. I think it should be there?
Here is the react page for submitting feature requests.
https://github.com/IgniteUI/igniteui-react-examples/issues