Interview Questions_excel,browser

1.A webpage is opened in a browser, when a url is clicked inside the webapage, it should be redirected to a new page. But it did not get redirected when the url is clicked.
what could be the reason?
2. How to select few records if more than 25000 records are processed in excel?
(Other than filter data table option). Also what are the limitations of datatable?
3. How can we select one sheet and delete one sheet from the same excel workbook?

Please help. Thank you.

@Jeyalakshmi_KS

I already answered your query in other post. If you have any other queries then please post it there itself.

I would request you to don’t create multiple posts for similar query.

  1. First use Read Range activity to read the excel file and it will give output as DataTable. Let’s say dtInput.

  2. And then check DataTable count is greater than 25000 or not as below in IF activity.

          dtInput.Rows.Count > 25000
    
  3. If it is greater than 25000 then try below expression to read few rows from it.

dtOutput = dtInput.AsEnumerable.Take(1000).CopyToDataTable

Note: Here, you can replace 1000 with required number rows you want to read it.

You can use Balareva Excel activities or use VBA code to delete particular sheet from Excel file.

1 Like

@Jeyalakshmi_KS

You can check below for your reference

Hope this may help you

Thanks

1 Like

Thanks a lot.

Thank you very much. Much appreciated.

1 Like

dtOutput = dtInput.AsEnumerable.Take(1000).CopyToDataTable

Will the above expression select first 1000 records? what if we want to select specific 1000 records? Thank you

@Jeyalakshmi_KS

Yes it will read first 1000 rows from the DataTable.

Specific means ? How you will identify those 1000 records ?

Like if I want to select 1000 records from 100 to row 1100… Is that possible?

@Jeyalakshmi_KS

Try below expression.

           dtOutput = dtInput.AsEnumerable.Skip(100).Take(1000).CopyToDataTable

The above expression skips first 100 rows and then take next 1000 rows from it.

Thank you very much for being so kind. Cheers.

1 Like

@Jeyalakshmi_KS

If you don’t have any further queries then please close this thread by marking appropriate post as solution. Thanks