I am having issue of data getting appended into second excel sheet while writing data into excel sheet using Write Range activity for data scrapped using Extract DataTable using Uipath.
The problem statement is that I need to click each symbol name in Nifty 50 Gainers Tab and Navigate to Quotes Page for respective symbol. And Next step is to scrape the data from Quotes page for respective symbol and store into the excel file. Then again Navigate back to Nifty 50 Gainers Tab and click next symbol name and again Navigate to Quotes page for that clicked symbol name and Again scrap the Quotes data for respective symbol name and write the data into excel file using Write Range Activity using Uipath.
But the issue that I am currently facing is that, I am able to click each symbol name in Nifty 50 Gainers tab and getting properly navigated to Quotes page for respective symbol. Also I am able to click back and Navigate back to Nifty 50 Gainers Tab as well.
For example I am clicking [BAJAJFINSV] symbol name in Nifty 50 Gainers tab in NSE Live Market website. Then Quotes page gets opened for BAJAJFINSV symbol. I am scrapping data from Trade Snapshot and store in excel file as single sheet named Gainer-Bajaj Finsv.
Then I am clicking back button and Navigate to Nifty 50 Gainers Tab in NSE Live Market website and clicking second symbol name from the table which is [BAJFINANCE] and again Navigate to Quotes page of respective symbol name and again scrapping data and storing data into excel file as second sheet with Gainer- BAJFINANCE in excel file. But the issue is that I am getting data of BAJAJFINSV appended into BAJFINANCE sheet. Attached screenshot for reference. But my requirement for the process is that I need separate excel sheet for separate Quotes data for respective symbol name, means BAJAJFINSV and BAJFINACE sheet should be separately stored in different sheets in same excel file. Also same should be followed for all symbol name of Nifty 50 Gainers Table in NSE Live Market Website. Please help me out with this issue.
I am also able to scrape the Quotes (Trade Snapshot) data for each respective symbol as well and store into excel file. But the issue is that Quotes data (Trade Snapshot) of first symbol name is getting appended into second sheet in excel file using Write Range activity and Extract DataTable activity. I have used row count to check the datatable count before writing data into datatable but the issue is that Trade Snapshot data of the first symbol is getting appended into second sheet for Trade Snapshot data for the second symbol name in excel file.
Please anyone, help me out with this issue on urgent basis. I am sharing the excel file and screenshot for reference.
NSE_Data_19012021_1217.xlsx (13.4 KB)