(Example) Configure an Excel Read Activity

Result

This example shows how to add and configure the Excel Read activity in Sales Invoice app and read the data from a Microsoft Excel file.

When you add the Sales Invoice app from the App Store to the App Builder, and open the process, it looks like this:

When you complete this example procedure, the finished process looks like this:

When you create the Microsoft Excel file, it looks like this:

The fields of the Requester Details section read the data from the Sales Invoice.xlsx template and show in the form.

Prerequisites

• This example uses the Sales Invoice app from the AgilePoint NX App Store.

  For more information, refer to How to Get the App

• Create an access token for Google Drive. In this example, the access token name is Read Excel Data.

  For more information, refer to Access Token for Google Drive.

• You must have Google account.
• Upload your Microsoft Excel file — Sales Invoice.xlsx in this example — to the Google Drive folder you want to use for your app.

Good to Know

• The Sales Invoice app is a process-based app that creates an invoice for a sale.

  For the use case in this example, this app provides a form to enter information for the invoice. The invoice request is then routed to the Excel Read activity, which retrieves customer information from a Microsoft Excel file to use in the app.

• This example uses the Excel Read activity in the Document tab. There are also versions of the Excel Read and Excel Write activities in the SharePoint tab. In general, examples are not provided for most third-party intergrations, including SharePoint. For information that is specific to the SharePoint versions of these activities, refer to Where Can I Find Information and Examples for Third-Party Integrations?

Good to Know

• This app uses the same Microsoft Excel file at design time and runtime.

How to Start

1. Open Microsoft Excel.
2. Click Blank workbook.
3. Save an Excel file with the file name Sales Invoice.xlsx.

Procedure

1. In the Sales Invoice.xlsx file, enter the column names in this table:

   Column Names
   Account Name
   E-mail ID
   Phone
   Cutomer PO Number
   PO Amount
   Payment Terms

   
   
   

2. Enter the values for each column as shown in this table:

   Column Names	Column Values
   Account Name	Bob
   E-mail ID	bob@abc.com
   Phone	876298651
   Cutomer PO Number	4566
   PO Amount	2000
   Payment Terms	Net30

   
   
   

3. Name the cells that contain the data you want to retrieve to show on the form.

   Each cell from which you want to read data must have a name. For this example, use the names shown in this table.

   Cell Values	Name
   bob@abc.com	EmailId
   876298651	Phone
   4566	CustomerPoNumber
   2000	PoAmount
   Net30	PaymentTerms

   1. Select the Bob cell.

      
      
      

   2. In the Name Box, enter AccountName in name the cell.

      
      
      

   3. Repeat these steps for each cell.

How to Start

1. Click Build Apps .

   
   
   

2. On the Application Explorer screen, on the My Application pane, click Sales Invoice > Processes > Sales Invoice > Process Model > Sales Invoice.

   
   
   

Procedure

1. On the Document tab, drag the Excel Read activity onto your process.

   
   
   

2. On the General Configuration screen, in the Display Name field, enter Read Sales Invoice Excel.

   
   
   

3. Click Next.
4. On the Source Repository screen, select Google Drive.

   
   
   

5. Click Next.
6. On the Design Time Template Configuration screen, in the Google Drive list, select the access token Read Excel Data.

   
   
   

7. In the File Path section, select Choose File Path > Sales Invoice.xlsx.

   As a prerequisite, Sales Invoice.xlsx must exist in Google Drive.

   
   
   

8. Click Next.
9. On the Runtime Repository screen, select Google Drive.

   
   
   

10. On the Runtime Template Configuration screen, in the Google Drive list, select Read Excel Data.

    
    
    

11. In the File Path section, select Choose File Path > Sales Invoice.xlsx.

    
    
    

12. Click Next.
13. On the Excel Read Configuration screen, in the Fields Mapping field, click Schema Mapping .

    
    
    

14. On the Schema Mapper screen, map the cells in the Excel file to the entity fields as shown in this table.

    These entity fields are associated with form controls in the Sales Invoice app.

    Excel Template Cell Name	Form Fields
    AccountName	AccountName__u
    CutomerPoNumber	CutomerPONumber__u
    EmailId	EmailId__u
    PaymentTerms	PaymentTerms__u
    Phone	Phone__u
    PoAmount	POAmount__u

    
    
    

15. Click Finish.

    The Process Builder shows with Excel Read activity.

    
    
    

Procedure

1. To validate a process, refer to Validate a Process.
2. On the Save quick menu, click Save and Check In .

   
   
   

Next, publish the application so people can use it.

Procedure

1. To publish the app, refer to Publish a process-based application.
2. To run the app, refer to Start your process.
3. Complete your Sales Invoice Request form and submit the form.

   
   
   

4. On the My Tasks tab, open the Finance Manager Approval task and complete the eForm as necessary.

   When you open the task, the Requester Details section on the Finance Manager Approval form shows the data from these columns specified in the Sales Invoice.xlsx Microsoft Excel file.

   • Account Name
   • E-mail Id
   • Phone
   • Customer PO Number
   • PO Amount
   • Payment Terms

   For more information, refer to Open a Task.

   
   
   

Prerequisites

• AgilePoint NX OnDemand (public cloud), or AgilePoint NX PrivateCloud or AgilePoint NX OnPremises v7.0 or higher.

Good to Know

• This procedure is optional. It is provided so you can test the example with an out-of-the-box app.
• This is part of the Background and Setup procedures, but many users preferred this step to appear after the example, not before it.

Procedure

1. Click App Store .

   
   
   

2. In the CATEGORY section, click Sales.

   
   
   

3. Click the Sales Invoice app.

   
   
   

4. On the Sales Invoice screen, click Add.

   
   
   

5. On the Trust App screen, click Trust it.
6. Click Return to site.