Can someone provide me the reason why i am not able to return data from excel using readexcelsheetpaging()

avinash

Certified Senior Developer

over 3 years ago

readexcelsheetpaging(
    excelDocument:cons!BOOK_4,
    pagingInfo:a!pagingInfo(1,-1),
    sheetNumber:0,
    numberOfColumns:4
    
    
  )

Discussion posts and replies are publicly visible

Top Replies

avinash over 3 years ago in reply to ranjith.shanmugam +1
Certified Senior Developer

i have resolved the issue but here in my code the problem is not with a!pagingInfo(1,-1) since my excel sheet contains only 6 rows and also i have tried with a!paginginfo(1,6) and got error but i have…

Parents

0 gayathris876948
Certified Lead Developer
over 3 years ago
Try giving like

pagingInfo:a!pagingInfo(1,50)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 gayathris876948
Certified Lead Developer
over 3 years ago in reply to gayathris876948

https://community.appian.com/b/appmarket/posts/excel-tools

This discussion says its not supporting -1.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Reply

0 gayathris876948
Certified Lead Developer
over 3 years ago in reply to gayathris876948

https://community.appian.com/b/appmarket/posts/excel-tools

This discussion says its not supporting -1.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Children

No Data