I am new to c# and to use closedXML. I am not able to find the projects related to working with excel sheets by using ClosedXML to refer. Any suggestions would be appreciated
I am trying to solve the following problem.
I have an excel book which contains two sheets.
In sheet 01:
In column A: In B: In C:
Student name01 Student's phone number blabla
Student name02 Student's phone number blabla
Student name03 Student's phone number blabla
In sheet 02:
In column A: In B: In C:
course name01 computerscience blabla
course name02 dhfsthshbstgs blabla
course name03 garsfghsefrgs blabla
now,
I would like to see in two comboboxes (all the words/text presented in the column A) from two sheets, the student name and course name and then I want select any student name and course name of my choice. Afterwards, when I click on a button, my programm should display the students phone number and the course name (from column B from both sheets) and related things present in the Column C D E.. of the selected things in combobox in a label or a in a textbox.
It would be great if I could get any help to proceed and solve this problem.
PS: I solved the following problem: I can select student name in one combobox and print the the corresponding data from the only one column B (but I worked only with one sheet). It is bit complicated for me to continue with two sheets.
Using two sheets How would I proceed. Any suggestions?
Thank you.