Need to format excel

Help Studio
,
#1

Hi all,Input file.xlsx (9.9 KB)

I am new to Uipath. I need help in formatting excel and save the output in a specific folder with the same name. Also I will have multiple files in as input and need to format the output in the same format and save the files in same folder.

#2

@Sachin_07

Welcome to forums

Check below post for your reference

RPA DataTable: Get Previous Row Column Value, Set to Current Row Column Value

Mark as solution if this helps

Thanks

1 Like
#3

Hi ksrinu070184,

Thanks your reply. Like mentioned I am new and learning many things now. This video covers only 50%. I need run this task for multiple files, and also sheet names are different, and file name as well. Also I need to save these files in different folder. And also delete few rows. Also getting this error.

image
image811×91 4.43 KB

#4

This error means that your variable FSLI is not a number or a string… Change its type to match what you have as value, you can select the row column by index number or by name.

#5

I changed to string in variables below.
image
Getting this error now
image

#6

Untitled
Untitled1068×1392 120 KB

#7

can you please share .xaml file?

#8

Main.xaml (18.3 KB)
Please check this demo file,
if it works, please mark it as resolved.
Regards.

#9

Hi WangJidong,

Sorry for delay in reply as, I had to prioritize other task. It is working fine but I have only one more issue. I have few rows in between. WHen I try to filter, duplicate line items are getting created. I am attaching the updated input.Input file.xlsx (9.8 KB)

Thanks for all your effort.