How to Convert the attached text file into Excel format

studio

#1

How to Convert the attached text file into Excel format… for example the file contains lines like 0123456|kavya chenna|T|01/20/2018|0082|Eagle group|csv to excel|vew vvfb|064|00322|Warehouse ?
"|" seperated data should be each column in the excel file


#2

Hi @kavyachenna,

For Example: strValue = 0123456|kavya chenna|T|01/20/2018|0082|Eagle group|csv to excel|vew vvfb|064|00322|Warehouse

  • DtOutput (variable type DataTable)
  • arrValue(variable type String[])
  • Using Assign activity arrValue=strValue.Split("|")
  • Then using For Each loop through it
  • inside body use Add Data row activity append the value to datatable.
  • after completing loop using write range append the data to Excel

Regards,
Arivu


#3

can u explain briefly plzz

Regards,
jahnavi.


#4

hi guys,

can u explain flow for assign ment 2 how to start up the flow please explain .

Regards,
Jahnavi.


#5

Are you talking about Academy Assignment Generate Vendor Reports?


#6

ysss


#7

You have to create two REFramework projects, if you go through the PDD file, you will understand this better.

  1. Dispatcher - this workflow will get the WI4 work items per page from ACME Test application and will add all items in Orchestrator queue.

  2. Performer - This workflow would take one queue item at a time and process it by downloading reports and uploading the IDs in Update Work items.

  3. After completing these two Zip both of your workflows and upload on Academy and wait for evaluation.

Thanks,
Prankur


#8

tanqqq so much

Regards,
jahnavi.


#9

Hi,
please tell me the clear demo on uipath assignment level3 wa is the process wat u have to done is der ay shortcut dto do dat
Regards,
jahnavi.


#10

hi ,

assignment 2level3 , wat is this error can u please explain it.

Regards,
Jahnavi.


#11

Did you enter the process name to kill in the Kill Process properties


#12

yess


#13

Can you click on Kill Process activity and show me screenshot of its properties what you have enter


#14


how we will get this selector string code

selectors is not showing this in-ransation number .
how to get this …
Regards,
Jahnavi.