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 string	ToLetterId (int id)

static void	ReportIllFormat< T > (int id)

static string	GetRowHeaderDiff (IReadOnlyDictionary< string, int > mapping, IReadOnlyDictionary< string, int > header)

static void	ClearStaticRows ()

Static Public Attributes
static string	path

static IRow	row

static IRow	rowDefault

static IRow	rowHeader

static bool	allowTrimming

Detailed Description

Definition at line 8 of file ExcelParser.cs.

Member Function Documentation

◆ ClearStaticRows()

static void ExcelParser.ClearStaticRows ( )

inlinestatic

Definition at line 264 of file ExcelParser.cs.

    {
        row = null;
        rowDefault = null;
        rowHeader = null;
        allowTrimming = false;
    }

References allowTrimming, row, rowDefault, and rowHeader.

◆ GetBool() [1/2]

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

inlinestatic

Definition at line 66 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 53 of file ExcelParser.cs.

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

References GetStr().

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

◆ GetDouble()

static double ExcelParser.GetDouble ( int id )

inlinestatic

Definition at line 72 of file ExcelParser.cs.

    {
        string str = GetStr(id);
        if (str.IsEmpty())
        {
            return 0.0;
        }
        if (!double.TryParse(str, out var result))
        {
            ReportIllFormat<double>(id);
        }
        return result;
    }

References GetStr().

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

◆ GetFloat()

static float ExcelParser.GetFloat ( int id )

inlinestatic

Definition at line 86 of file ExcelParser.cs.

    {
        string str = GetStr(id);
        if (str.IsEmpty())
        {
            return 0f;
        }
        if (!float.TryParse(str, out var result))
        {
            ReportIllFormat<float>(id);
        }
        return result;
    }

References GetStr().

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

◆ GetFloatArray()

static float[] ExcelParser.GetFloatArray ( int id )

inlinestatic

Definition at line 100 of file ExcelParser.cs.

    {
        string str = GetStr(id);
        if (str.IsEmpty())
        {
            return Array.Empty<float>();
        }
        string[] array = str.Split(',');
        float[] array2 = new float[array.Length];
        for (int i = 0; i < array.Length; i++)
        {
            if (!float.TryParse(array[i], out array2[i]))
            {
                ReportIllFormat<float>(id);
                array2[i] = 0f;
            }
        }
        return array2;
    }

References GetStr().

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

◆ GetInt() [1/2]

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

inlinestatic

Definition at line 47 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 29 of file ExcelParser.cs.

    {
        string str = GetStr(id);
        if (str.IsEmpty())
        {
            return 0;
        }
        if (!int.TryParse(str, out var result))
        {
            if (float.TryParse(str, out var result2))
            {
                return (int)result2;
            }
            ReportIllFormat<int>(id);
        }
        return result;
    }

References GetStr().

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

◆ GetIntArray()

static int[] ExcelParser.GetIntArray ( int id )

inlinestatic

Definition at line 120 of file ExcelParser.cs.

    {
        string str = GetStr(id);
        if (str.IsEmpty())
        {
            return Array.Empty<int>();
        }
        string[] array = str.Split(',');
        int[] array2 = new int[array.Length];
        for (int i = 0; i < array.Length; i++)
        {
            if (!int.TryParse(array[i], out array2[i]))
            {
                if (float.TryParse(array[i], out var result))
                {
                    array2[i] = (int)result;
                    continue;
                }
                ReportIllFormat<int>(id);
                array2[i] = 0;
            }
        }
        return array2;
    }

References GetStr().

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

◆ GetRowHeaderDiff()

static string ExcelParser.GetRowHeaderDiff	(	IReadOnlyDictionary< string, int >	mapping,
		IReadOnlyDictionary< string, int >	header
	)

inlinestatic

Definition at line 239 of file ExcelParser.cs.

    {
        StringBuilder stringBuilder = new StringBuilder();
        List<KeyValuePair<string, int>> list = mapping.OrderBy((KeyValuePair<string, int> c) => c.Value).ToList();
        int num = list.Max((KeyValuePair<string, int> c) => c.Key.Length);
        foreach (KeyValuePair<string, int> item in list)
        {
            item.Deconstruct(out var key, out var value);
            string text = key;
            int index = value;
            int value2;
            bool num2 = header.TryGetValue(text, out value2);
            string text2 = ((num2 && value2 != index) ? $"maybe {value2 + 1,2}/{ToLetterId(value2)} {text}" : "");
            if (!num2)
            {
                text2 = "<missing>";
            }
            string text3 = header.FirstOrDefault((KeyValuePair<string, int> c) => c.Value == index).Key ?? "<missing>";
            text3 = text3.PadRight(num + 3);
            string text4 = text.PadRight(num);
            stringBuilder.AppendLine($"{index + 1,2}/{ToLetterId(index),2}: {text4} -> {text3} {text2}");
        }
        return stringBuilder.ToString();
    }

References $, item, and Key.

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

◆ GetStr()

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

inlinestatic

Definition at line 171 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;
        }
        if (!allowTrimming)
        {
            return cell.StringCellValue;
        }
        return cell.StringCellValue.Trim();
    }

References allowTrimming, 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 165 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 160 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 145 of file ExcelParser.cs.

    {
        string str = GetStr(id);
        if (str != null)
        {
            if (!allowTrimming)
            {
                return str.Split(',');
            }
            return (from c in str.Split(',')
                select c.Trim()).ToArray();
        }
        return Array.Empty<string>();
    }

References allowTrimming, and GetStr().

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

◆ IsNull()

static bool ExcelParser.IsNull ( ICell cell )

inlinestatic

Definition at line 20 of file ExcelParser.cs.

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

Referenced by GetStr().

◆ ReportIllFormat< T >()

static void ExcelParser.ReportIllFormat< T > ( int id )

inlinestatic

Definition at line 219 of file ExcelParser.cs.

    {
        StringBuilder stringBuilder = new StringBuilder();
        string name = typeof(T).Name;
        ICell cell = row?.Cells.TryGet(id, returnNull: true);
        IRow obj = row;
        string value = ((obj != null && obj.RowNum >= 3) ? $", default:'{rowDefault?.Cells.TryGet(id, returnNull: true)}'" : ", SourceData begins at the 4th row. 3rd row is the default value row.");
        stringBuilder.AppendLine("#source ill-format file: " + path);
        object[] array = new object[5];
        IRow obj2 = row;
        array[0] = ((obj2 != null) ? new int?(obj2.RowNum + 1) : null);
        array[1] = id + 1;
        array[2] = ToLetterId(id);
        array[3] = name;
        array[4] = cell;
        stringBuilder.Append(string.Format("row#{0}, cell#{1}/#{2}, expected:'{3}', read:'{4}'", array));
        stringBuilder.AppendLine(value);
        Debug.LogWarning(stringBuilder);
    }

References $, Debug, path, row, and ToLetterId().

◆ ToLetterId()

static string ExcelParser.ToLetterId ( int id )

inlinestatic

Definition at line 207 of file ExcelParser.cs.

    {
        string text = "";
        while (id >= 0)
        {
            text = (char)(id % 26 + 65) + text;
            id /= 26;
            id--;
        }
        return text;
    }

Referenced by ReportIllFormat< T >().

Member Data Documentation

◆ allowTrimming

bool ExcelParser.allowTrimming

static

Definition at line 18 of file ExcelParser.cs.

Referenced by ClearStaticRows(), GetStr(), and GetStringArray().

◆ path

string ExcelParser.path

static

Definition at line 10 of file ExcelParser.cs.

Referenced by ReportIllFormat< T >().

◆ row

IRow ExcelParser.row

static

Definition at line 12 of file ExcelParser.cs.

Referenced by ClearStaticRows(), GetBool(), GetInt(), GetStr(), GetString(), and ReportIllFormat< T >().

◆ rowDefault

IRow ExcelParser.rowDefault

static

Definition at line 14 of file ExcelParser.cs.

Referenced by ClearStaticRows(), and GetStr().

◆ rowHeader

IRow ExcelParser.rowHeader

static

Definition at line 16 of file ExcelParser.cs.

Referenced by ClearStaticRows().

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

Elin/Plugins.basecore/ExcelParser.cs

Static Public Member Functions

Static Public Attributes

Detailed Description

Member Function Documentation

◆ ClearStaticRows()

◆ GetBool() [1/2]

◆ GetBool() [2/2]

◆ GetDouble()

◆ GetFloat()

◆ GetFloatArray()

◆ GetInt() [1/2]

◆ GetInt() [2/2]

◆ GetIntArray()

◆ GetRowHeaderDiff()

◆ GetStr()

◆ GetString() [1/2]

◆ GetString() [2/2]

◆ GetStringArray()

◆ IsNull()

◆ ReportIllFormat< T >()

◆ ToLetterId()

Member Data Documentation

◆ allowTrimming

◆ path

◆ row

◆ rowDefault

◆ rowHeader