ExcelParser Class Reference

Static Public Member Functions
static bool	IsNull (ICell cell)
static int	GetInt (int id)
static int	GetInt (int col, IRow _row)
static bool	GetBool (int id)
static bool	GetBool (int col, IRow _row)
static double	GetDouble (int id)
static float	GetFloat (int id)
static float[]	GetFloatArray (int id)
static int[]	GetIntArray (int id)
static string[]	GetStringArray (int id)
static string	GetString (int id)
static string	GetString (int col, IRow _row)
static string	GetStr (int id, bool useDefault=false)

Static Public Attributes
static IRow	row
static IRow	rowDefault

Detailed Description

Definition at line 4 of file ExcelParser.cs.

Member Function Documentation

GetBool() [1/2]

static bool ExcelParser.GetBool ( int  col, IRow  _row  )

inlinestatic

Definition at line 46 of file ExcelParser.cs.

    {
        row = _row;
        return GetBool(col);
    }

References GetBool(), and row.

GetBool() [2/2]

static bool ExcelParser.GetBool ( int  id )

inlinestatic

Definition at line 34 of file ExcelParser.cs.

    {
        string str = GetStr(id);
        return str switch
        {
            "0" => false, 
            "1" => true, 
            null => false, 
            _ => bool.Parse(str), 
        };
    }

References GetStr().

Referenced by GetBool(), SourceData< T, T2 >.GetBool(), and TextConv.Item.Item().

GetDouble()

static double ExcelParser.GetDouble ( int  id )

inlinestatic

Definition at line 52 of file ExcelParser.cs.

    {
        string str = GetStr(id);
        if (str != null)
        {
            return double.Parse(str);
        }
        return 0.0;
    }

References GetStr().

Referenced by SourceData< T, T2 >.GetDouble().

GetFloat()

static float ExcelParser.GetFloat ( int  id )

inlinestatic

Definition at line 62 of file ExcelParser.cs.

    {
        string str = GetStr(id);
        if (str != null)
        {
            return float.Parse(str);
        }
        return 0f;
    }

References GetStr().

Referenced by SourceData< T, T2 >.GetFloat().

GetFloatArray()

static float[] ExcelParser.GetFloatArray ( int  id )

inlinestatic

Definition at line 72 of file ExcelParser.cs.

    {
        string str = GetStr(id);
        if (str != null)
        {
            return Array.ConvertAll(str.Split(','), float.Parse);
        }
        return new float[0];
    }

References GetStr().

Referenced by SourceData< T, T2 >.GetFloatArray().

GetInt() [1/2]

static int ExcelParser.GetInt ( int  col, IRow  _row  )

inlinestatic

Definition at line 28 of file ExcelParser.cs.

    {
        row = _row;
        return GetInt(col);
    }

References GetInt(), and row.

GetInt() [2/2]

static int ExcelParser.GetInt ( int  id )

inlinestatic

Definition at line 19 of file ExcelParser.cs.

    {
        if (int.TryParse(GetStr(id), out var result))
        {
            return result;
        }
        return 0;
    }

References GetStr().

Referenced by TextConv.BuildMap(), GetInt(), and SourceData< T, T2 >.GetInt().

GetIntArray()

static int[] ExcelParser.GetIntArray ( int  id )

inlinestatic

Definition at line 82 of file ExcelParser.cs.

    {
        string str = GetStr(id);
        if (str != null)
        {
            return Array.ConvertAll(str.Split(','), int.Parse);
        }
        return new int[0];
    }

References GetStr().

Referenced by SourceData< T, T2 >.GetIntArray().

GetStr()

static string ExcelParser.GetStr ( int  id, bool  useDefault = false  )

inlinestatic

Definition at line 113 of file ExcelParser.cs.

    {
        IRow row = (useDefault ? rowDefault : ExcelParser.row);
        if (row == null)
        {
            if (!useDefault)
            {
                return GetStr(id, useDefault: true);
            }
            return null;
        }
        ICell cell = row.GetCell(id);
        if (IsNull(cell))
        {
            if (!useDefault)
            {
                return GetStr(id, useDefault: true);
            }
            return null;
        }
        cell.SetCellType(CellType.String);
        if (cell.StringCellValue == "")
        {
            if (!useDefault)
            {
                return GetStr(id, useDefault: true);
            }
            return null;
        }
        return cell.StringCellValue;
    }

References GetStr(), IsNull(), row, and rowDefault.

Referenced by GetBool(), GetDouble(), GetFloat(), GetFloatArray(), GetInt(), GetIntArray(), GetStr(), SourceData< T, T2 >.GetStr(), GetString(), and GetStringArray().

GetString() [1/2]

static string ExcelParser.GetString ( int  col, IRow  _row  )

inlinestatic

Definition at line 107 of file ExcelParser.cs.

    {
        row = _row;
        return GetStr(col);
    }

References GetStr(), and row.

GetString() [2/2]

static string ExcelParser.GetString ( int  id )

inlinestatic

Definition at line 102 of file ExcelParser.cs.

    {
        return GetStr(id) ?? "";
    }

References GetStr().

Referenced by SourceData< T, T2 >.GetString(), and ExcelData.Override().

GetStringArray()

static string[] ExcelParser.GetStringArray ( int  id )

inlinestatic

Definition at line 92 of file ExcelParser.cs.

    {
        string str = GetStr(id);
        if (str != null)
        {
            return str.Split(',');
        }
        return new string[0];
    }

References GetStr().

Referenced by SourceData< T, T2 >.GetStringArray().

IsNull()

static bool ExcelParser.IsNull ( ICell  cell )

inlinestatic

Definition at line 10 of file ExcelParser.cs.

    {
        if (cell != null && cell.CellType != CellType.Blank)
        {
            return cell.CellType == CellType.Unknown;
        }
        return true;
    }

Referenced by GetStr().

Member Data Documentation

row

IRow ExcelParser.row

static

Definition at line 6 of file ExcelParser.cs.

Referenced by GetBool(), GetInt(), GetStr(), and GetString().

rowDefault

IRow ExcelParser.rowDefault

static

Definition at line 8 of file ExcelParser.cs.

Referenced by GetStr().

---

The documentation for this class was generated from the following file:

• Elin/Plugins.basecore/ExcelParser.cs