We have a requirement in which Excel File is having more than 350 columns and more than 15k rows. We want to split this file into 2 files for further processing based on rowcount.
Have anyone implemented this kind of functionality in Appian?
Discussion posts and replies are publicly visible
excelreadcellsbynumber( exceldoc:todocument(ri!doc), sheetNumbers:{1}, columnNumbers:enumerate(350)+1, rowNumbers:enumerate(1000)+1 )
You can specify count of rows and count of columns.