Scenario:
Open URL - https://www.nseindia.com/market-data/live-equity-market?
Extract the whole table data into Excel (xslx)
Method 1:
Under Data table package, I have used Write to file “Throws an exception”
Error:
Note:
The Extracted Table header value contains two rows of values. how to change the Data table column header value.
Hi
Could you please confirm your Control Room build? Else, you can check the Encoding option which have selected. It could be because of that.
Hi
I get the same error if i use ANSI. Try to change the codification to UTF-8. Using a csv file is a suggestion.
This may be due to the following reason: An unknown error occurred while trying to write data table to "C:\RPA\Test\ExtractedData.csv". If the problem persists, please contact your System Administrator.
HTH
Regards
Hi
Thank you. Really appreciated.
Moreover UTF-8 - Second line of header value doesn’t appear.
I have tried UTF-8 with BOM works fine exactly what extracted from webpage.
Regards,
Prabu Baskaran.
Hi
Thank you. Really appreciated.
Moreover UTF-8 - Second line of header value doesn’t appear.
I have tried UTF-8 with BOM works fine exactly what extracted from webpage.
Regards,
Prabu Baskaran.
Great!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.