read excel cells by name

Question

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

harshitham3563 · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO