How to add data with status

Help Studio
, ,
1

master.xlsx (12.6 KB)
sample.xlsx (12.6 KB)

There are 2 files

  1. Master file in which all master data is stored
  2. sample file is used to add new data.
    here I have some data in both sheet, some of data is same in both sheet.
    Now here it compare both sheet if data of both the sheet is match then it show status (“Student Exist”) in status column in sample sheet.
    if not match show the status (“New Student”) & then copy that data in master sheet
    and there is also a student id column which is also increase with the adding data.

and please do it in simple way because I am a beginner.
output.xlsx (12.5 KB)

please help

2

Hi @Lakshya_Garg

Please find the attached xaml , hope it solves your issue

if it is helpful to you kindly mark it as solution, i also attached the output file with you

Thanks,
master.xlsx (11.1 KB)
sample (1).xlsx (12.7 KB)
Main.xaml (20.8 KB)

3

it shows activity missing

4

Install Balareva.EasyExcel package

missing activity should be Set Border activity ss attached below

image
image1366×768 93.8 KB

5

ok i’ll try

6

its working
Thanks for helping
but one more thing
tell me meaning of this statement “A”+(Length+2).ToString+“:E”+(length2+1).ToString
and also why you use 2 border activity

7

length variable used to find no of rows present before inserting new student
length2 variable used to find no of rows present after inserting new student

with the help of two variables we used to color the border,
could you please mark it as solution

Thanks,

8

why we do length+2

9

can I use only 1 border activity both are same only the differnce is presets.

10

because in the excel values are starting from 2nd row

11

yes
you can

12

both activities are same

difference is border width and type

13

ok
again Thanks for Helping me
Have a good
thanks

14

please mark me as solution

thanks,

15

already done

16

you wrongly marked your response as solution kindly mark me as solution

17

now check.

18

thanks

19

no issues

good luck

20

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