XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » Is it possible to create xml file using existing schema and xls file as database source
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Xmlconverter does not work (2)
-> + non-printing characters in Fil... (3)
-> + Including row nos while conve... (5)
-> + Getting Evaluation Copy except... (2)
-> + SS 2008 R2 Bug? (4)
-> + Java Heap Space (2)
-> + generate report from .xsl file... (3)
-> + Can't encode 0x4 in text (3)
-> + Recognize Japanese Characters (2)
-> + converting .xsl to xml using c... (2)
-> - Uninstall doesn't clean up reg... (1)
-> + CDISC (5)
-> - creating database from XML sch... (1)
-> + error: side-by-side configurat... (3)
-> - How to convert pdf into rdf fo... (1)
-> + Apache FOP (5)
-> + XPath Query Editor 'Buggy' (3)
-> - Feature request (1)
-> + XML Convertors (2)
-> + XMLConverters version 3.2.0.0 ... (2)
-> + JVM/stylus studio abort on sav... (3)
-- Previous [961-980] [981-1000] [1001-1020] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
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)"
   
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.