Skip to main content
Question

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


Forum|alt.badge.img+11

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+19
  • Most Valuable Pathfinder
  • 2693 replies
  • October 19, 2022

Hi @Semih Öztürk​ ,

 

Hope you are using latest Excel Adv package version?


Forum|alt.badge.img+11
  • Author
  • Mission Commander | Tier 5
  • 519 replies
  • October 19, 2022

@ChanduMohammad S​ 

Hi, its on the last version yes


Forum|alt.badge.img+17
  • Flight Specialist | Tier 4
  • 87 replies
  • 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+11
  • Author
  • Mission Commander | Tier 5
  • 519 replies
  • 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
  • Flight Specialist | Tier 4
  • 87 replies
  • 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+11
  • Author
  • Mission Commander | Tier 5
  • 519 replies
  • 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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings