'= asterisk since it italicizes instead of showing. I am using the Excel module. To locate the row of the data I am using in BAS, I FIND ALL CELLS that match my variable. It returns 0'23 in the Found Cells List. For one, it's actually row 24, so I have to add 1 to the row to get to the proper record. My goal is to locate record in column A using variable, then update column B, so to make it correct, I need to 1'(23+1).
When I try to parse list as instructed with an asterisk "*", it returns: Result of expression '(VAR_XLSX_FOUND_CELLS_LIST).split' [undefined] is not a function. during execution of action
@jmoneyy, Read the description before using the actions.
The action "Find all cells" returns a list with all found addresses, use the actions of the "List" module to get the required address from the resulting list, or use the action "Find single cell" to get the first found address.
Actions return an address in the format that all actions of the module accept, namely, column and row indices separated by *. The index is not equal to the number since the index starts from 0, and the number starts from 1.
@jmoneyy, xlsx_find_cell.xml is a simple example using both actions to find a cell
@GhostZ Thank you so much for your reply and help. Yes, I read the instructions. I saved as a list and all that and still got errors because I didnt know to use First Element instead of a regular list.
This clarifies everything!
And i get that it's an index but I dont understand why when all actions would definitely utilize the row so it requires an extra step.
But i know nothing lol
Thanks!
