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
2eqgcah.png


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:
3359s8z.png


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


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
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
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>
 
Upvote 0
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?
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top