Advertisement

12.20.2007 at 02:38PM PST, ID: 23037199
[x]
Attachment Details

How do we edit an xml file with excel and export it to xml again

Asked by weikelbob in Microsoft Excel Spreadsheet Software, Miscellaneous Web Development, Extensible Markup Language (XML)

Tags: FF, IE, www.weddingmountain.com

We have an xml file that we will be editing thousands of times. We need to import it into Excel, edit it, then export it into XML again.

I've attached an example xml file.

We have access to any version of excel.

Thanks!Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:

<AspDotNetStorefrontImportFile>
<Product>
	<Name>Cami 71530 - Satin Sandal by Colorful Creations</Name>
	<ProductTypeRef>Generic Product</ProductTypeRef>
	<ManufacturerRef>Colorful Creations</ManufacturerRef>
	<DistributorRef>Colorful Creations</DistributorRef> <!-- ML ONLY FEATURE -->
	<CategoryRef>/Wedding Shoe Manufacturers/Colorful Creations</CategoryRef>
	<CategoryRef>/Wedding Shoes/Bridal Shoes</CategoryRef>
    <CategoryRef>/Wedding Shoes/Dyeable Shoes</CategoryRef>
    <CategoryRef>/Wedding Shoes/Bridesmaid Shoes</CategoryRef>
    <CategoryRef>/Wedding Shoes/Evening &amp; Prom Shoes</CategoryRef>
    <CategoryRef>/Wedding Shoes by Color/White Wedding Shoes</CategoryRef>
    <CategoryRef>/Wedding Shoe Styles/Slings, Slingbacks &amp; T-Straps</CategoryRef>
    <CategoryRef>/Wedding Shoe Styles/Bridal Sandals, Slides &amp; Thongs</CategoryRef>
	<SectionRef></SectionRef>
	<Summary></Summary>
	<Description>
		&lt;p>Introducing Colorful Creations wedding, evening &amp; prom shoes. &lt;/p>
			
		&lt;p>&lt;b>Cami by Colorful Creations&lt;/b> is a white satin sandal with ankle strap.&lt;/p>
		
		&lt;p>&lt;i>*Note: Shown dyed green in picture.&lt;/i>&lt;/p>
		
		&lt;p>&lt;b>COLOR:&lt;/b> White&lt;/p>
		&lt;p>&lt;b>MATERIAL:&lt;/b>   Satin&lt;/p>
		&lt;p>&lt;b>DYEABLE:&lt;/b>     Yes&lt;/p>
		&lt;p>&lt;b>HEEL-HEIGHT:&lt;/b>   2"&lt;/p>
		&lt;b>SIZES:&lt;/b>&lt;br />
			(M) Medium 5-10, 11, 12, 13&lt;br />
			(W) Wide 6-10, 11, 12, 13&lt;br />&lt;br />
	</Description>
	<SEKeywords>bridal shoes, wedding shoes, bridesmaid shoes, groomsmen shoes, wedding footwear, dyeable shoes</SEKeywords>
	<SEDescription>Bridal Shoes by Colorful Creations</SEDescription>
	<SETitle>Bridal Shoes by Colorful Creations</SETitle>
	<SKU>CO-71530</SKU>
	<ManufacturerPartNumber>CO-71530</ManufacturerPartNumber>
	<XmlPackage>product.simplevariantformat3.xml.config</XmlPackage>
	<ColWidth>4</ColWidth>
	<SalesPromptID>1</SalesPromptID>
	<Published>1</Published>
	<RequiresRegistration>0</RequiresRegistration>
	<RelatedProducts></RelatedProducts>
	<MiscText></MiscText>
	<TrackInventoryBySizeAndColor>0</TrackInventoryBySizeAndColor>
	<ImageFilenameOverride></ImageFilenameOverride>
	<ExtensionData></ExtensionData>
	<IsAKit></IsAKit>
	<IsAPack></IsAPack>
	<PackSize></PackSize>
	<ProductVariant>
		<Name></Name>
		<IsDefault>1</IsDefault>
		<SKUSuffix></SKUSuffix>
		<ManufacturerPartNumber></ManufacturerPartNumber>
		<Description></Description>
		<SEKeywords></SEKeywords>
		<SEDescription></SEDescription>
		<SETitle></SETitle>
		<Price>14.95</Price>
		<SalePrice></SalePrice>
		<MSRP></MSRP>
		<Cost>14.95</Cost>
		<Weight></Weight>
		<Dimensions></Dimensions>
		<Inventory>1000000</Inventory>
		<DisplayOrder>1</DisplayOrder>
		<Colors></Colors>
		<ColorSKUModifiers></ColorSKUModifiers>
		<Sizes>5-M,5½-M,6-M,6-W,6½-M,6½-W,7-M,7-W,7½-M,7½-W,8-M,8-W,8½-M,8½-W,9-M,9-W,9½-M,9½-W,10-M,10-W,11-M,11-W</Sizes>
		<SizeSKUModifiers></SizeSKUModifiers>
		<IsTaxable>1</IsTaxable>
		<IsShipSeparately>0</IsShipSeparately>
		<IsDownload>0</IsDownload>
		<DownloadLocation></DownloadLocation>
		<Published>1</Published>
		<imageIconReference>
		<ImageFilenameOverride></ImageFilenameOverride>
		<ExtensionData></ExtensionData>
	</ProductVariant>
</Product>
</AspDotNetStorefrontImportFile>
[+][-]12.21.2007 at 06:11AM PST, ID: 20513495

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]12.21.2007 at 02:59PM PST, ID: 20516969

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.26.2007 at 12:19PM PST, ID: 20530710

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.27.2008 at 12:03AM PST, ID: 20753015

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]01.28.2008 at 04:51PM PST, ID: 20764492

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.02.2008 at 07:02PM PST, ID: 20807287

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]02.14.2008 at 08:27PM PST, ID: 20899375

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]02.15.2008 at 01:15AM PST, ID: 20900275

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.15.2008 at 11:55AM PST, ID: 20905286

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Excel Spreadsheet Software, Miscellaneous Web Development, Extensible Markup Language (XML)
Sign Up Now!
Solution Provided By: roos01
Participating Experts: 3
Solution Grade: A
 
 
[+][-]02.16.2008 at 12:23AM PST, ID: 20908811

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]02.20.2008 at 04:05AM PST, ID: 20936912

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]02.29.2008 at 10:42PM PST, ID: 21020321

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]02.29.2008 at 11:41PM PST, ID: 21020593

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.29.2008 at 11:54PM PST, ID: 21020630

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.01.2008 at 11:39AM PST, ID: 21023140

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.06.2008 at 05:26PM PST, ID: 21066475

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]03.07.2008 at 05:53AM PST, ID: 21069908

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.23.2008 at 11:57PM PDT, ID: 21192212

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628