Create a new file for only one column in excel with date name

Help
, ,
1

I have 4 columns and the fourth column is the one with the header of results. What I need to do is to create a new file with the date name yyyy-mm-dd. I just need to extract the last column from the others and create a new excel file with only that column. I am struggling to do so. Because uipath has no feature to create new excel file. But just a creaTe file. And I don’t know how to move forward

2

Hi do u only need to create file only ? @jatin_pachisia

Then iterate through the each row of excel file and uisng create file activitiy create the file with file name along with file extension ie .xlsx

3

@NIVED_NAMBIAR yes s. It’s file only. But do I need two excel application scopes ? Because I need to take the column from the current excel and use that in the new file

4

Hi then try this way

  1. Read the excel file and store in dt1
  2. Loop through each rows of dt1 using for each row
    Inside the for each row use create file activitiy to create file

May I know the file naming?

5

@NIVED_NAMBIAR I have uploaded two files in my previous topic. Can you check that ? Would be a huge help. That has the files

6

The file has to be named as yyyy-mm-dd_Results @NIVED_NAMBIAR

7

So I use excel application scope and enter the path of my excel. Then I use the read range and select the column I want. In my case E1:E10. Then I create a variable and store it as a data table. Then I create a for each row and then I create the file inside ? Would it be possible for you to show ? @NIVED_NAMBIAR

8

@NIVED_NAMBIAR

uipath task
uipath task929×334 78.5 KB
Calculus.xlsx (15.4 KB)
Its the 4th question and the final result column is waht i need