Loops through worksheets Excel

[ZerMahlMeer]

Hello,

I tried to loop through the worksheets in and Excel doc by increasing the work sheet handle. But unfortunately that does not seem to be possible and I got an error.

	ExcelRpt_SetWorksheetAttribute(rawDataWorkSheetHandle,ER_WS_ATTR_NAME,"Analysis Data");
	__caErrChk(ExcelRpt_SetWorksheetAttribute(rawDataWorkSheetHandle+1,ER_WS_ATTR_NAME,"something")); 

Is it somehow possible to do that? I don't like haven a handle for every worksheet in my workbook..

Thanks!

[ebalci · Accepted solution]

Hi,

Like it or not, you need to get the worksheet handle if you want to access worksheet attributes.
There is a function named ExcelRpt_GetWorksheetFromIndex for that purpose.

This function outputs the worksheet handle if you provide its 1-based index.
Beware that You have to call CA_DiscardObjHandle after you are done with that worksheet.

So both functions above should be inside your for-loop.