Avatar of StormFusion
StormFusion
Flag for United Kingdom of Great Britain and Northern Ireland asked on

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

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
Microsoft Excel

Avatar of undefined
Last Comment
Professor J

8/22/2022 - Mon
Anastasia D. Gavanas

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 J

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.
StormFusion

ASKER
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
Your help has saved me hundreds of hours of internet surfing.
fblack61
Professor J

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.
ASKER CERTIFIED SOLUTION
Professor J

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Professor J

.