We help IT Professionals succeed at work.

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

StormFusion
StormFusion asked
on
95 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
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2011

Commented:
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
Professor JMicrosoft Excel Expert
CERTIFIED EXPERT
Top Expert 2014

Commented:
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.

Author

Commented:
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
Professor JMicrosoft Excel Expert
CERTIFIED EXPERT
Top Expert 2014

Commented:
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.
Microsoft Excel Expert
CERTIFIED EXPERT
Top Expert 2014
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Professor JMicrosoft Excel Expert
CERTIFIED EXPERT
Top Expert 2014

Commented:
.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions