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
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