XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Ed JSubject: Is it possible to create xml file using existing schema and xls file as database source
Author: Ed J
Date: 06 Aug 2008 10:11 AM
Hello

Is it possible to create xml file using existing schema and Microsoft Excel (xls) file as database source?

Postnext
Minollo I.Subject: Is it possible to create xml file using existing schema and xls file as database source
Author: Minollo I.
Date: 06 Aug 2008 03:32 PM
Using our DataDirect XML Converters and XQuery components you will be able to do that only if you save the Excel file as .csv (Comma Separated Value file) or .slk (Symbolic Link); then you can use XML Converters to interpret the file as XML and XQuery to shape it according to your pre-existing XML Schema.

Another option would be to work with the file saved as .xlsx (the Open Office XML format) and access it directly from XQuery (http://www.xml-connection.com/2008/03/using-xquery-to-join-two-excel.html).

The Excel file itself cannot be accessed directly by DataDirect XQuery (or Stylus Studio) as a database source.

Postnext
Ed JSubject: Is it possible to create xml file using existing schema and xls file as database source
Author: Ed J
Date: 08 Aug 2008 01:08 PM
The XML is a new thing for me. Therefore just to make sure I understand the overall concept. The xls file (or any other file, flat files, etc) 1st have to be converted to XML format (this mean that tags for every field in all records) in order to be used in the XQuery. Is this is correct.

Also how to you save xls in the .xlsx format?

Posttop
Minollo I.Subject: Is it possible to create xml file using existing schema and xls file as database source
Author: Minollo I.
Date: 08 Aug 2008 01:33 PM
>The xls file (or any other file, flat files, etc) 1st have to be
>converted to XML format (this mean that tags for every field in all
>records) in order to be used in the XQuery. Is this is correct.

It is correct.

>Also how to you save xls in the .xlsx format?

Using Excel 2007, Save As... > Save as type "Excel Document (*.xlsx)"

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.