Export sheet range of data to XML file and import back.
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
The data should go back to its original place
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
Gain unlimited access to on-demand training courses with an Experts Exchange subscription.
Get AccessWhy 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.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
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