Skip to main content
K
kowsalyav7826
August 12, 2024
Question

readexcelsheetpaging takes blank column

  • August 12, 2024
  • 5 replies
  • 0 views

hi, 

I am using the function to extract the data from excel sheet 

readexcelsheetpaging(
excelDocument:ri!excelTemplate,
sheetNumber:0,
pagingInfo:a!pagingInfo(
startIndex:0,
batchSize:1000
)

).data

This is returning additional blank column. Let me know where i went wrong . 

    5 replies

    konduruc733182
    konduruc733182
    August 12, 2024

    Very unclear what is happening here. Could you please share a proper SS of this output and also the input Excel doc.

    K
    kowsalyav7826Author
    August 12, 2024

    Sure, some more background, I have three sheets in the work book and extracting all the sheets , the above code, i am trying to test for sheet 0, it returns all columns perfectly , but the issue is it also extracts additional blank column. and this is same for all sheets 

    konduruc733182
    konduruc733182
    August 12, 2024

    Just index the columns which have data in them into the dictionary. I think that should suffice. Or you can define the numberOfColumns as Baji babu mentioned.

    For a better answer I would request you to share the code that you wrote to build the dictionary/map. Mostly it would be an auto detect error in the function.

    Terms & ConditionsAccessibility statement