Writing .tsv excel file?

Help Studio
, ,
1

Hi,

I need to read a range and the write it into a .tsv excel file.
Using write range activity, UI Path throws an error: Only .xlsx format supported.

2

Hi @Bhanu_Rathore ,

i hope i understood your query well. you have used read range to read the .XLSX file inside the Excel not from the Workbook. please check it once. whether you selected read range inside the excel not from the workbook. please find the image below !

ReadRange|286x344

and if you wants to write in to an excel file i hope you were used Excel Application scope inside this you need to use Write range
write range

your entire workflow should look like this

excel application scope
excel application scope511×667 14.8 KB

and i have used write range to write the data into excel. if you wants to writr into csv just drag and drop write csv. you can find only one write csv activity.

if you have any queries please let me know

Thanks&Regards
NaNi

3

Am I right to suppose you just call it an Excel file, but in fact it is a CSV file with Tab delimited?
Then this is what you want:
https://docs.uipath.com/activities/docs/write-csv-file

4

Hi, @moenk @THIRU_NANI

Yes. I did the right thing. But its a .tsv file (not csv)

I can open .tsv through notepad as well and paste the excel data into it using copy to clipboard activity. But there are commas in the pasted text.

So now im stuck at this point: How to read a range and paste it into a notepad (without commas)

Files attached:

FIles.zip (7.3 KB)

5

Hi! @Bhanu_Rathore,

Do one thing after you copied the text. use Regex(Replace) activity.

please refer How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

Regex(Replace) you can see the activity below

ReGeX

i extracted your text it will select all the commas inside the text please refer the below image

COMMA

please make some changes in your replace activity

RegEx-Advanced Value_field just use symbols- backward slash with comma (This will select the every comma in your text) dont make any changes then save it. this will remove all the commas which is present in your entire text.

Thanks&Regards
NaNi

6

Hi @THIRU_NANI

Could you please attach xaml here?

7

Yes you can. i just have used your output text to select the commas to show how exactly that activity works. you have your output file right. below that output file use RegEx activity. then save it.

Thanks&Regards
NaNi

8

Thanks for your reply @THIRU_NANI

Replacing the comma would change the outlay. I need to upload this file and if i replace then the portal where i need to upload it, will not accept the file.

-I just need to select whole data in sheet (ctrl + A)

  • Copy the data
  • and paste it in that standard format in notepad
9

Hi @Bhanu_Rathore

i have created your workflow please check below. i regret to inform you that i couldn’t find the .tsv format. i just write in to .txt file.

please find the attachment below.

Main file:
Main.xaml (7.1 KB)
Input file:
Input Excel file.xlsx (8.6 KB)
output file:
Op.txt (1.6 KB)

if you have any queries please let me know and if this works for you mark this as solution.

Thanks&Regards
NaNi

10

Hi @Bhanu_Rathore

This video could help you: UiPath | Read CSV File | Add Column to CSV File | How to read CSV File and Add Data Column to CSV - YouTube
Or this video: UiPath | Convert Text File to CSV File | Get Data from Text File into CSV File | Create CSV File - YouTube

Best regards
Mahmoud

11

Hi @THIRU_NANI

Thanks a lot for this. But i need output (.txt) in this exact format (see attached file).
(Try to compare your output with the attached file)

This format in text file i get only when I paste the whole data manually.
output.txt (1.6 KB)

12

Hi @Bhanu_Rathore

In RegEx i just gave only one space instead of two spaces. u can find that in Replace Activity in the properties check the Replacement section i just given 1 space inside the QUOTES. try to give 2 spaces. if still u couldn’t get the perfect output which is there inside the Output.txt. just increase the spaces.

i hope this will works for you.

Thanks&Regards
NaNi

13

You just need to select Tab as delimiter in write CSV Activity.