Excel name with variable

Help Activities
, ,
1

Hello guys, please help.
I need to save xls file with variable price. How to do that? Price every time diferent and xls name too

2

Hi and welcome,

Please can you elaborate or give the inputs and expected output.

Screenshots helps greatly. If the information is confidential then replace it with “dummy” text.

3

IMG_20201122_172203
IMG_20201122_1722032320×1736 980 KB

4

I type this, but have problem: write range illegal characters in uipath

5

I need to save xls like this: Toyota Camry Price(variable).xls

6

What happens if you save it as .xlsx instead?

Have you tried specifying the whole path?

7

@111578

Can you share the price variable value you are passing?

Thanks

8

Anyway xls or xlsx, one mistake: write range illegal characters in uipath

9

@111578

It’s not an issue with the extension

If you are passing any characters that not support in file name then you will get this error

So check the price variable value, if it contains any $ or some other symbols, then those should be removed / replace with valid characters

Hope this helps you

Thanks

1 Like
10

IMG_20201122_175026
IMG_20201122_1750262320×1736 1.35 MB
I replace symbol and space, but anyway this problem. My Price variable now 5 900 000, but it changes every time, when website info update

11

Hi There,

Make sure Sheet Name is correct.

12

Yes my Excel in russian and Sheet1=Лист1 in another project it worked.

13

@111578

Check as below

image
image2224×1009 286 KB

Can you write the value which you are passing using writeline activity

So that you can find issue, i believe
You can replace spaces as String.Replace(" ", “”)

Hope this helps you

Thanks

14

IMG_20201122_183348
IMG_20201122_1833481736×2320 1.17 MB
My variable Price taken from Get text activity and in message box its seems good, without symbols and spaces. But i can’t save xls with name of my variable Price. Price variable is correct, i use selectors

15

@111578

Before write Range, can you place a message box and give the same value you are passing to write range

This will give you the value entire value

Share that screenshot

also you need the value to be written in only A1?

Also it would be great if you remove space between Toyata Camry

Thanks

16

Here screenshot

IMG_20201122_184359
IMG_20201122_1843592320×1736 1.21 MB

17

@111578

As i said in previous post, you can remove the spaces
and also remove the spaces between Toyata Camry

and pass the entire excel file name to message box

do those changes, hope this will helps you

If it didn’t work share the error screenshot and as well as message box value too

Thanks

18

https://drive.google.com/drive/folders/1e7MD7BkuVWHOHXZ87Z1BgOxV1saMjhFu?usp=sharing
Please try on my xaml. I try all, but anyway can’t do it

19

@111578

  1. There is a argument created with the same Price variable, remove that
  2. Once you make replace you are getting many spaces, so that you have to use trim to remove unwanted spaces

by doing those steps you can find below result

image
image1234×366 24.6 KB

Attached workflow after correction
Робот Поиск Авто.xaml (21.5 KB)
project.json (2.1 KB)

Mark as solution if it works

Thanks

1 Like
20

Thank you it`s work. Thank for your attention and time.

1 Like