Example #1
0
        public ExcelCellInfo(DataCell cell) : base()
        {
            row = cell.RowIndex + 1;
            col = cell.ColumnIndex + 1;

            if (cell.Formula != null && cell.Formula.Trim().Length > 0)
            {
                formula = cell.Formula;
            }
            if (cell.HasPrefix())
            {
                prefix = cell.PrefixChar;
            }
            if (cell.Value != null)
            {
                content = cell.Value.ToString();
            }
            if (cell.CellFormat == null)
            {
                format = "";
            }
            else
            {
                format = (string)cell.CellFormat;
                if (format == "General")
                {
                    format = "";
                }
            }
        }