Not writing in excel

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.

@Rakesh_Tiwari

Can you attach your workflow folder? Also any error are you facing?

Thanks

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.

Hi @Rakesh_Tiwari

Plzz attach the SS of your Excel scope
or attach the workflow
which will make easy to find issue

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

OKay - Few things to Verify -

  1. Correct DataTable is passed

  2. You are saving the Excel post the Write - Enable the AutoSave of Excel application Scope

  3. 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.

image

it is not writing data into excel.

Hi @Rakesh_Tiwari

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 :innocent:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

Hi,

Not working after specifying “” also.

Can you share a screenshot of Excel application scope Properties ?

@Rakesh_Tiwari

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 :sunglasses:

  1. 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

@Rakesh_Tiwari

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

Hi @Rakesh_Tiwari

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 :-

  1. Between Data Scrapping and Excel Application Scope drop a activity called Output DataTable
    Output DataTable will convert the data into string
  2. 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 :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

ok, is there any way to get that data into excel or notepad anything

Hi @Rakesh_Tiwari

Yes
You can write that data into notepad
Instead of write Line use “Write Text File” Activity

Like this
image

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

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.

Hi @Rakesh_Tiwari

For this you can use “Filter Datatable” Activity

Here you can filter the data as per you condition
image

And when ever the condition meets you can extract that data from the specified columns which you will mention
image

Then it will create the new DataTable which you can use to generate New Excel
image

Hope this may help to solve your issue
Mark as solution if this helps you and like it :innocent:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer: