I am currently developing an ASP.NET 2.0 app part of the app will involve collecting a large amount of data offline and then importing this data into the system
My question is what will be more effiecient from a system resources/performance point of view. If I go down the Excel route then for every sheet parsed (and there could be up to 20 of them) I will have check 5400 cells to see if there is any data in them.
If I use an XML file to store the information (with the aid of a windows app on the client) there would be a maximum of about 1800 nodes per sheet.
So will I be better importing from Excel or XML?