Skip to main content
Level 3
Jun 2, 2023 7:07 PM UTC
Question

fusion excel

Using Fusion, I need to:

 

1. Download an Excel file from a Workfront Project.

2. Update that Excel file.

 

3. Upload the Excel file back to the Workfront Project.

 

I can't figure out how to parse an Excel file and having the customer save the file as a *.csv is not an option.

 

Ideas?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Doug_Den_Hoed_AtAppStore
Community Advisor
Community Advisor
Jun 2, 2023 9:16 PM UTC

 

Hi @dabell,

 

For an idea (albeit not using Fusion), I invite you to consider our Excel Updater solution (which can also be scheduled, if desired).

 

Regards,

Doug

Translate
Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.
Murali_Vusthipalli
Jun 5, 2023 11:10 AM UTC

Microsoft 365 Excel module provides various functions to work with workbook and worksheet rows. The documentation it not upto date, but open the module in Fusion, you will see various functions available.

 

To upload a document into Workfront, you can use Workfront module's - Upload Document action

Translate
DaBellAuthor
Level 3
Jun 5, 2023 12:46 PM UTC

Thanks for the response.

The Office365 modules seem to only access/download documents from a Sharepoint cloud ...not Workfront. 

 

I can download this spreadsheet from Workfront, like any other document, using Fusion.  The issue is how do I use any of those Office365 modules with that downloaded spreadsheet.

Translate