How to check whether the files are in excel or text files

Help Studio
, ,
1

Good day
I’ll be receiving files by email, so before allocating them, I’d like to verify whether they’re in excel or text format…if they’re in text, I’ll need to convert them to excel…Please assist…Thank you.

2

Hi @pabaleloh

After saving the Outlook Attachment. You can check the extension by
Path.GetExtension(AttachmentFilePath)

  • If the file extension is .txt, read the text data using Read Text File activity and then write this data into an Excel file using Write Range activity.

Hope it’ll helps you :slight_smile:
Cheers !!

1 Like
Forum Engagement Daily Reports
3

@Nawazish_Ahmad Thank you so much

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.