Skip to main content
August 8, 2023
Question

read excel cells by name

  • August 8, 2023
  • 1 reply
  • 0 views

Hi,

I'm trying to read a cell value using function excelreadcellsbyname but i'm getting below error when trying to read a cell value. 

can anyone please  help in fixing this issue

input : excelreadcellsbyname(640958, { 2 }, { "F9" }),

output : Expression evaluation error at function 'excelreadcellsbynumber': The column Value of long (+ve) position doesn't exist in table INVFI

1 reply

August 8, 2023

Hi, When I am trying to replicate the scenario it is working fine from my end. The error caused might be due to the length or type of the data present in that particular cell. Can you please share what is the data provided in that particular field or length of the data in that particular cell to understand the issue