So, for the beginning, I have an excel file with 1 row and multiple columns.
I need to read one column where is a text. Then I have to search for that text in a .txt file. On the line where I found the text I need to keep searching for "MIN/MAX:".
The line looks like these:
"UInt32 StEaAktivKl15Pers_en /* LSB: 2^0 OFF: 0 MIN/MAX: 0 .. 2 */;".
The string that is in excel cell and I'm searching for is
"StEaAktivKl15Pers_en". After I found the line and the "MIN/MAX:" I need to do a random between MIN which is 0 and MAX wich is 2.
And I have to write it in Excel file for a specific number of rows on that column I was searching for.
Can you guys help me with this? It can be in C#, C++, Python or the VBA from Excel.
What I have tried:
For the moment I can read from excel and store the value in a variable