Excel SpreadSheet In Angular

Question

Hello All,

 

I am new in Angular and as per our project need we need to integrate excel spreadsheet in Angular 9 Framework. Our Backend is c# dot net. For spreadsheet I research and came to know that there are excel libraries which we used for implementing spreadsheet.

 

I have tried with handsontable and syncfusion but my requirement is not fully meet. Every library having its own prons and cons. 

 

Requirements:

1. Insert Table :I need to drag snapshot over spreadsheet we can drag snapshot data anywhere it depends on user. Depending on snapshot parameter table will be generated.
   For example: Snapshot contain 3 column and 10 rows with this parameter table is inserted on spreadsheet. We need to represent table and not actual data over the spreadsheet.
2. Cell Position display on Screen- I need to display the cell address over the top left corner -Name Box as like excel cell address . Means before we drop element data across to the cell it shows you which cell it is put in before you let go? (eg: E5,H7 likewise)
3. Insert Other HTML elements like Text box,Button, Header, Frames etc on spreadsheet.
4. Graph: How do we insert graphs and charts into a spreadsheet?
5. Column Header: How do we select or deselect column headers on an external checkbox?For example: If I check the external checkbox then column header is displayed and vice versa.
6. How do we move external droppable table data to another cell on a spreadsheet?

Please refer screenshot for more details.

 

I have tried with syncfusion spreadsheet library but it not meeting the 1 requirement. They are not supported insert table feature. 

 

In regards with handsontable cell positioning is not supported means my data is not placed anywhere.

  

Does anyone know how to achive this or any other alternative solution is there? Please help me.

 

Thanks & Regards,

Deepali Dubal