ARCHIVE ...

엑셀로 출력하기(XML) 본문

카테고리 없음

엑셀로 출력하기(XML)

냐옹이. 2013. 4. 7. 14:17 
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" 
	xmlns:o="urn:schemas-microsoft-com:office:office" 
	xmlns:x="urn:schemas-microsoft-com:office:excel" 
	xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" 
	xmlns:html="http://www.w3.org/TR/REC-html40">  
	<Worksheet ss:Name="Sheet1"> 
		<Table> 
			<Row> 
				<Cell><Data ss:Type="String">11</Data></Cell> 
				<Cell><Data ss:Type="String">12</Data></Cell> 
				<Cell><Data ss:Type="String">13</Data></Cell> 
			</Row>
	 		<Row> 
				<Cell><Data ss:Type="String">21</Data></Cell> 
				<Cell><Data ss:Type="String">22</Data></Cell> 
				<Cell><Data ss:Type="String">23</Data></Cell> 
			</Row> 
		</Table> 
	</Worksheet> 
	<Worksheet ss:Name="Sheet2"> 
		<Table> 
			<Row> 
				<Cell><Data ss:Type="String">11</Data></Cell> 
				<Cell><Data ss:Type="String">12</Data></Cell> 
				<Cell><Data ss:Type="String">13</Data></Cell> 
			</Row> 
			<Row> 
				<Cell><Data ss:Type="String">21</Data></Cell> 
				<Cell><Data ss:Type="String">22</Data></Cell> 
				<Cell><Data ss:Type="String">23</Data></Cell> 
			</Row> 
		</Table> 
	</Worksheet> 
</Workbook>

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
	xmlns:o="urn:schemas-microsoft-com:office:office"
	xmlns:x="urn:schemas-microsoft-com:office:excel"
	xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
	xmlns:html="http://www.w3.org/TR/REC-html40">
	<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
		<Author>XYZ</Author>
		<LastAuthor>XYZ</LastAuthor>
		<Created>2003-12-03T15:48:38Z</Created>
		<LastSaved>2004-01-26T21:04:14Z</LastSaved>
		<Company>ABC & Inc</Company>
		<Version>11.5703</Version>
	</DocumentProperties>
	<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
		<WindowHeight>6150</WindowHeight>
		<WindowWidth>8475</WindowWidth>
		<WindowTopX>120</WindowTopX>
		<WindowTopY>30</WindowTopY>
		<ProtectStructure>False</ProtectStructure>
		<ProtectWindows>False</ProtectWindows>
	</ExcelWorkbook>
	<Styles>
		<Style ss:ID="Default" ss:Name="Normal">
			<Alignment ss:Vertical="Bottom"/>
			<Borders/>
			<Font/>
			<Interior/>
			<NumberFormat/>
			<Protection/>
		</Style>
		<Style ss:ID="s21">
			<NumberFormat ss:Format="mmm\-yy"/>
		</Style>
		<Style ss:ID="s22">
			<NumberFormat ss:Format=""$"#,##0.00"/>
		</Style>
		<Style ss:ID="s23">
			<Font x:Family="Swiss" ss:Bold="1"/>
		</Style>
	</Styles>
	<Names>
		<NamedRange ss:Name="Critters" ss:RefersTo="=Sheet1!R4C2:R11C2"/>
		<NamedRange ss:Name="Date" ss:RefersTo="=Sheet1!R1C2"/>
		<NamedRange ss:Name="ID" ss:RefersTo="=Sheet1!R4C1:R11C1"/>
		<NamedRange ss:Name="Price" ss:RefersTo="=Sheet1!R4C3:R11C3"/>
		<NamedRange ss:Name="Quantity" ss:RefersTo="=Sheet1!R4C4:R11C4"/>
		<NamedRange ss:Name="Total" ss:RefersTo="=Sheet1!R12C5"/>
	</Names>
	<Worksheet ss:Name="Sheet1">
		<Table ss:ExpandedColumnCount="5" ss:ExpandedRowCount="12" x:FullColumns="1" x:FullRows="1">
			<Column ss:AutoFitWidth="0" ss:Width="73.5"/>
			<Column ss:AutoFitWidth="0" ss:Width="96.75"/>
			<Column ss:Index="5" ss:AutoFitWidth="0" ss:Width="56.25"/>
			<Row>
				<Cell ss:StyleID="s23"><Data ss:Type="String">Sales for:</Data></Cell>
				<Cell ss:StyleID="s21"><Data ss:Type="DateTime">2004-01-01T00:00:00.000</Data><NamedCell ss:Name="Date"/></Cell>
			</Row>
			<Row ss:Index="3" ss:StyleID="s23">
				<Cell><Data ss:Type="String">ID Number</Data></Cell>
				<Cell><Data ss:Type="String">Critter</Data></Cell>
				<Cell><Data ss:Type="String">Price</Data></Cell>
				<Cell><Data ss:Type="String">Quantity</Data></Cell>
				<Cell><Data ss:Type="String">Total</Data></Cell>
			</Row>
			<Row>
				<Cell><Data ss:Type="Number">4627</Data><NamedCell ss:Name="ID"/></Cell>
				<Cell><Data ss:Type="String">Diplodocus</Data><NamedCell ss:Name="Critters"/></Cell>
				<Cell ss:StyleID="s22"><Data ss:Type="Number">22.5</Data><NamedCell ss:Name="Price"/></Cell>
				<Cell><Data ss:Type="Number">127</Data><NamedCell ss:Name="Quantity"/></Cell>
				<Cell ss:StyleID="s22" ss:Formula="=RC[-2]*RC[-1]"><Data ss:Type="Number">2857.5</Data></Cell>
			</Row>
			<Row>
				<Cell><Data ss:Type="Number">3912</Data><NamedCell ss:Name="ID"/></Cell>
				<Cell><Data ss:Type="String">Brontosaurus</Data><NamedCell ss:Name="Critters"/></Cell>
				<Cell ss:StyleID="s22"><Data ss:Type="Number">17.5</Data><NamedCell ss:Name="Price"/></Cell>
				<Cell><Data ss:Type="Number">74</Data><NamedCell ss:Name="Quantity"/></Cell>
				<Cell ss:StyleID="s22" ss:Formula="=RC[-2]*RC[-1]"><Data ss:Type="Number">1295</Data>
				</Cell>
			</Row>
			<Row>
				<Cell><Data ss:Type="Number">9845</Data><NamedCell ss:Name="ID"/></Cell>
				<Cell><Data ss:Type="String">Triceratops</Data><NamedCell ss:Name="Critters"/></Cell>
				<Cell ss:StyleID="s22"><Data ss:Type="Number">12</Data><NamedCell ss:Name="Price"/></Cell>
				<Cell><Data ss:Type="Number">91</Data><NamedCell ss:Name="Quantity"/></Cell>
				<Cell ss:StyleID="s22" ss:Formula="=RC[-2]*RC[-1]"><Data ss:Type="Number">1092</Data></Cell>
			</Row>
			<Row>
				<Cell><Data ss:Type="Number">9625</Data><NamedCell ss:Name="ID"/></Cell>
				<Cell><Data ss:Type="String">Vulcanodon</Data><NamedCell ss:Name="Critters"/></Cell>
				<Cell ss:StyleID="s22"><Data ss:Type="Number">19</Data><NamedCell ss:Name="Price"/></Cell>
				<Cell><Data ss:Type="Number">108</Data><NamedCell ss:Name="Quantity"/></Cell>
				<Cell ss:StyleID="s22" ss:Formula="=RC[-2]*RC[-1]"><Data ss:Type="Number">2052</Data></Cell>
			</Row>
			<Row>
				<Cell><Data ss:Type="Number">5903</Data><NamedCell ss:Name="ID"/></Cell>
				<Cell><Data ss:Type="String">Stegosaurus</Data><NamedCell ss:Name="Critters"/></Cell>
				<Cell ss:StyleID="s22"><Data ss:Type="Number">18.5</Data><NamedCell ss:Name="Price"/></Cell>
				<Cell><Data ss:Type="Number">63</Data><NamedCell ss:Name="Quantity"/></Cell>
				<Cell ss:StyleID="s22" ss:Formula="=RC[-2]*RC[-1]"><Data ss:Type="Number">1165.5</Data></Cell>
			</Row>
			<Row>
				<Cell><Data ss:Type="Number">1824</Data><NamedCell ss:Name="ID"/></Cell>
				<Cell><Data ss:Type="String">Monoclonius</Data><NamedCell ss:Name="Critters"/></Cell>
				<Cell ss:StyleID="s22"><Data ss:Type="Number">16.5</Data><NamedCell ss:Name="Price"/></Cell>
				<Cell><Data ss:Type="Number">133</Data><NamedCell ss:Name="Quantity"/></Cell>
				<Cell ss:StyleID="s22" ss:Formula="=RC[-2]*RC[-1]"><Data ss:Type="Number">2194.5</Data></Cell>
			</Row>
			<Row>
				<Cell><Data ss:Type="Number">9728</Data><NamedCell ss:Name="ID"/></Cell>
				<Cell><Data ss:Type="String">Megalosaurus</Data><NamedCell ss:Name="Critters"/></Cell>
				<Cell ss:StyleID="s22"><Data ss:Type="Number">23</Data><NamedCell ss:Name="Price"/></Cell>
				<Cell><Data ss:Type="Number">128</Data><NamedCell ss:Name="Quantity"/></Cell>
				<Cell ss:StyleID="s22" ss:Formula="=RC[-2]*RC[-1]"><Data ss:Type="Number">2944</Data></Cell>
			</Row>
			<Row>
				<Cell><Data ss:Type="Number">8649</Data><NamedCell ss:Name="ID"/></Cell>
				<Cell><Data ss:Type="String">Barosaurus</Data><NamedCell ss:Name="Critters"/></Cell>
				<Cell ss:StyleID="s22"><Data ss:Type="Number">17</Data><NamedCell ss:Name="Price"/></Cell>
				<Cell><Data ss:Type="Number">91</Data><NamedCell ss:Name="Quantity"/></Cell>
				<Cell ss:StyleID="s22" ss:Formula="=RC[-2]*RC[-1]"><Data ss:Type="Number">1547</Data></Cell>
			</Row>
			<Row>
				<Cell ss:Index="4" ss:StyleID="s23"><Data ss:Type="String">Total:</Data></Cell>
				<Cell ss:StyleID="s22" ss:Formula="=SUM(R[-8]C:R[-1]C)"><Data ss:Type="Number">15147.5</Data><NamedCell ss:Name="Total"/></Cell>
			</Row>
		</Table>
		<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
			<Print>
				<ValidPrinterInfo/>
				<HorizontalResolution>600</HorizontalResolution>
				<VerticalResolution>600</VerticalResolution>
			</Print>
			<Selected/>
			<Panes>
				<Pane>
					<Number>3</Number>
					<ActiveRow>11</ActiveRow>
					<ActiveCol>4</ActiveCol>
				</Pane>
			</Panes>
			<ProtectObjects>False</ProtectObjects>
			<ProtectScenarios>False</ProtectScenarios>
		</WorksheetOptions>
	</Worksheet>
	<Worksheet ss:Name="Sheet2">
		<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
			<ProtectObjects>False</ProtectObjects>
			<ProtectScenarios>False</ProtectScenarios>
		</WorksheetOptions>
	</Worksheet>
	<Worksheet ss:Name="Sheet3">
		<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
			<ProtectObjects>False</ProtectObjects>
			<ProtectScenarios>False</ProtectScenarios>
		</WorksheetOptions>
	</Worksheet>
</Workbook>

MS Excel Tutorials - Connecting Excel to the World
XML Spreadsheet Reference

저작자표시 비영리 동일조건
공유하기 링크
Comments