Scribd Logo
Upload

Welcome to Scribd!

  • 2 views

    Excel Upload

    Uploaded by

    balaji babu

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Excel Upload

    Uploaded by

    balaji babu
    2 views20 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    2 views20 pages

    Excel Upload

    Uploaded by

    balaji babu

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 20

    Working with Upload Excel File

    If we want to work with upload excel document and process the data, we have to create below
    rules.

    1. Binary File
    2. Call activity to parse excel file (MSOParseExcel)
    3. Page List Proeprty.

    Requirement:-

    Upload commercial Vehicles Data from an Excel document.

    Implementation:-

    Use the existing page list property and Section.

    Create an Excel Template which is the Template for Parse Structure of Excel Data.
    Add braces to commercialvehicles to make this a s page list
    {.CommercialVehicles().VIN input}

    Save to desktop.

    Now create binary file rule.


    Upload the template
    Browse
    Click on Upload file.

    Save.
    Download it just to see weather template it property saved or not.

    Now, Proceed to Create an Activity which will parse the uploaded excel.
    Save.

    Save. Check in.

    Now open the section and modify it.


    Double click on button
    Change the control
    Add one more button to call the activity
    Submit

    Save. Run and test it.

    Before we test it, make sure we have an excel file created with some data
    Saved.

    Now create a case and upload the file.


    Click on upload.

    Data is uploaded.

    You might also like