how to get count of rows

Vishal0017

New Member
Hi,

Please help to get the count of non blank cells (need to get a count of rows that have data available in it) form an excel worksheet1 using Blue Prism.
 

Vishal0017

New Member
Thanks
Your solution did work for me. However, can you please help me while data consolidation from multiple sheets into one. How can I exclude headers from (Except sheet1) rest of the sheets.

Example : Sheet1 has 20 rows data and sheet2 has 40 rows data. So, how can I exclude header from Sheet2 and append the data into sheet1.

Thanks in advanced
 

sreejith

Member
It depends on how you plan to merge two excel sheets.
One approach is import the sheet(s) [from sheet 2 to sheet n] into a collection and then use the action 'Write Collection' to push all the data to your final sheet(say sheet 1). In that action you can mention 'Include column names' as false so that only data(without headers) will be exported to that sheet.
 

VJR

Well-Known Member
One additional approach is to use the Copy Paste Worksheet as Range and start the copy from the second row A2 of Sheet2 and paste it into the LastRow+1 of Sheet1
 
Top