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”
![](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/490aab90-d12e-4d97-9354-0cc7306811ca.png)
Error:
![](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/d93df939-14a6-4894-b37c-a2bbff358e0f.png)
Note:
The Extracted Table header value contains two rows of values. how to change the Data table column header value.