SSDN - excel to text

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Johnny Yii

Subject: 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

Ivan Pedruzzi

Subject: 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

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.