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 » excel to text
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Stylus studio 2010 crashes in ... (5)
-> - excel to text (2)
-> ->excel to text
-> + licence key? (2)
-> + JVM Heap error (4)
-> + How Do I clean TXT File? (2)
-> + SS Web Service Call Tester Pay... (3)
-> - SS Web Service Call Tester Mic... (1)
-> + Error in Stylus Studio - canno... (2)
-> + Saxon Assign (2)
-> - License Authentication Failed (1)
-> + Stylus Studio 2007 Download (2)
-> + EDI to XML validation (2)
-> + Reports: can't remove "undead"... (3)
-> + Document Wizard Incomplete (6)
-> + Opening xml converter (4)
-> + Node depth limit with MySQL? (5)
-> + Basics (2)
-> - Node depth limit with MySQL? (1)
-> + Creating an XML Schema from a ... (4)
-> - Issue with XSD (1)
-- Previous [481-500] [501-520] [521-540] 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
Johnny YiiSubject: excel to text
Author: Johnny Yii
Date: 16 Sep 2010 03:22 PM
hello, are there excel 2007 functions in your product?

i want to convert excel files into a delimited text file to upload into our vms enterprise system.

let me know if you have this feature.

thanks
Posttop
Ivan PedruzziSubject: excel to text
Author: Ivan Pedruzzi
Date: 17 Sep 2010 06:42 PM
Hi Johnny

DataDirect XQuery, the engine bundled with Stylus Studio Enterprise provides built-in support for Office Open XML, including .XLSX

DataDirect XQuery can be used to extract information from Excel and to generate CSV in output.

Here two interesting posts to get started

XQuery Your Office Documents
http://www.drdobbs.com/open-source/202401913

Using XQuery to join two Excel spreadsheets? Why not?
http://blogs.datadirect.com/2008/03/using-xquery-to-join-two-excel.html

Hope this helps
Ivan

   
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.