Write Cell: The given path's format is not supported!

Help Activities
, ,
1

I’m try to create a dynamic file name, when I try to pass the following inside the write range activity “Techno Invoices"+CustomerName+”_“+InvoiceNo+”.xlsx", it throws an error that the given paths format is not supported. Where have I missed the point?

Thank you.

Screenshot (1072)
Screenshot (1072)1366×768 63.9 KB

2

@Nkrumah_Dubazana - What are the values you have it in the customer name??

3

CustomerName is a Dynamic variable, that stores all of the extracted customer names from the from

4

@Nkrumah_Dubazana - my point is there is some illegal character coming from a dynamic variable like etc ( , ’ @ etc etc ) …which is stopping you from creating the folder path …

Try removing a dynamic variable and hardcode the value and try…by this way you can find out which variable is culprit …

5

What @prasath17 is said correct some times you will get null also on that time you will get this message I also fetch this you just put the write line activity before write cell on that time you will get to know what’s Happen :clinking_glasses:

Thanks
Chethan P

6

Invoice Scraping.xaml (20.7 KB) Hears the workflow, If you may could you Kindly have look at it.

7

I have placed the “write line” activity like you suggested, just before the “write cell” activity, but the error still persists, and no result was displayed in the output. I have attached the workflow, if you may could you kindly take your time and have a look at it, run your diagnosis, and check it out.

Thanks for your time and attention.

8

What you get in the write line activity

9

Scraping.zip (406.1 KB)
Could you kindly check out the Zip File I have attached.

10

@Nkrumah_Dubazana - I have gone through your xaml i am seeing lot of issues…sry…

  1. Get Text output variable not defined

image
image1245×215 18.5 KB

  1. CustomerTxt is defined but it has no values to replace…I.e it is empty string…

image

  1. Invoice # selector is hardcoded as 281092, so it will work only that specific invoice…

image
image807×475 22.4 KB

  1. Invoice Date also hardcoded…

image
image800×550 24.7 KB

  1. PDF Page count is not extracted anywhere but the count has been used…

image
image732×110 2.63 KB

I would suggest to go through some youtube videos on how to extract from invoice…

Link 1

Link 2

Link 3

Link 4 - This is using Regex so if you are not sure on how to use Regex please ignore

2 Likes
11

Thank you so much for your devoted time to my situation and for your gentle advice. I will look through at the material you shared, to further improve my learning experience.

1 Like