HYTOS

using GemBox.Spreadsheet;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ID2.Manager.Common.Helpers

{

    public static class GemboxHelper

    {

        public static bool IsNumber(this ExcelCell cell)

        {

            if(cell.ValueType == CellValueType.Int)

            {

                return true;

            }

            else

            {

                return false;

            }

        }

        public static bool IsString(this ExcelCell cell)

        {

            if (cell.ValueType == CellValueType.String)

            {

                return true;

            }

            else

            {

                return false;

            }

        }

        public static bool IsDateTime(this ExcelCell cell)

        {

            if (cell.ValueType == CellValueType.DateTime)

            {

                return true;

            }

            else

            {

                return false;

            }

        }

        public static bool IsNullOrEmpty(this ExcelCell cell)

        {

            if(cell.IsString())

                return string.IsNullOrEmpty(cell.StringValue);

            else

                return cell.Value == null;

        }

    }

}