Create Excel file and upload to SFTP

Question

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.

Mike710 · Answer

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.

danilang · Answer

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