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.

@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

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.
image
Getting this error now
image

can you please share .xaml file?

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