Tagged Questions
0
votes
0answers
13 views
XSL not reading XML to Excel
I am attempting to have my XSL pull data from my XML to push it to Excel. I can get the Excel sheet to generate and input cells, but it will NOT pull any data out of the XML document.
In the example ...
0
votes
1answer
21 views
Can I update an XML node value using a variable in VBA
I am a complete newcomer to learning about XML but OK with VBA in Excel 2010.
In Excel VBA I have created a simple CustomXMLPart with 5 nodes under a single root, akin to the example below:
<
...
0
votes
2answers
44 views
Convert xlsx to XML spreadsheet 2003 in ASP.net c# programmatically
I have a web application that reads from XML, but the users need to upload .xlsx or .xls files.
How do I programatically convert the Excel files into XML spreadsheet 2003?
0
votes
1answer
50 views
Insert .xml file containing word document into mysql using php script
I wrote this code for Inserting Excel (.xml) file into MySQL database using PHP Script.
But It cannot inserting data containing MS.WORD (TABLE, PICTURES, etc.), there is a inserting of blank space ...
-5
votes
0answers
41 views
Creating XSL from a excel file [closed]
We create lot of mapping documents in excel sheet where we mention mapping between 2 XSDs. For example a incoming request XML has to be converted into a new different format before going to backend. ...
0
votes
0answers
29 views
Using XLST to format Excel sheets
Just started an Internship and I have been given the task of finding a way of taking an XML file and importing it into Excel, nicely formated so it can be easily understood. I spent a while searching ...
0
votes
1answer
21 views
exporting from excel to xml with Cdata tags
This is my first time posting so apologizes if I do it a bit wrong.
My Issue is..
I have a excel file with a lot of data.
What i need to do is export it as an xml file.
Which i can do but i need to ...
-1
votes
1answer
19 views
import specific fields from xml file
I have an extremely dense XML file with 116 columns and 700+ rows on average, sometimes more sometimes less. Currently the only way we have of handling this XML file is to import it into Excel, ...
0
votes
2answers
46 views
Querying xml parent node attribute from child node
I am working with an xml similar to this:
<?xml version="1.0" encoding="utf-8"?>
<Results>
<Pattern Name="Substitution">
<TestList>
<Test>
...
1
vote
1answer
49 views
Convert Complex Excel to XML
after researching for the past three days and compiling a hackneyed version of an Excel-to-XML converter, it's time I come to the forum for help because I can't get exactly what I need. There's some ...
0
votes
0answers
36 views
Import XML into Excel
I have the following XML file which I import into an XML table in Excel. From below, <Benchmark> entry is 1 record. I also add an entry for the user's selection parameters ...
0
votes
1answer
32 views
Have to get all the AS400 DB2 field names onto a Table
I need to create a table that will contain the field names and legnth, of an AS/400 file, and I have to add additional columns for Description, and values. For instance, an Orderheader file would ...
3
votes
2answers
499 views
XPath simple conditional statement? If node X exists, do Y?
I am using google docs for web scraping. More specifically, I am using the Excel built in importXML function in which I use xPath to select nodes to scrape data from.
What I am trying to do is ...
2
votes
1answer
838 views
excel: Cannot save or export xml data. The xml map in this workbook are not exportable
I come across a excel XML export problem. To simple the question, I do the next steps:
1.Data>>from XML data import.
Actually, I want to export it back to XML file again after some modification on ...
1
vote
5answers
2k views
Excel Conversion of SpreadsheetML to Open XML (XLSX)
Simple question. Does anyone know an easy way to convert SpreadsheetML (Excel 2003 XML) to the Open Document XML used for Excel 2007 (xlsx) files?
I've got a library that unfortunately doesn't read ...
