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.
lakshman
(Ganta lakshman)
April 20, 2022, 11:16am
2
@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.
I was asked the following question in an interview:
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?
Pls help if you know… Thank you.
First use Read Range activity to read the excel file and it will give output as DataTable. Let’s say dtInput .
And then check DataTable count is greater than 25000 or not as below in IF activity.
dtInput.Rows.Count > 25000
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
Srini84
(Srinivas)
April 20, 2022, 11:23am
3
@Jeyalakshmi_KS
You can check below for your reference
Hope this may help you
Thanks
1 Like
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
lakshman
(Ganta lakshman)
April 20, 2022, 12:39pm
7
@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?
lakshman
(Ganta lakshman)
April 20, 2022, 12:45pm
9
@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
lakshman
(Ganta lakshman)
April 20, 2022, 1:38pm
11
@Jeyalakshmi_KS
If you don’t have any further queries then please close this thread by marking appropriate post as solution. Thanks
Forum FAQ - How to mark a post as a solution
This document is part of our beginners guide .
This article will teach you how to properly mark a post as a solution.
We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them.
When is the topic resolved?
The topic can be considered resolved when the topic author has fo…