+4Scenario:
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.
Best answer by Raul Jaimes
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
+13Hi
Could you please confirm your Control Room build? Else, you can check the Encoding option which have selected. It could be because of that.
+9Hi
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
+4Hi
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.
+9Hi
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.
