Hi,
There's a requirement in which user wants to carry out a bulk upload through excel and then parse the data and show it in an editable grid to make changes depending upon the set of validations executed. User wants to update the uploaded data in bulk in an editable grid.
Validations have 2 cases - one of them being a combination of 2 columns through which it will auto populate rest columns of data in the row and another being combination of 5 columns through which it will auto populate rest columns of data in the row. Total columns in the grid will be 25 columns, out of which 8 columns are mandatory and to be filled by user and 2 columns/ 5 columns will be the combination and rest 15 columns/ 12 columns value will auto populate in the row depending upon the combination. In the combination columns that is 2/5 columns should have custom picker in the grid so that user can get the exact value from the table and auto populate the rest columns in the row depending upon the valid combination and submit the data. This scene will occur for a set of rows that will be there in an excel file expected rows can be around 100 or more at a time.
Need some valuable advice on the above scenario so that performance can be taken cared and best case can be achieved for this scenario.
Thanks in advance!
Discussion posts and replies are publicly visible