Skip to main content
Answer

There is a syntactical error in the SQL statement using Data Table : Write to file Action item

  • December 22, 2022
  • 4 replies
  • 532 views
P
Forum|alt.badge.img+4

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.

Best answer by Raul Jaimes

Hi @Prabu.B1 

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

 

Prabu Baskaran
A

4 replies

Padmakumar
Premier Pathfinder | Tier 7
Forum|alt.badge.img+15
  • Padmakumar
  • Premier Pathfinder | Tier 7
  • December 22, 2022

Hi @Prabu.B1 ,

 

Could you please confirm your Control Room build?  Else, you can check the Encoding option which have selected. It could be because of that.

Padmakumar
A
Raul Jaimes
Forum|alt.badge.img+9
  • Raul Jaimes
  • Navigator | Tier 3
  • Answer
  • December 22, 2022

Hi @Prabu.B1 

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

 

P
A
P
Forum|alt.badge.img+4
  • Prabu.B1
  • Author
  • Cadet | Tier 2
  • December 23, 2022

Hi @Raul Jaimes 

 

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.

Prabu Baskaran
Raul Jaimes
Raul Jaimes
Forum|alt.badge.img+9
  • Raul Jaimes
  • Navigator | Tier 3
  • December 23, 2022

Hi @Raul Jaimes 

 

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!

Terms & ConditionsCookie settingsAccessibility statement