We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
COURSE of the MONTH
14 days, 8 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Export sheet range of data to XML file and import back.
Posted on 2016-09-27
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4
7 Comments
Active 1 day ago
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
The data should go back to its original place
Active today
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.
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
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
Active today
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.
so, either we provide a working solution, or we delete the question.
thanks for your understanding.
Active today
@ 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.
then 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
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.
then 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
Featured Post
Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
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
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Suggested Courses
Course of the Month14 days, 8 hours left to enroll
771 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.