Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1030
  • Last Modified:

Excel Empty Cell Value

I am reading in from and excel sheet, and placing into a string.
we shall say
ExcelString = (data from excel).

Does anyone know what the value of ExcelString is if the cell was empty?
I need this for comparison, and it is in a place in the app I can't even have it output it to the screen.
I know it is not "null"
I know it is not an empty string ""
 
0
jj819430
Asked:
jj819430
  • 4
  • 2
1 Solution
 
testnCommented:
Again.... try DBNull.Value
0
 
jj819430Author Commented:
I am trying to use it in an if statement.

if (ExcelString != DBNull.Value)
{
}
is not capturing it... it is weird because I would have thought it would be fine.
0
 
jj819430Author Commented:
I meant

if(ExcelString != Convert.ToString(DBNull.Value))
{
}
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
testnCommented:
Can you put more code?

How do you connect to excel? Using COM object or OLEDB?
0
 
jj819430Author Commented:
void ConnectandRead()
{
String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\Files\\" + filename + ";" +"Extended Properties='Excel 8.0; IMEX=1;'";
                  
                  
                  OleDbConnection objConn = new OleDbConnection(sConnectionString);

                  
                  objConn.Open();

                  OleDbCommand objCmdSelect =new OleDbCommand("SELECT * FROM [Sheet1$]", objConn);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
objAdapter1.SelectCommand = objCmdSelect;
DataSet objDataset1 = new DataSet();
objAdapter1.Fill(objDataset1, "XLData");

}

After this reading of the data, I put it in a datagrid for display and editing. I convert each one into string format (by force) in order to work with another neccessary

So I have it as string ExcelString = DataGridExcel.Items[1].Cells[0].Text

I am trying to figure out what is in ExcelString if the data read from the excel sheet was a null.
0
 
jj819430Author Commented:
Nevermind, got it on my own. It was == " " (I guess it changes it to a black space if it is null during the conversions.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now