Highlighted

cfspreadsheet - need to access cell values on a different sheet

New Here ,
Jul 26, 2017

Copy link to clipboard

Copied

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

Views

244

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

cfspreadsheet - need to access cell values on a different sheet

New Here ,
Jul 26, 2017

Copy link to clipboard

Copied

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

Views

245

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jul 26, 2017 0
LEGEND ,
Jul 26, 2017

Copy link to clipboard

Copied

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 functions

HTH,

^ _ ^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 26, 2017 0