Comparing excel data to XML
-
Hi all, I need to develop an application that can compare an Excel spreadsheet with some data that I can view on an internal site My plan was to -read the data from Excel into a dataset, -get the data from the site in XML format and -then compare this. My question is - do you think this is the best way to solve this? i.e. get the data from Excel into a dataset, get the data in XML format from the site to a dataset, and compare the two? I'm not even sure that the data I get from the site is in a format that can be compared to the Excel data as the tables aren't the same, so I will probably have to modify it so as to make them in a similar format before comparing any input appreciated edit: re-reading this i m not sure its clear: source 1 :: Excel source 2 :: Data on an internal site objective: compare the 2 suggestions: see above question: best solution :)
-
Hi all, I need to develop an application that can compare an Excel spreadsheet with some data that I can view on an internal site My plan was to -read the data from Excel into a dataset, -get the data from the site in XML format and -then compare this. My question is - do you think this is the best way to solve this? i.e. get the data from Excel into a dataset, get the data in XML format from the site to a dataset, and compare the two? I'm not even sure that the data I get from the site is in a format that can be compared to the Excel data as the tables aren't the same, so I will probably have to modify it so as to make them in a similar format before comparing any input appreciated edit: re-reading this i m not sure its clear: source 1 :: Excel source 2 :: Data on an internal site objective: compare the 2 suggestions: see above question: best solution :)
Hard to say from the info you peovided. maybe you should think of some parsers.
SkyWalker
-
Hard to say from the info you peovided. maybe you should think of some parsers.
SkyWalker
Basically i don't need an optimal way to do this as this will run once a week only from a local machine - no particular speed requirements Let's say that the database info I get from the site is similar to the one I have on Excel, can I just confirm that I can connect to the Excel using ado.net and get the data in a dataset. I will then have an XmlTextReader with raw XML data from the site - convert that into a dataset and compare the two datasets. Does this plan make sense?
-
Basically i don't need an optimal way to do this as this will run once a week only from a local machine - no particular speed requirements Let's say that the database info I get from the site is similar to the one I have on Excel, can I just confirm that I can connect to the Excel using ado.net and get the data in a dataset. I will then have an XmlTextReader with raw XML data from the site - convert that into a dataset and compare the two datasets. Does this plan make sense?
You have, I guess, the software requirements,so it's entirely up to you to set the approach to solving your problem.
SkyWalker
