How to select a specific column in excel based on the excel file name

Help Studio
, , , , , ,
1

Hello All,

I am new to UiPath. I am trying to extract data from unstructured excel file (the data in excel will be shifted every time the file is created). The only unique condition which i can use is the file name (which contains the month). I have an requirement to extract the data for that month from excel based on the file name.

In file name contains date like "05/05/2020.xlsx. The data in excel contains “May-20”. Is there a way i can achieve this in UiPath? After identifying the data i need to create a new excel file for May-20.

Please advise.
Roni.

2

Please share screenshot of input file and also what you want?

3

Hi Shubham,

Thanks for the reply. Attached is the sample excel. I want to extract data only for May-20 column in another excel (based on the file name this will change every month).

Roni.

4

I am trying to upload the file but getting error new users can not upload the file.

5

File Name will be like - Statement20200526.xlsx

Data will be like in excel file. I need to pick the data for May-20 only and create a new file.

            Apr-20	       May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20

Data1 1,000.00 71.35

6

Statement20200526.zip (10.6 KB)

7

excel file uploaded

8

Hi @roni_dutt

The Excel file which you have shared, the same data format will be der inside for all excels with different date as a file name as it is der for the shared file i.e., “Statement20200526” ??

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

10

Hi @roni_dutt

It is much hard to work ok such unstructured excel then also i tried but in May column the actual values are way different and many more.

As per logic i did everything but it is picking the data automatically half from another column and half from the column which it is working on. You may have a look on the workflow once.

Below is the workflow files.
Solution for Forum.zip (87.5 KB)

I dont think it will completely meet your requirements. But if it is then definetly mark it as solution and like it.

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

11

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