View Source for Example

	
	<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
	<title>Sample 10</title>
</head>

<body>

<!-- An example that shows how to get a list of the names of each sheet in the workbook.
		-->
		
<!-- 
	CFX_XLSReader will read an Excel file and return it as a ColdFusion query. 
		Parameters:
			Action= read or getColumnNames or getSheetNames
			Sheets= the variable to put the list of sheet names into.
			XLSFile= the Excel file to read.
-->
<CFX_XLSReader ACTION="getsheetnames" sheets="theSheetNames" XLSFILE="#GetDirectoryFromPath(GetBaseTemplatePath())#\read2.xls">

<!-- The sheet names are returned as a list -->
<cfoutput>
	<ol>
		<cfloop index="ASheetName" list="#theSheetNames#">
			<li>#ASheetName#</li>
		</cfloop>
	</ol>
</cfoutput>
</body>
</html>