In my c# application I have a string array defined as:
string[,] TranArr = new string[999,20]
I am reading data into this array from an excel spreadsheet (MS Excel 2007 xlsx) via an OdbcDataReader. One spreadsheet cell value is approx. 400 characters in length but when I read it into my array it is truncated to 245 characters. Any idea why this might be happening ?
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…