Hello,
I'm using excel plugin tools and i can read excel databut i don't need null of row so i want to delete null row.I tried to loop list of text string but cannot get it.How can i convert list of text string to list.
here is my test rest of screen shot
here is my excel data image
Discussion posts and replies are publicly visible
Could you share your existing code? Below is a simple example. Can give a cleaner code if your code is available here.
a!localVariables( local!doc: ri!doc, local!data: readexcelsheetpaging( excelDocument: ri!doc, sheetNumber: 0, pagingInfo: a!pagingInfo(startIndex: 2, batchSize: 5000) ).data.values, local!formatData: a!forEach( items: local!data, expression: { if( a!isNullOrEmpty(fv!item[2]), {}, a!map( id: fv!item[1], name: fv!item[2], gender: fv!item[3], department: fv!item[4], tech: fv!item[5] ) ) } ), local!formatData )
Konduru Chaitanya
Thank you so much for your help. It work for me