Skip to main content
williamm0010
April 20, 2022
Question

Integration Services -] Excel Tools -] Parse Excel to CDT

  • April 20, 2022
  • 6 replies
  • 0 views

New to Appian, have been through the developer training but have not taken the test yet.

I have a request to be able to upload a Excel file and then parse the data and insert into a table.

I have been looking at the Parse Excel to CDT to do this since this is the option our Appian has.

Trying to wrap my head around this and have been trying to find examples.

Does anyone by chance use this and is there documentation some place for this?

Does anyone have a sample process model showing the steps on how it was done?

Also trying to figure out the configuration on the plugin as well.

Basically the user will upload the excel file, then parse data from excel into CDT then use the CDT to write to the database.

Thank you for any help.

    6 replies

    mathieud0001
    April 20, 2022

    The included PDF documentation in the Excel Tools plugin might be helpful.

    community.appian.com/.../excel-tools

    williamm0010
    April 20, 2022

    Looked through the PDF for the Excel Tools from the link and this is a newer version than we are using and does not have the Parse Excel to CDT in it.  Trying to figure out how to get or find the documentation for the older 1.8 version that we currently use.  They are not wanting to upgrade the plugin if we do not need to.  Thank you

    mathieud0001
    April 20, 2022

    I would suggest you contact Appian Support for that info unless someone on community still has the old version handy.

    mikes0011
    Brainy
    April 20, 2022

    It seems to me like you might have the most luck with the "ReadExcelSheet" / "ReadExcelSheetPaging" functions available in Excel Tools.

    williamm0010
    April 20, 2022

    We may have to upgrade to the newest version then, currently we are on a older version and they where wanting to use it.  Thank you

    mikes0011
    Brainy
    April 20, 2022

    "ReadExcelSheet", as far as I know, has been in the plug-in for years.  Only in recent versions has it been replaced with "ReadExcelSheetPaging", but i believe either of these would work for you.