✅ data from excel to wpf app
I want to make an application to display the data I need in graphs, etc.
The only problem is that the original data is provided in .xlsx and .xls format
It would be much more convenient for me to work directly with the database, but the condition is to work with files of this type. They have tables with data. How can i read the file when loading such a file and save the data in a convenient form in the application, in a list, for example
For further work, I mean to create graphs, and view data on something by clicking on a conditional Example1 (Where, how much, when, etc.)
Personally, I have thoughts to do it all through the DataGrid, but I almost never worked with it, and it's hard to imagine how to provide data for it in a more convenient form.
There is also an idea just through the ListView, but for this I need to transfer all the data from the Excel file to the list, in this version I can more or less imagine how I can implement this, but the only problem is reading and writing data to the list
The only problem is that the original data is provided in .xlsx and .xls format
It would be much more convenient for me to work directly with the database, but the condition is to work with files of this type. They have tables with data. How can i read the file when loading such a file and save the data in a convenient form in the application, in a list, for example
For further work, I mean to create graphs, and view data on something by clicking on a conditional Example1 (Where, how much, when, etc.)
Personally, I have thoughts to do it all through the DataGrid, but I almost never worked with it, and it's hard to imagine how to provide data for it in a more convenient form.
There is also an idea just through the ListView, but for this I need to transfer all the data from the Excel file to the list, in this version I can more or less imagine how I can implement this, but the only problem is reading and writing data to the list
