Hi,
I have to extract certain elements bypassing the authentication but can't find a way to add mod headers. I tried adding it under spider settings but it still throws me authentication error when i try to extract something.
Can you please help?
Hi,
I have to extract certain elements bypassing the authentication but can't find a way to add mod headers. I tried adding it under spider settings but it still throws me authentication error when i try to extract something.
Can you please help?
You can add headers in Global HTTP Settings or via Spider -> Http Settings. Is this what you mean with "mod headers"?
yeah but it didn't work for me. do i need to restart the excel to make it work?
No, it should work immediately. I would guess the request is not correctly designed. Perhaps try Fiddler to capture the request and inspect what is missing/wrong?
Thanks, I have sorted it out now by selecting the whole range instead of using Xpath in an individual cell function. It works perfectly fine