Write value to specific cell in excel

Help StudioX
,
1

Hi guys, I have created a temp excel for this like this

An attendance sheet in a spreadsheet format lists students' Ids, classes, and attendance statuses. (Captioned by AI)
An attendance sheet in a spreadsheet format lists students' Ids, classes, and attendance statuses. (Captioned by AI)1829×176 5.97 KB

Now I want to write value to this specific column(C3) or wherever I find “No. of Student” in row. also want to update this month. also I want to know how I can write values under the column ‘Present’
An Excel spreadsheet titled "Attendance for June 2024" lists the presence status of students in two different classes, with student IDs 9945 and 9947, where one is marked 'Y' for present and the other 'N' for not present. (Captioned by AI)
An Excel spreadsheet titled "Attendance for June 2024" lists the presence status of students in two different classes, with student IDs 9945 and 9947, where one is marked 'Y' for present and the other 'N' for not present. (Captioned by AI)1816×275 6.2 KB

Altogether should look like this

2

@susHI_Bae

Use Activities - Find/Replace Value to find “No. of Student”. This will return you the range from which you can get column.

Thanks,
Ashok :slight_smile:

3

Okay, understood.
I have read the template excel file, as it in a StudentDt, now I search for ‘No.of Student’, from which I get column, now what? how do write value to c3 column

4

@susHI_Bae,

For writing to a specific cell use Write Cell activity.

Thanks,
Ashok :slight_smile:

5

Hello @susHI_Bae

Have you tried using the LookUp Datatable activity?