Export file

Help Activities
,
1

I have the following problem: I have a file that I downloaded from an internal system.

But this file doesn’t have an extension. The way I open it manually is by opening the Excel file, opening, browsing, and selecting the “All Files” option in the filter. This opens the Excel import wizard, and that’s the only way I can open it.

How can I do this from UiPath?

image

2

@alexis.mendoza.rpa

Please perform below steps i think it will work

  • In UiPath:
  1. Use Read Text File activity → get the raw content.
  2. Use Generate DataTable activity to parse the text into a DataTable(you can specify column separator , column names, etc.).
  3. Work with it as structured data inside UiPath (same as Excel).
  • If you want to see it in Excel later, use Write Range (Excel or Workbook) to output to .xlsx.

Regards,
Rajesh Rane

3

Hello @alexis.mendoza.rpa You can use Start Process activity and set FileName as "excel.exe" and Arguments as "C:\Path\To\Your\File".
OR
If you know it’s actually a CSV, TXT, or similar text format the use Copy File activity and rename file to include an extension like
C:\Path\To\Your\File to C:\Path\To\Your\File.csv
Then use Read CSV or Excel Application Scope in UiPath to read file.

Cheers

4

Hi, @alexis.mendoza.rpa Just rename the file and add “.xlsx” or “.csv” to the end of the filename using a Move File activity, then read it with Excel activities as usual. This matches what you do manually and works reliably every time in UiPath.

5

Doing this does not work manually.

7

@alexis.mendoza.rpa use UiPath’s UI automation to open Excel, click “Open,” select “All Files,” pick your file, and walk through the import wizard using Click and Send Hotkey activities.

8

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