巧用XML配置校验导入Excel的列数据格式

        /// <summary>
        /// 根据xml字典逐个单元格比较验证datatable数据格式
        /// </summary>
        /// <param name="dt">excel表格转化为的datatable</param>
        /// <param name="xmlpath">列名和列标题、格式化正则、格式类型xml配置文件路径</param>
        public static void comparecolumnformat(datatable dt, string xmlpath)
        {
            if (dt == null) return;
            xmldocument xmldoc = xmlutility.getxmldocument(xmlpath);
            xmlnode root = xmldoc.selectsinglenode("columnsseting");
            xmlnode subnode = root.selectsinglenode("columns");
            xmlnodelist subnodelist = subnode.childnodes;
            for (int i = 0; i < subnodelist.count; i++)
            {
                string colname = xmlutility.getelement(subnodelist[i], "columnname");
                string colchinese = xmlutility.getelement(subnodelist[i], "columnchinese");
                string regcontent = xmlutility.getelement(subnodelist[i], "regcontent");
                string coldatatype = xmlutility.getelement(subnodelist[i], "datatype");

                for (int j = 0; j < dt.rows.count; j++)
                {
                    if (dt.columns[i].columnname.equals(colname))
                    {
                        string curval = convert.tostring(dt.rows[j][i]);
                        regex reg = new regex(regcontent);
                        if (!reg.ismatch(curval))
                        {
                            throw new exception(string.format("当前表格中【{0}】的第【{1}】行数据【{2}】的格式不正确，应为【{3}】，\n请修正后继续。",
                                colchinese,
                                j + 1, curval, coldatatype));
                        }
                    }
                }
            }
        }