Excel: Insert data table into Excel template - does template need to be a pushbot level field?

Options

I am building a workflow in which an Excel file is downloaded from Sharepoint, then data is added to this Excel file, and lastly it is re-uploaded to Sharepoint. Since I did not have Sharepoint integration experience, I first was working on the many steps for "adding data" to the Excel, and just started with the Excel file as a "pushbot level field" (i.e. to get around not knowing the Sharepoint actions, the workflow at first did not download anything from Sharepoint, the Excel file was already in the workflow as a default value in a pushbot level field). So I got the "adding data" steps to work smoothly, and then I separately worked on and successfully built the Sharepoint download and upload steps. Now when I add the Sharepoint download step at the front end and have the workflow use the downloaded Excel file instead of the default file from the pushbot level field, the Action: Excel: Insert a data table into an Excel template (which I use as part of the "adding data" steps) throws the following error: "The action was unable to process this spreadsheet. Please contact Catalytic at help@catalytic.com."

Question: Does this Action only work with Excel files that are in a pushbot level field? I kind of think so because of the word "template" in the Action name. I am not really using a template, it is a file that is downloaded within the workflow in a previous step.
Thank you!

Tagged:

Answers

  • Jozef_783863
    Jozef_783863 Posts: 331 admin
    edited May 2020
    Options

    Hey @Kevin_579059, you are question #200. Nice! B)

    I took a closer look at your particular case. Resaving the file (on the computer) and retrying the fix issue task worked. So this appears related to the file itself.

    Can you try using a csv file in SharePoint and Excel: Insert a data table into an Excel template?

    I will take a closer look as to what happened with the xlsx file.

    Usually you store the input file for Excel: Insert a data table into an Excel template in a workflow level field. You can also store this file in a fields list like Email: Send a Form. (You would make the individual field condition true = false.) Sometimes the file is in a data table and you have Tables: Look up step first to get a template file based on a certain look up criteria.

    Workflow Level Fields
    https://help.catalytic.com/docs/pushbot-level-fields/

    Excel: Insert a data table into an Excel template
    https://help.catalytic.com/docs/excel-insert-a-data-table-into-an-excel-template/

  • Kevin_579059
    Options

    Jozef, thank you for your reply. I substituted the .xlsx file with a .csv file, and the workflow worked. What could be going wrong with the .xlsx file? It is very small, only a few words typed into the first sheet...