Need to format excel

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.


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


1 Like

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.

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.

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

can you please share .xaml file?

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

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.