Question

Excel Advanced:open doesnt work because it changes the \ to /. How to fix it?

  • 19 October 2022
  • 6 replies
  • 4 views

Userlevel 2
Badge +8

I used String:Replace for the excel path as variable, and put it in the Excel Advanced action, but it still doesnt work.

 

What to do?


6 replies

Userlevel 5
Badge +8

Hi @Semih Öztürk​ ,

 

Hope you are using latest Excel Adv package version?

Userlevel 2
Badge +8

@ChanduMohammad S​ 

Hi, its on the last version yes

@Semih Öztürk​ Can you give an example of the path that is giving you problems? I am unable to replicate what you are seeing.

Userlevel 2
Badge +8

Hello @Jeremiah Logan​ 

the path is like \\fileserver\hayat\HK\B_130\KONTROL\COUNTRY-19102022.xlsx

 

this the path in the ExcelAdvanced:Open,

 

but it gives error as //fileserver/hayat.... is not exist.

 

i did string : replace / to \

but it didnt work

Can you please include a screenshot of the Excel Advanced>>Open, and your parameters? Something like this:

 

image 

I have configured it to run to one of my network shares as shown in the screenshot but am unable to duplicate the behavior you're seeing. Also, can you please let us know what version of the product you're using, and whether on-prem or Cloud?

Userlevel 2
Badge +8

Hello @Jeremiah Logan​ 

thank you for trying to help. Actually it was my friend's issue.

and she just said it worked now without changing anything..

everything was the same and started working now

Reply