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 » XML to Excel conversion and vice versa
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + DBF converter with the Cyrilli... (3)
-> + Stylus Studio caching document... (3)
-> + Stylus Studio Online help inst... (9)
-> + specific colors (2)
-> + Formatting problems when creat... (2)
-> - Headers and Footers (1)
-> + XML output's a URL in Browser ... (2)
-> + Generating Java Code for XML (3)
-> + format dates in publisher (2)
-> + grouping in Stylus Studio Publ... (5)
-> + Can schema documentation title... (3)
-> + Stylus can not find the right ... (2)
-> + Problem to create Schema from ... (5)
-> - Design a DTD to represent the ... (1)
-> + Surround SCM integration (3)
-> + Converting a csv file to xml u... (5)
-> + Legacy Format Handling (3)
-> + Size limit for XML documents (2)
-> + Can Stylus Studio easily expor... (3)
-> + Problem convert excel to xml (5)
-> + convert X12 EDI into XML in a... (2)
-> + Capturing the return data for ... (3)
-> + stamps.com wsdl issues (3)
-> + Preview issues (2)
-> + Stylus Studio X14 - XML to EDI... (3)
-> + Stylus Studio X14 - Overrides ... (4)
-> + Anyway to specify namespace pr... (6)
-> + StylusStudio 2010 crashes when... (6)
-> + Version Upgrade (2)
-> + How to write a if -else statem... (4)
-> + URGENT URGENT URGENT ! (EDIF... (3)
-> + X14 Saxon document uri problem (5)
-> + namespace problem on XML gener... (7)
-> + Stylus Studio Tool Bars (2)
-> + X14 Enterprise - Web Services ... (3)
-> + Saxon edition in X14 Enterpris... (2)
-> + How to create PDF documents wi... (2)
-> + WSCall doesn't work from xquer... (4)
-> + Issues with converter (8)
-> + xsd null strings - option to i... (2)
-> + wrapping table rows and mismat... (3)
-> + Report Designer: Is it possibl... (4)
-> + Message Baplie 1.5 with 1.911 ... (2)
-> + saved merged view in diff engi... (2)
-> + Cannot see needed element to m... (2)
-> + Matching problem in function (3)
-> - Funny warning message (1)
-> - Missing rows and text when con... (1)
-> + Another JSON problem (2)
-> + JSON problem (8)
-> + WebDav Custom properties (2)
-> + jvm not registering in the too... (2)
-> + How to turn off error about mi... (6)
-> + XML Attribute Element output f... (2)
-> + ddtek:wscall not returning all... (7)
-> - Trial Only Lasted 7 of the 14 ... (1)
-> + tree view without leaves (fiel... (3)
-> + XML to Text File (2)
-> + Stylus Studio Processor Debugg... (3)
-> + Java XMLPipeline result to str... (6)
-> + Attribute - XSD, DataDirect, X... (7)
-> + .NET XslCompliedTransform pro... (3)
-> + How to increase JVM Heap Size? (10)
-> + How in XSD do I reference the ... (2)
-> + Conversion of negative numbers (2)
-> + XSLT mapper (2)
-> - Converting csv file with embed... (1)
-> + WSDL completion inquiry (2)
-> - Move License (1)
-> - XML to Excel conversion and vi... (8)
-> ->XML to Excel conversion a...
-> ->XML to Excel conversion a...
-> ->XML to Excel conversion a...
-> ->XML to Excel conversion a...
-> ->XML to Excel conversion a...
-> ->XML to Excel conversion a...
-> ->XML to Excel conversion a...
-> + “spell checker” and “well-form... (2)
-> + Relational DB Icon Not appeari... (2)
-> + How come AUP doesn't respond (4)
-> - Software activation does not w... (1)
-> + Stylus studio continually cras... (2)
-> + Error running on Windows 7 (3)
-> + Creating xml start and end tag... (4)
-> + Keeping track of position afte... (3)
-> + splitting a row into multiple ... (3)
-> + Where is Convert to XML? (2)
-> + Built-In XSLT Processor Missin... (4)
-> - Converting XSL to XSL-FO (1)
-> - Can we compare two XML Schema ... (1)
-> - Stylus Studio EDI Conversion /... (1)
-> + Installation Issue Windows XP ... (2)
-> + Converting CSV with component ... (2)
-> - how to edit a xsl file, so tha... (1)
-> - Cannot save file to Webdav (1)
-> + How to copy Column Names on Gr... (3)
-> - XML when to use (1)
-> - Attribute vs data elements (1)
-> - Attribute Group (1)
-> - EDI conversion from command li... (1)
-> - WSDL schema - import of xsd (1)
-> + Get Date (2)
-> + help calling https web service (5)
-> - Newbie looking out for BizTalk... (1)
-> + Publishing XML pipeline as Web... (2)
-> - annotation within sequence ele... (1)
-> - backmapping using Saxonica 9.1... (1)
-- Previous [301-320] [321-340] [341-360] 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
Lak shaSubject: XML to Excel conversion and vice versa
Author: Lak sha
Date: 27 Jun 2011 03:13 AM
Hi,

I have some xml strings files with me. I have to convert the xml files into excel sheet and have to do some modification in string values. After that I want to update back the excel sheet into xml file.

How can I convert from xml to excel sheet and vice versa through this tool?

I strated using Stylus Studio 2011 XML Enterprises and Professsional suite recently and I want to purchase either of one suite if it suiting for my requirements.

Expecting to hear from you soon

Regards
Lakshya
Postnext
Ivan PedruzziSubject: XML to Excel conversion and vice versa
Author: Ivan Pedruzzi
Date: 28 Jun 2011 10:48 PM
Search Excel in the forum you will find several entries
Postnext
Lak shaSubject: XML to Excel conversion and vice versa
Author: Lak sha
Date: 30 Jun 2011 08:39 AM
Hi ,

Thanks Ivan for your reply.

I searched by typing Excel in forum and I found some link regarding the XML to EXCEL converter discussion. But I didn't get a clear idea about the conversion.

I want to know whether is it possible to translate xml to excel and back from excel to xml using Stylus Studio. If it so, what is the procedure for doing that?

In discussion they are telling to convert into XSLT format, CSV format like that. I tried but I am not able to get it.

Since the xml fiel I want to convert have multiple values in a tag with same tag name and tag id. Child tags with its values are coming in between the multiple values for a same tag name. Also sub array tag values also there in between.

Please any body help me to translate from xml to excel and vice versa.

Since our requirement is immediate and I have purchase the Stylus Studio tool as soon as possible if it converts xml to excel and vice versa.

Looking forward to hear soon

Regards
Lakshya
Postnext
Lak shaSubject: XML to Excel conversion and vice versa
Author: Lak sha
Date: 05 Jul 2011 09:38 AM
Hi,

I have seen in Stylus Studio® 2011 XML Feature Comparison Matrix, Export XML to Microsoft Excel is listed under Synchronized XML Grid View heading.

But I am not able to Export the xml file into Excel sheet.

Anybody could you please help me with this issue?

I have attached the xml file which i need to import all values into Excel sheet, modify it and convert back into Excel sheet.

Looking forward to hear soon.

Regards,
Lakshya


UnknownSample(16).xml
xml file
Postnext
Ivan PedruzziSubject: XML to Excel conversion and vice versa
Author: Ivan Pedruzzi
Date: 06 Jul 2011 02:01 AM
Right click on the table header then click on "Copy as Tab-Delimited"
Switch to Microsoft Excel and do paste (CTRL + V)

Hope this helps
Ivan
Postnext
Lak shaSubject: XML to Excel conversion and vice versa
Author: Lak sha
Date: 06 Jul 2011 07:02 AM
Hi Ivan,

Thanks a lot... It helps me a lot.

But some issues are there. The xml file have multiple sub-array tag values(in the sample.xml file it is string-array/item).I have to copy each sting-array values seperately and paste. Is there any solution to export entire tag values and sub tag values at a time into Excel sheet?


Als how can I save it back to the original xml file after doing some modifications in string values in the imported excel sheet ? So that the xml file will work like original file.

Once again thanks and expecting to hear soon

regards
lakshya
Postnext
Ivan PedruzziSubject: XML to Excel conversion and vice versa
Author: Ivan Pedruzzi
Date: 07 Jul 2011 12:40 AM
Hi Lakshya

What you are describing does not sound practical.

The XML structure you are editing can not be automatically mapped into flat file and round tripped.

It may be possible to write XSLT or XQuery to generate the flat file.

Why you don't edit the file directly in the XML Grid View?
Why you need to work in Excel?
Posttop
Lak shaSubject: XML to Excel conversion and vice versa
Author: Lak sha
Date: 08 Jul 2011 12:18 AM
Hi Ivan,

Yes, you are right. We can edit the xml file through xml grid view.

But in my company because of some security reason we want to give, the string name and values which have to edit alone to outside. Thatsy we are looking for Excel sheet conversion. So that we can convert the values which we want to edit into Excel sheet from xml file and can give outside. Also when they will return the Excel sheet after editing we can convert it back into xml file. So we can ensure the security of our file.

As you said-- to write XSLT or XQuery to generate the flat file. How will be the procedure to generate one flat file including all tag multiple values, sub-array values through Stylus studio? Also how can I convert back from excel sheet then?

Thanks and Regards

lakshya
   
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.