Hi All,
I have some set of HTML data which i am trying to extract and want to write in excel.
But don’t know what is the issue, it is not able to write the data.
Kindly help me urgently.
1 Like
hi @Rakesh_Tiwari,
First validate where the issue is - Is it with extracting the Data or writing the Data.
Take a writeline between DataScraping and exel applciation scope and type
DataTable.rows.count.tostring
If the result or writeline is correct meaning the correct number of rows are displayed , that means the issue is with excel writing. IF you get Zero Rows here the issue is with Data Scraping.
–
Mukesh
not writting the data into excel.
Plzz attach the SS of your Excel scope
or attach the workflow
which will make easy to find issue
Happy Automation 
Best Regards
Er Pratik Wavhal 
OKay - Few things to Verify -
-
Correct DataTable is passed
-
You are saving the Excel post the Write - Enable the AutoSave of Excel application Scope
-
Run the Worklow by enabling the visible property of Excel applciation scope- you will be able to see the execution .
–
Mukesh
Hi,
Here i am attaching my workflow.
it is not writing data into excel.
With in the write range within cell property You must specify double quotes like this “”
you are missing those
Hope this may help to solve your issue
Mark as solution if this helps you and like it 
Happy Automation
Best Regards
Er Pratik Wavhal
Hi,
Not working after specifying “” also.
Can you share a screenshot of Excel application scope Properties ?
Can you check that Extract Structured Data, is returning the values?
Check the Datatable has value, also are you getting any error?
Thanks
1 Like
How to check that
Can you check that Extract Structured Data, is returning the values?
i am not getting any error.
Everyhing seems Correct here 
- Take a writeline between DataScraping and exel applciation scope and type
DataTable.rows.count.tostring
Verify this Count.
2.Can you try to write the Data in a Different excel say : Sample.xlsx
–
Mukesh
Extract Structed Data will have output of Datatable - ExtractedData by default
Place a message box and write as ExtractedData.Rows.ToString
It will give you count, If it is zero, then you have to check with the Datascraping correctly
Hope this helps
Thanks
If you want to go through the extracted data which is extracted or not
May be some data or nothing with rows columns
Then do the following steps :-
- Between Data Scrapping and Excel Application Scope drop a activity called Output DataTable
Output DataTable will convert the data into string - After that use writeline activity or message box activity to display data within the extracted datatable
By which you will be able to see all the extracted data
Hope this will help you to find out the root cause
Happy Automation
Best Regards
Er Pratik Wavhal
ok, is there any way to get that data into excel or notepad anything
Yes
You can write that data into notepad
Instead of write Line use “Write Text File” Activity
Like this
Happy Automation
Best Regards
Er Pratik Wavhal
ok, that worked fine, but the situation is.
i want only details of a customer which i provide as a input not all.
Suppose i provide input as (CDS), it should fetch the below details of CDS only
Initials,First Name,Last Name,Position,Mobile,Direct,Dept. No,Pcardno,Department,Country,Company,Address,Building,City,Manager
how to achieve it.
For this you can use “Filter Datatable” Activity
Here you can filter the data as per you condition
And when ever the condition meets you can extract that data from the specified columns which you will mention
Then it will create the new DataTable which you can use to generate New Excel
Hope this may help to solve your issue
Mark as solution if this helps you and like it
Happy Automation
Best Regards
Er Pratik Wavhal