Hello,
I Want to access particular sheet in excel file as the file will contain multiple number of sheet. Unique thing in the sheet will be the column Names
Discussion posts and replies are publicly visible
What attempts have you made? The Excel tools plugin contains smart services and functions that have sheetNumber as an attribute.
https://community.appian.com/b/appmarket/posts/excel-tools
Hi ,Requirement is to read multiple sheets from excel and based on certain calculations, need to generate output excel with multiple sheets.
Is there any function to read total number of sheets in the excel ?
readexcelsheet() returns a success boolean, and on failure an error message with the valid bounds for the sheet numbers. You might be able to use that.
yes but is there any way directly can get the total no of sheets i the give excel document.
what should be the default sheet number in readexcelsheet() function to get error case