How do i check if the excel sheet is empty and if it is empty keep moving to the next sheet until a specify company

Help Studio
#1

Hi, im trying to figure out how do i check if the excel sheet is empty and if it is empty keep moving to the next sheet until a specify company is found after that copy the data in the sheet and paste it to another specify company in the sheet all these is done in the same file

Here is a screenshot of my progress so far

image
image765×471 11.5 KB

Forum Engagement Daily Reports
#2

You can use Get Workbook Sheets get all the sheet name, then use For Each to loop the sheet name

1 Like
#3

Hi @SIM_JUN_HUI_BERTRAM_CSOD

Could you please send the sample excel file ,is the company means the sheet name or is the data present inside the sheet.

#4

The company means the sheet name License List sample.xlsx (90.2 KB)

#5

The data is present the thing i need to do is copy from a specify company and paste the data in another company

#6
  1. In excel application scope property there was as property called workbook crarte a variable in it.(let’s assume variable name as WB)
  2. Use for each in value give WB.getsheets it will give all the sheet names in a collection
  3. Inside for each put an if condition and check if the sheet name equals to what company name you want.
    4.if it matches in then use read range and store it in datatable.
  4. And again do the same process for finding the company name sheet you want to paste and use append range or write range to paste the data.

Get sheet name for reference

2 Likes
#7

What is the variable type for this WB?

#8

WorkbookApplication

Or

You can just create the variable by using ctrl+k in the output field it will automatically assign variable type

#9

Thanks that fixed it so for the if function the condition to find the specify company do i need to create a data table to find it ?

#10

No it will be a string datatype which will come from for each activity…

#11

Wait now how do i know if the excel sheet has data then it will copy else find another company. So far im able to copy n paste it to the company i want already i know xxxx.Rows.count > 0 works but im not sure where to put it or there is another way

image
image776×493 16.8 KB

#12

your solution would be a good one for checking whether the datatable contains data or not

#13

Hi @SIM_JUN_HUI_BERTRAM_CSOD

Did the issue got fixed?

#14

Yes, kind of but now i want to copy n paste into the last row of a cell and continue in future too do you know how?

#15

Use append range it will write the data after the last row.

2 Likes
#16

Thanks for the help guys, it helped alot. If i got questions again i will post on a new one !

#17

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.