So here are a few pointers from my end about your case:
1. Inserting the data into Mendix can be done with the excel import module from the market place https://marketplace.mendix.com/link/component/72 . You can create an import template based on your excel file. What you do need to do is create an domain model with entities that represents this data in a good way.
2. I would do the excel import in the following way: first create 1 or 2 ‘flat’ helper entities. When you import the data you map your excel directly into these entities. After the import action you use a microflow to transfer the data into your ‘real’ usable entities in the app.
3. With regards to the UI, you could go with datagrid 2 and try and create an excel like view. You could also try and find a way that the user does not have to see 1800 columns in one page.
4. With regards to the plots, you could use the chart widgets from the appstore:
Hope this helps!
Bhanu, would there be an opportunity to “flip” the view from 1800 columns and 40 rows to 40 columns and 1800 rows?