Hi, i have a requirement to extract a particular cell(integer) from an excel sheet the specified cell is in G column 46th row. Please update on the solution.
Discussion posts and replies are publicly visible
Hi, have you tried using the readexcelsheet function and trying to index the particular column.
readexcelsheet(excelDocument: cons!AKS_BANGHY,sheetNumber: 0, startRow: 48)
this is the code I have been using for this issue.
Hi check the below code I have mentioned comments on how to use
index( readexcelsheet(cons!UD_FILE_EXAMPLE_XLS_10, 0, 0),/*read sheet*/ "result",/*index result*/ 3,/*index row*/ "values",/*index values at row*/ 4,/*index column number you want to get*/ {}/*default value*/ )