Skip to main content
Question

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

  • October 19, 2022
  • 6 replies
  • 83 views

Forum|alt.badge.img+12

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

Forum|alt.badge.img+22
  • Most Valuable Pathfinder
  • October 19, 2022

Hi @Semih Öztürk​ ,

 

Hope you are using latest Excel Adv package version?


Forum|alt.badge.img+12
  • Author
  • Pathfinder Advocate | Tier 6
  • October 19, 2022

@ChanduMohammad S​ 

Hi, its on the last version yes


Forum|alt.badge.img+17
  • Most Valuable Pathfinder
  • October 19, 2022

@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.


Forum|alt.badge.img+12
  • Author
  • Pathfinder Advocate | Tier 6
  • October 20, 2022

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


Forum|alt.badge.img+17
  • Most Valuable Pathfinder
  • October 20, 2022

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?


Forum|alt.badge.img+12
  • Author
  • Pathfinder Advocate | Tier 6
  • October 21, 2022

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