I have functions that use
OleDbCommand , OleDbDataReader and OleDbCommand
to read values of cells within an excel sheet.
it works fine for everything else , however in some cases like:
Row 12-15 ,Column Z , it returns null and i have no idea why
What is about these cells that is giving me the grief ..
Cheers
Code:
OleDbCommand query = new OleDbCommand(strSql, connection);
reader = query.ExecuteReader();
// blaa blaa
while (reader.Read())
{
foreach(string column in columns)
{
iColumn++;
string x = null;
try
{
x = reader[column].ToString();
Last edited by Saeed; March 12th, 2010 at 12:19 AM.
* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.