Converting Excel Sheet to Excel File (and move to another folder)

Help Studio
, ,
1

Hi team,

I’d like to copy excel templates you see below to separate files and take them to a destination folder. So overall, I’d expect 4 excel files to be created from the spreadsheets you see and get dropped into my destination folder. Can anyone help me with an expression to do that?

image - 2023-05-20T131139.939
image - 2023-05-20T131139.9391042×218 46.1 KB

Please let me know if you’d need more information.
Thanks

2

@Sisay_Dinku

To convert an Excel sheet to an Excel file using UiPath, you can follow these steps:

  1. Open UiPath Studio and create a new project or open an existing project.
  2. Drag and drop the “Excel Application Scope” activity onto the workflow.
  3. In the properties panel of the “Excel Application Scope” activity, specify the path to the Excel file you want to convert.
  4. Drag and drop the “Write Range” activity inside the “Excel Application Scope” activity.
  5. In the properties panel of the “Write Range” activity, configure the following:
  • Input > WorkbookPath: Provide the path and file name for the new Excel file you want to create.
  • Input > SheetName: Specify the name of the sheet you want to copy from the original Excel file.
  • Input > DataTable: Select the DataTable variable that holds the data you want to write to the new file.

to move the file Use move file activity

3

I wanted the LINQ expression for the destination folder path plus Filename.

4

@Sisay_Dinku

Share input & output details, that you are excepting.

5

@Sisay_Dinku

For example, if you want to create the Excel file in the “Documents” folder and name it “NewFile.xlsx”, the code will be:

Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "NewFile.xlsx")