Upload excel data in activity directly without using binary file

General
, , ,
1

Hi Team

We have a requirement to upload excel file directly without using binary file. We are not using any screens for this. We are having CDH framework where we dont use any screens or usecases. Please suggest how we can upload excel directly in activity and get those to clipboard. Thanks in advance.

2

@PrasadN16719109

  1. Create a File Listener: Set up a file listener to monitor a specific directory where the Excel files will be placed. This listener will trigger an activity when a new file is detected.

  2. Parse the Excel File: Use the MSOParseExcelFile activity to parse the Excel file. This activity reads the Excel file and converts it into clipboard data.

  3. Process the Data: In the triggered activity, process the parsed data as needed. You can map the data to specific properties or use it directly from the clipboard.

Here is a high-level outline of the steps:

  1. File Listener Configuration:

    • Create a file listener rule.
    • Specify the directory to monitor.
    • Set the file pattern to match the Excel files.
    • Configure the listener to call a specific activity when a file is detected.

  2. Activity to Parse Excel:

    • In the activity called by the file listener, use the MSOParseExcelFile method.
    • Provide the necessary parameters, such as the file path and the template to use for parsing.

  3. Processing the Data:

    • Once the Excel file is parsed, the data will be available on the clipboard.
    • Use the data as needed in your activity, such as mapping it to specific properties or performing calculations.

Here is a sample code snippet for the activity:

// Step 1: Parse the Excel file
MSOParseExcelFile
  FileName: "path/to/your/excel/file.xlsx"
  Template: "YourTemplateName"

// Step 2: Process the parsed data
// Access the parsed data from the clipboard and process it as needed