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 .
Discussion posts and replies are publicly visible
Very unclear what is happening here. Could you please share a proper SS of this output and also the input Excel doc.
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
Hi kowsalyavijayan
Please go through the below screenshot
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.
okay , I will try