Simple C# form application to read and write to an excel file using Microsoft Graph nuget api

Create Form application with:

Textbox search
Button read

Textbox value
Button Write

Textbox result


1) When button read is pressed the text from "textbox search" is looked for in column A

1.1) If found the corresponding value from A and B are shown in the "textbox result"

2) When button write is pressed the text from "textbox search" is looked for in column A

2.1) If found and there is no existing value in column B the string from "textbox value" is written into the column B cell.

2.2) If the search string was not found, the search string is added to column A and the value from "textbox value" is put in column B.

2.3) If the value from "textbox value" is nothing and a row for the search term is found in column A, the row must be removed.


Example excel data attached. I can create a shared excel dot too if needed to test.

For examples above using supplied data

1.1) Textbox search = "apple" + Button read -> Textbox result = Apple Green

2.1) Textbox search = "orange" + Textbox value = "Orange" + Button Write -> Textbox result = orange Orange

2.2) Textbox search = "Pear" + Textbox value = "Yellow" + Button Write -> Textbox result = Pear Yellow + new line in excel doc

2.3) Textbox search = "Grape" + Textbox value = "" + Button Write -> Textbox result = Grape row removed + line in excel doc deleted