• State Not Answered
  • +1 person also asked this people also asked this
  • Replies 6 replies
  • Subscribers 9 subscribers
  • Views 9573 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

How to parse Excel data into Appian objects?

saic929

 Hi,

I am using 18.3 version. My requirement is to parse data from excel and display it in a report.

But in 18.3 version, I could not find 'Import CSV to Database' smart service.Which smart service/function should I use ? Please let me know how can I achieve this.

Step by step explanation of design would be of great help.

 

Thanks,

Saicharan

  Discussion posts and replies are publicly visible

Parents
  • 0
    Hey Sai,

    -You can find the 'import CSV to Database' smart service in the smart service palette under Excel tools section.

    OR

    -if you need Appian intervention in between you can use the below function

    readexcelsheet(
    excelDocument:ri!doc,
    sheetNumber:0,
    startRow:0
    )

    -ri!doc will be your Excel document which you can send from process model to your rule.
    -By setting sheetNumber, startRow you will be esured to read the whole excel sheet for the specified sheet.
    -This would return a dictionary which you can store it later into DB.
Reply
  • 0
    Hey Sai,

    -You can find the 'import CSV to Database' smart service in the smart service palette under Excel tools section.

    OR

    -if you need Appian intervention in between you can use the below function

    readexcelsheet(
    excelDocument:ri!doc,
    sheetNumber:0,
    startRow:0
    )

    -ri!doc will be your Excel document which you can send from process model to your rule.
    -By setting sheetNumber, startRow you will be esured to read the whole excel sheet for the specified sheet.
    -This would return a dictionary which you can store it later into DB.
Children

© 2024 Appian. All rights reserved.