I have created an automation that in the block get tabular report generate my excel report. After the generation of the report with the blocks "S3 create file" and "Write Line to file on amazon s3" generate a xlsx file inside the S3 Bucket. It seems that all works correctly, but when I try to download the excel file from the bucket, I cannot open it, because results corrupted. If i try to open the same file in excel online 360 it work correctly. How is it possibile ? i have to setup some encoding o specific file format ?
Hi @Nin_04 I suspect that the “Write Line to file on Amazon S3” block is writing raw text to the file, so the content saved in .xlsx format is actually a .csv. Excel on-line can read at open it but maybe it is not possible when you download the file. Could you, please, rename the file you download with a .csv extension? Are you able to open it as CSV?
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up ! 🙂
Hi @Nin_04 I suspect that the “Write Line to file on Amazon S3” block is writing raw text to the file, so the content saved in .xlsx format is actually a .csv. Excel on-line can read at open it but maybe it is not possible when you download the file. Could you, please, rename the file you download with a .csv extension? Are you able to open it as CSV?
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up ! 🙂
thanks for your answer. I had already tried generating a CSV file, but Automation returned an error because (I assume) the "get tabular table" block can only generate Excel or PDF, so the output might not be compatible with the "write Line" block. Inside that block, I insert the "get tabular report" output. Perhaps my error is due to something else, so I'm open to suggestions. The only mandatory thing is that the output file in the bucket must unfortunately be Excel.
