1
vote
2answers
76 views

Importing an XML file into excel

I have a multilevel XML file. When I import the XML into excel, it creates multiple columns for the multilevel data. However, I need the multilevel data as additional rows. Is there any way I can ...
0
votes
2answers
137 views

Excel Convert XML cell to columns

I have an excel spreadsheet with XML in a single column. I know that you can import XML data into Excel; but only imports the entire file. However, I need to do this on a cell by cell basis. With ...
0
votes
2answers
111 views

CSV File Import Error - Question Marks / Brackets Everywhere

I have a few .csv files that were sent to me, but when I try to import them either as .txt files or as .xml files I only get blocks of question marks (?) and brackets (CONTENTS) of the type that would ...
1
vote
0answers
71 views

Excel output XML using XSLT

I am attempting to use xml2json-xslt to convert my Excel generated XML to JSON data. It is written in XSL 1.0 so I can run it from the browser and it works just fine. However I would like to include ...
2
votes
0answers
46 views

Wrap paragraphs in paragraph tags in Microsoft Excel

I am using the export as XML feature in Microsoft Excel, I have an XML Schema Definition like so: <?xml version="1.0"?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> ...
0
votes
1answer
19 views

odc connection error via LocaleIdentifier

On the network drive I have an xlsx file with a OLAP Pivot in it. This file uses a connection in a seperate odc file that is saved on the same network drive. Several people have access to both of ...
0
votes
1answer
367 views

Combine unzipped xml files back into a working XLSX file

I can rename an Excel file extension from .XLSX to .zip and extract out the xml files. How do I combine individual Excel xml files back into a single XLSX file? I tried zipping up the folder ...
0
votes
0answers
373 views

Creating readable XML for iOS

My client uses a process that uses XMLSS to create XML documents that can be opened in Microsoft Excel. In fact, simply renaming the files to .XLS, will ensure that the documents open in Excel by ...
1
vote
1answer
2k views

Opening XML+XSD files in Microsoft Excel 2013

I have found Excel 2013 supports opening, editing and saving XML files. I have created an XML file + XSD which Excel opens without complaints and errors. (I.e. it does not state it has to create ...
0
votes
0answers
160 views

IE8 Crashes When Checking Out XML File From SharePoint

I have a user that edits XML files in Excel. When she tries to check out XML files her IE8 crashes. XLS files work fine. I changed the default program association in Windows 7 so that Excel is the ...
5
votes
2answers
337 views

Split Excel column with XML inside

Is there a way to break an Excel column containing XML into several columns like this: BEFORE | Apples | Pears | XML | | ------ | ----- | ...
3
votes
1answer
83 views

Is it possible to edit the source representation of objects in Excel?

I often find myself copying and pasting worksheets in order to show the same analysis for different sets of data. This includes graphs. It's irritating having to 'select data' for every data series, ...
4
votes
1answer
261 views

Excel - including data from a remote (web) sheet?

As a part of providing dynamic dashboards / reports, I've been investigating having a static Excel workbook that would contain a raw data sheet periodically updated from a web source. I'm currently ...
3
votes
2answers
573 views

Excel-like software for XML data?

Is there any Excel-like software for XML data? Something not restricted to spreadsheet format, but allowing: data with hierarchy more strict typing tagging multiple views to the data, unlike ...
1
vote
1answer
334 views

Microsoft Office Data Connection to utilise an external XML Data source?

I want to be able to process or product for connecting an external XML data connector to Microsoft Office Products (specifically Excel) so that it's seamless to the product. Essentially the ...
2
votes
2answers
437 views

Excel version confusion

I got an Excel file, actually it's a zip file which contains many folders and files including sheets in XML format. When I try to open it, Excel 2003 says "The file is not in a recognizable format" ...
1
vote
1answer
550 views

Generate a point chart from XML data, possibly with Excel?

I would like to generate some point chart from XML data. The data should be grouped using color by its "id" attribute. The position is stored in "x" and "y". What software should I use? I tried Excel ...
1
vote
0answers
35 views

Site/service for testing Excel compatibility

We distribute an Excel 2003 compatible XML file that users can fill out and resubmit on the site. While the Excel compatible XML file works fine with Office 2003 and Office 2007, with Office 2010 ...
0
votes
4answers
3k views

Excel 2007 user warning when opening xls files

I am getting the following error warning when opening an .xls file generated using 'CarlosAg.ExcelXmlWriter.dll' in Excel 2007: The file you are trying to open,'', is in a different format than ...
5
votes
3answers
6k views

Excel: Edit the XML inside an XLSX file

An Excel XLSX file is a zip archive containing several XML files. I tried to extract all the XML files, and edit xl\connections.xml using an XML editor. That's because I have to change 20+ ...
3
votes
2answers
825 views

How to Create an XML File from an Excel File

I have an Excel spreadsheet file that has 5 or so columns and hundreds of lines. I need to convert this (export these data) to an XML file. I'm interested in three of the columns and they correspond ...
0
votes
3answers
331 views

How to protect Excel cell contents

How can I protect Excel cells contents in a worksheet and also in its xml file format? I want the cells to be read-only.
3
votes
4answers
18k views

Quick way to convert Excel sheet to XML

How do you easily convert an excel file into a XML file? When trying to save as an XML File, it complains that the file does not have an XML mapping. Clicking help brings up pretty complicated stuff ...
2
votes
1answer
216 views

XML to Excel file?

What's the easiest way of loading a simple XML file (like the one offered in StackExchange data dumps) into an Excel sheet?
0
votes
1answer
661 views

Excel: Fetch values from downloaded xml and insert into table?

How do I force Excel to download http://api.eve-central.com/api/evemon, parse it and format the values in a table every time the .xlsx file is opened? I tried importing the XML and it worked, but I ...
0
votes
1answer
2k views

Excel pivot table reading from xml

Can Excel 2007 use an external xml file as the connection for a pivot table? I am able to filter the dialog by xml when specifying a type of data however I get an error saying that it is not a valid ...