Skip to main content
kowsalyav7826
Brainy
Aug 12, 2024 3:08 PM UTC
Question

readexcelsheetpaging takes blank column

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
    Inspiring
    Aug 12, 2024 3:48 PM UTC

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

    kowsalyav7826Author
    Brainy
    Aug 12, 2024 4:01 PM UTC

    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
    Inspiring
    Aug 12, 2024 5:41 PM UTC

    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