cfspreadsheet - need to access cell values on a different sheet

Question

HI all,First off, thanks for any help you can provide.I'm using cfspreadsheet to create an xls report. One of the sheets (xls tabs) has a summary report which will display some values from different sheets. I see that there is a function to get cell values - SpreadsheetGetCellValue(spreadsheetObj, row, column) - this seems to only get values from cells on the same sheet.Am I overlooking something?Thanks

WolfShade · Answer

Hi, joely276175​,No, you're not overlooking anything. You can interact only with whichever sheet is 'active', at any given time.If you know the name of the tab, or the position index of the tab, and which cells have what information you seek, you can set that tab as active, get the information and save to variables, then switch to whatever tab you want and continue.SpreadsheetSetActiveSheet()SpreadsheetSetActiveSheetNumber()Spreadsheet functionsHTH,^ _ ^

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded