I've done the following:
Opened an .xml file (File,Open, Choose: Use the XML Source task pane). Then dragged and dropped elements from the XML source pane, and created a template file (.xltx). Now I can open the .xltx file, right-click on a cell, choose import and select an xml file to populate the form.
Now, how can I associate my xml files to .xltx file? Like how xml/xsl works by having the xml file direct to xsl with the following tag: xml-stylesheet type="text/xsl" href="class.xsl" <?xml-stylesheet type="text/xsl" href="class.xsl"?>
Am I limited to the Excel UI interface when using .xltx files? Any recommendations on books/resources available on this?
Opened an .xml file (File,Open, Choose: Use the XML Source task pane). Then dragged and dropped elements from the XML source pane, and created a template file (.xltx). Now I can open the .xltx file, right-click on a cell, choose import and select an xml file to populate the form.
Now, how can I associate my xml files to .xltx file? Like how xml/xsl works by having the xml file direct to xsl with the following tag: xml-stylesheet type="text/xsl" href="class.xsl" <?xml-stylesheet type="text/xsl" href="class.xsl"?>
Am I limited to the Excel UI interface when using .xltx files? Any recommendations on books/resources available on this?
