private string getDataType(Range cell)
{
string result = "";
WorksheetFunction func = cell.Application.WorksheetFunction;
if (func.IsLogical(cell))
{
result = "boolean";
}
else if (func.IsNumber(cell))
{
try
{
Convert.ToDateTime(cell.Text);
result = "date";
}
catch
{
result = "decimal";
}
}
else //if (func.IsText(cell))
{
result = "string"; //default type is string
}
return(result);
}