Skip to main content
amritjyotiv3475
amritjyotiv3475
March 1, 2023
Question

How to split a large excel file into multiple files based on row count in Appian ?

  • March 1, 2023
  • 1 reply
  • 0 views

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?

1 reply

ayusha3676
ayusha3676
March 1, 2023

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.

Terms & ConditionsAccessibility statement