Expand my Community achievements bar.

The Community Advisors application is now OPEN for the second class of 2024. Apply to become a part of this exclusive program!

fusion excel

Avatar

Level 3

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?

3 Replies

Avatar

Level 10

 

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

Avatar

Level 1

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

Avatar

Level 3

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.