Excel 2007 : [XML] import -> filter -> export

**beeryourself** · 04-05-2012, 06:39 AM

hi everybody!
I have an XLS file that gets data from an imported XML file.
I need to apply some filters and then export it in a new XML file.
I'm trying both "Development->Export" and "Save as->XML Data" procedures, but it always saves all data in the XLS document, not only the filtered.
How can I obtain a new XML file with only filtered data???
Thankyou for your answers!

**Richard Buttrey** · 04-05-2012, 06:51 AM

Hi,

Seems to me the easiest way is to use Data Filter Advanced to extract whatever records you want to a completely new sheet, then right click the sheet tab name, choose 'Move or Copy', tick the 'create a copy' box and select the 'new workbook option'.

Then save the new workbook you have created as an xml file.

**beeryourself** · 04-05-2012, 07:24 AM

ok, I've tried with your suggestion but on the new workbook it losts the xml mapping then I can't save it to XML Data...
any other solution?

**Richard Buttrey** · 04-05-2012, 07:35 AM

Hi,

Can you upload your actual workbook?

Regards

**beeryourself** · 04-05-2012, 07:40 AM

I don't think it's possible, there are sensible data...
I can describe it. It's a table containing names, phone numbers and text.
I need to apply a filter for a range of phone numbers (I already made it by Advanced filter and wildcards).
After filtering I need to create a new XML file with only that data.
It's weird there isn't a specific function in excel!

**beeryourself** · 04-10-2012, 06:05 AM

anyone can help me?

**Richard Buttrey** · 04-10-2012, 06:10 AM

Hi,

I'm sure it's sensible data,

but even if it's sensitive data we don't need to see real names or descriptions. Just manually change them to anonymous values on a copy and upload the copy. Neither do we need to see every single row as long as you include a representative sample.

**beeryourself** · 04-10-2012, 07:40 AM

here is an example...

**beeryourself** · 04-12-2012, 03:34 AM

is there a way to do what I'm asking for?

**zotson** · 10-29-2013, 09:40 AM

Hi Beeryourself,

I'm having the same problem, did you ever find a solution?

thanks

Excel 2007 : [XML] import -> filter -> export

LinkBack

Thread Tools

Rate This Thread

Display

[XML] import -> filter -> export

Re: [XML] import -> filter -> export

Re: [XML] import -> filter -> export

Re: [XML] import -> filter -> export

Re: [XML] import -> filter -> export

Re: [XML] import -> filter -> export

Re: [XML] import -> filter -> export

Re: [XML] import -> filter -> export

Re: [XML] import -> filter -> export

Re: Excel 2007 : [XML] import -> filter -> export

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions