Advanced/Expert: XML+XML integration to Xlsx batch process

dguenther

Board Regular
Joined
Jun 15, 2011
Messages
75
Hello all,

Talking about Excel 2007 on Windows 7.

Here is the deal:

Let's say I have two xml docs, that, if opened in excel, and opened as an XML table would like like this:

#1 Case Info: here's a link to the file- it just needs to become a sheet- no transformation needed.
https://my.syncplicity.com/share/cx2wsytjy4/Case_Info.xml

And the 2nd looks like this:
link to it: https://my.syncplicity.com/share/fzzxthhqwo/Voting_Info.xml


Let's call the first one Case info, and the second one Vote Info.

Case info and Vote info need to go into one Excel sheet, with two sheets called " case info and vote info"

Case info just needs to go into a sheet.

Vote info needs to undergo a transformation that is sort of a logic puzzle. Here's a link to before: I've included it for you to see as an xml and xlsx. Perhaps someone versed in xml can just use the xml file to push a xlsx that's ready to go.

What Vote Info.xml looks like when you just open in Excel:


And what Vote info needs to look like:
link: https://my.syncplicity.com/share/vnowsbqtiu/correct_votings_xlsx.xlsx


So, what exactly is the transformation? If you can't tell, this is a listing of legal cases, judge names, and how they voted. The judge's name needs to go down the first column, and only be there 1 time. Then the cases need to go across the first row, again, only expressed 1 time. Then the votes fill in accordingly.

Note, the "final version" example doesn't actually have the right votes in the right place, but I think you get the idea.

Now, that's the idea of the concept. I need a batch process because I have 5,000 files: 2500 case info xml and 2500 voting xml. I need 2500 combined case info and voting xlsx workbooks.

Let's keep discussion in the thread, but of course feel free to PM me.

dguenther
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,726
Office Version
2010
Platform
Windows
Voting info falls easily into a pivot table:

<TABLE style="WIDTH: 516pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=686><COLGROUP><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 3510" span=8 width=77><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 3181" width=70><TBODY><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 58pt; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; HEIGHT: 12pt; COLOR: black; FONT-SIZE: 9pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" height=16 width=77>Sum of v</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 58pt; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 9pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" width=77>Column Labels</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 58pt; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 9pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" width=77> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 58pt; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 9pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" width=77> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 58pt; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 9pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" width=77> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 58pt; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 9pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" width=77> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 58pt; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 9pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" width=77> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 58pt; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 9pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" width=77> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 52pt; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 9pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" width=70> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; HEIGHT: 12pt; COLOR: black; FONT-SIZE: 9pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" height=16>Row Labels</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; FONT-FAMILY: Tahoma; BACKGROUND: #f3f3f3; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl32>No. 3 Div. 860</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; FONT-FAMILY: Tahoma; BACKGROUND: #f3f3f3; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl32>No. 3 Div. 861</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; FONT-FAMILY: Tahoma; BACKGROUND: #f3f3f3; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl32>No. 3 Div. 870</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; FONT-FAMILY: Tahoma; BACKGROUND: #f3f3f3; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl32>No. 3 Div. 887</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; FONT-FAMILY: Tahoma; BACKGROUND: #f3f3f3; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl32>No. 4 Div. 949</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; FONT-FAMILY: Tahoma; BACKGROUND: #f3f3f3; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl32>No. 6 Div. 553</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; FONT-FAMILY: Tahoma; BACKGROUND: #f3f3f3; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl32>No. 7 Div. 436</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; FONT-FAMILY: Tahoma; BACKGROUND: #f3f3f3; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl32>No. 8 Div. 25</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl30 height=16>Ala</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>0</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl30 height=16>Coleman</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>0</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl30 height=16>Goodwyn</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl30 height=16>Lawson</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl30 height=16>Livingston</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>9</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>9</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>9</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>9</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>9</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>9</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl30 height=16>Merrill</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl30 height=16>Simpson</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl30 height=16>Stakely</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>1</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl30 height=16>Wade</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND: white; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: black none" class=xl31 align=right>0</TD></TR></TBODY></TABLE>
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,726
Office Version
2010
Platform
Windows
Record a macro?
 

dguenther

Board Regular
Joined
Jun 15, 2011
Messages
75
shg,

Less so the pivot table part as the combining xml part.

-Danny
 

dguenther

Board Regular
Joined
Jun 15, 2011
Messages
75
I've been playing around with Pivot tables, and they can in fact do the job very well. I'm just not sure how to programatically combine the file called Caseinfo.xml in one sheet, Voteinfo in another sheet and then do the pivoting.


Ideas?
 

dguenther

Board Regular
Joined
Jun 15, 2011
Messages
75
So, I have discovered utilities that can very nicely combine multiple excel files into just one excel file. But I cannot find a utility/thought on how to combine two excel workbooks (each with one sheet) into 1 workbook with 2 sheets.

Ideas?
 

Forum statistics

Threads
1,086,035
Messages
5,387,406
Members
402,061
Latest member
RAZE

Some videos you may like

This Week's Hot Topics

Top