Convert Excel to XML file/XML Schema, and validate Excel against XML Schema
-
Has anyone seen this article on how to Convert Excel to XML file/XML Schema, and validate Excel against XML Schema at this website: http://www.codeproject.com/KB/office/excel2xml.aspx? I am trying to convert an Excel file to an XML file. I have downloaded the files in this article and have tried to get to the screen that is shown in the example. However, I don't know how to connect the Jet Engine to the Excel Spreadsheets. Can anyone tell me how I would get to this screen? Or where I would write the command to make the connection. Prompt response will be greatly appreciated.: confused:
-
Has anyone seen this article on how to Convert Excel to XML file/XML Schema, and validate Excel against XML Schema at this website: http://www.codeproject.com/KB/office/excel2xml.aspx? I am trying to convert an Excel file to an XML file. I have downloaded the files in this article and have tried to get to the screen that is shown in the example. However, I don't know how to connect the Jet Engine to the Excel Spreadsheets. Can anyone tell me how I would get to this screen? Or where I would write the command to make the connection. Prompt response will be greatly appreciated.: confused:
Rebecca Fox wrote:
Prompt response will be greatly appreciated.: confused:
Hi Rebecca, welcome to CodeProject :beer: The articles like the one you are using have there own forums/blogs at the bottom of the article page. That is the best place to ask questions pertaining to the article. I am not familiar with that article. However glancing through it, and I have no idea what the scope of your project is, but one of the most frequently used approaches for working with Office applications is to use the
Primary Interop Assemblyfor the product. There are different assemblies for different versions of Office. For example you would go here if working with Office XP[^]. There is a different resource for Office 2003 etc.led mike