Template For Excel is not getting applied while excel is created

Help StudioX
, ,
1

My Excel Path is made up of Today’s date.
My Template Excel has sheets , renamed but when i run and create new excel, it doesnt have the formatting done.

image
image666×559 17.3 KB

Please guide me

2

@PAJ1999

Did you select the sheet from the template file in write range?

Can you show how you configured it

cheers

3

HI @PAJ1999

There could be several reasons why this is happening. Here are some things you can try:

  1. Make sure that the template file is in the correct format and that it is compatible with UiPath.
  2. Check that the template file is located in the correct folder and that UiPath can access it.
  3. Ensure that you have selected the correct template file in UiPath.
  4. Check that there are no errors or issues with your Excel application scope activity.
  5. Try using a different Excel application scope activity to see if this resolves the issue

Regards
Gokul

4

Template and Excel both have ‘.xlsx’
I am giving paths for both excel and template , template is kept on that path. Just my excel is getting created at runtime.
I havent edited the excel scope at all. So it shouldnt be giving any errors

I am confused why my excel doesnt have the same formatting as my template.

5

@Anil_G I just created an excel with the formatting and gave its path in Template file.
I havent done anything in the ‘do’ , i am first just verifying whether the excel is created with the same formatting.

6

@Anil_G @Gokul001 This is the template

image
image1902×1024 78.1 KB

7

@PAJ1999

ok just to get a clear understanding…are you expecting the file created to contain the formatting?

Because the template file is for design purpose…like to select the sheets and cells from the template file which looks similar to the orginal excel we get

Are you on the same understanding?

Because the formatting and all are not copied…its to give the modern features a way to identify the target excel

image
image1083×353 22 KB

cheers

8

Oh so formatting is not copied. I expected the sheets to automatically get created and format of the table to be copied.
So whats a template all about, what it does.

9

@PAJ1999

As I said…say the downloaded file contains 7 sheets and you want to perform filters and try some formatting on the file and all and say you do not have a file available with you but you know the format…you cna sue template file and build your autoamtion using clicks…basically you want to select Sheet pdf3 and column XYZ then from the menu using template we can find it

Suppose here is my template

image
image531×717 5.77 KB

To Select sheet you need not use custom input you can click on sheet1 and it adds

image

As it suggests this is just template not the original file or for any formatting only for design purpose while building automation on excel

image
image1161×240 33.3 KB

cheers

10

Please help,

I have an Excel file “Excel Template” that I want to fill out

  1. Column A8 : C1000 will be filled with data from CSV
  2. Columns E1:K10 will be filled with images that I have in the Image folder
  3. Column E12 : K20 will be filled with a circle pivot graph obtained from the data in column A8:C100

Once finished it will be saved in a folder and given a name according to Excel “ListAccount” in the “Subaccount” column

The “Excel Template” file will loop according to the data in the “LisAccount” file

How to create a project like the flow above, so that the “Excel Template” file can run well?
Excel Template.xlsx (10.3 KB)
ListAccount.xlsx (9.3 KB)