Excel name with variable

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

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.

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

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

What happens if you save it as .xlsx instead?

Have you tried specifying the whole path?

@111578

Can you share the price variable value you are passing?

Thanks

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

@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

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

Hi There,

Make sure Sheet Name is correct.

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

@111578

Check as below

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

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

@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

Here screenshot

@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


Please try on my xaml. I try all, but anyway can’t do it

@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

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

Mark as solution if it works

Thanks

1 Like

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

1 Like