Create Excel file and upload to SFTP

[Mike710]

Hi Guys, 

Any advice would be highly appreciated.

What would be the best workflow to Read the Excel file (Specific Tab) and generate the .xlsx file and upload it to SFTP?

I appreciate any help you can provide. 

[danilang]

Hi @Mike710 

Check out the post here.  It contains a solution that creates a file and then converts it to a blob and uploads it to an FTP site.  It includes a synchronization step to ensure that the file is completely written before the Blob Input tool starts reading the file.

Dan 

[Mike710]

Hi @danilang 

Thank you for your reply.

I have two questions after using the solution you referred to. 

1) I was reading data from .xlsx and reviewed a temp file that the process created. However, that is not in the correct format. The header is just the first character, and the layout is also improper.

2) I get an error when uploading into SFTP "Error in the SSH layer."

Any advice? I appreciate any help you can provide.