ColdFusion 9.0 Resources |
SpreadsheetReadDescriptionReads a sheet from a spreadsheet file and stores it in a ColdFusion spreadsheet object. ReturnsReturns spreadsheet object. CategoryMicrosoft Office Integration Function syntaxSpreadSheetRead(fileName [, sheetName|sheet]) See alsoSpreadsheetWrite, SpreadsheetAddColumn, SpreadsheetAddImage, SpreadsheetAddRow, SpreadsheetDeleteRow, SpreadsheetDeleteRows, SpreadsheetFormatRow, SpreadsheetFormatRows, SpreadsheetShiftRows HistoryColdFusion 9: Added the function. Parameters
UsageUse this function to read an Excel file with multiple sheets. Example<cfscript> a = SpreadSheetRead("C:\Files\Report.xls","Annual Report") </cfscript> |