title: ag-Grid to mimic Excel with Angular 9 material components
body: <p>I'm building a web app with an Angular 9 front end (Typescript) and Django with SQLite back end. The main purpose of the app is data entry and database management. I'm using material components to build various forms within mat steppers. It's no problem building the forms and sending data to the back end when using the material components as is, but for one of the steps, I would like to implement a grid entry that has all the following:</p>
  
  <ol>
  <li>Copy/paste feature directly from Excel</li>
  <li>Calculated fields in each row based on the pasted data</li>
  <li>Drop down fields where the options are pulled from the current data</li>
  </ol>
  
  <p>For example, I'd like the ability to have a grid where, for each row, some columns are populated by choosing an option from a drop down, some are populated by pasting in directly from excel, and some are populated as calculations using the pasted data + other columns. All this data should then be pushed to the back end and stored in the database upon a button click.</p>
  
  <p>All of this would be one step within a larger form.</p>
  
  <p>Is all of this actually possible with the ag-grid community version? Additionally, are there any other packages that would help pull this off? It doesn't look too likely based on my research, but I'm still new to Angular, ag-grid etc.</p>
  
  <p>Please let me know if I can clarify anything as I understand my requirements might be a bit confusing.</p>