Solved

Export sheet range of data to XML file and import back.

Posted on 2016-09-27
7
52 Views
Last Modified: 2016-11-01
Hi,

Is it possible to export a range on my sheet say A1:Z100 of all its values etc to a XML file and then a feature to import this data back exactly as it was taken, so I export the data.  Delete all of the cells and when I import back they go exactly where they were?

It must not ask about overwriting the original data file etc.

Cheers
0
Comment
Question by:StormFusion
  • 4
7 Comments
 
LVL 18

Expert Comment

by:xtermie
ID: 41819295
You can export in XML, do your edits but DO NOT Delete the CELLS just CLEAR the contents and then import back

The data should go back to its original place
0
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 41819338
question is, why would you want to do that.  if you explain what is the aim and purpose of doing this. perhaps there is an easy solution to this.
0
 

Author Comment

by:StormFusion
ID: 41819456
Hi

I have a shared spreadsheet but the data is separate for each user.  So I have a sheet within that contains all the data I need to export that and reload for each user there data set.  But it needs to do this without user seeing any flashes or prompts etc
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 41841673
thanks xtermie  for taking the initiative to close the question; however, i do not believe we provided an satisfactory answer to the OPs question, so it wouldn't be fair to close this way.

so, either we provide a working solution, or we delete the question.

thanks for your understanding.
0
 
LVL 26

Accepted Solution

by:
ProfessorJimJam earned 500 total points (awarded by participants)
ID: 41841777
@ StormFusion

i do not see any better solution but to use the XML tool Add-in for Excel from available in Microsoft.

i have modified the Add-in so that it works as a normal file.

here are the steps.

before everything else,  if your Excel Developer Tab is not visible, then go to File Options Customize Ribbon and Tick Mark the "Developer"


download the attached file, when you open it, you will see under the Add-in tab a dropdown Menu

select your data then under the Add-in drop down select the first one "Convert a range to XML list"
once you do that then go to Developer Tab and there is button called Export, see screenshot.
2016-10-13-13_33_59-Microsoft-Excel-.pngthen it will prompt the location to save it , once you save it, then you can share that file to the users and then they can go to Developer tab and this time, they click on Import and it prompts them to select the file and once done, it will ask for location to paste the XML file in worksheet, once clicked ok.  the XML is imported back to worksheet.
XMLTOOL.xlsm
0
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 41868054
.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question