Skip to main content
A
avinashv252039
August 19, 2021
Question

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

  • August 19, 2021
  • 4 replies
  • 0 views

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

    4 replies

    gayathris111098
    gayathris111098
    August 19, 2021

    Try giving like

    pagingInfo:a!pagingInfo(1,50)

    gayathris111098
    gayathris111098
    August 19, 2021

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

    This discussion says its not supporting -1.

    ranjiths0003
    ranjiths0003
    August 19, 2021

    hi avinash,

    readexcelsheetpaging paging info behaves differently try to use a!pagingInfo(1,10), because a!pagingInfo(1,-1) returns 0 data.

    A
    avinashv252039Author
    August 19, 2021

    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 found that this plugin is only accepting parameters in same order as they defined even using keyword syntax

      Terms & ConditionsAccessibility statement