Skip to main content
Known Participant
Jun 28, 2023 11:25 AM UTC
Question

readexcelspreadsheettocdt()

Q1.  what is role of readexcelspreadsheettocdt in appian?

Q2. what  function should I used in place  readexcelspreadsheettocdt. It is deprecated?

    1 reply

    stefanhelzle0001
    Brainy
    Jun 28, 2023 11:42 AM UTC

    I suggest to do an Excel import in two steps. Use the excel tools plugin to stream data to a database table. Then use a stored procedure to transform the data into its final form.

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