End Google Ads 201810 - BS.net 01 --> Hello all you C# and Excel programming people,

some days ago I discovered something that I have to tell...
I wrote a programm writing/reading to and from an MSSQL-db to and from Excel-sheets.
In one of my Excel-sheets I have to read the column "A" in order to get the right row to insert some values.
inside a ...
for(int row=0;...){ // I do like...
Excel.Range range = (Excel.Range)mySheet.Cells[row, "A"];
string val = range.Text.ToString();
...
}

The problem is: when one of the rows is hidden I do not get the row and for that reason I don't get a value.
When the whole column "A" is just not as wide as it has to be you can only see "####" and this is exactly what I get, what my string val looks like.
So the data in the Excel sheet is some number, but what I get is only what I see.

IF someone knows how to get rid of such a problem, I'd like to know.
Else I just wanted to mention.

Greets
Harry

no plan,
no signature