/// <summary> /// 导出文件 /// </summary> /// <param name="fileUrl">保存位置</param> /// <param name="files">文件类型</param> public bool ExportFile(string fileUrl, string files) { if (dt == null && dt.Rows.Count > 0) { MessageCommon.ShowErr("结果集不能为空!"); } if (files == FileEnum.JsonFiles) { JsonUtilities jsonUtilities = new JsonUtilities(); return(jsonUtilities.SaveJson(dt, fileUrl)); } else if (files == FileEnum.ExcelFiles) { ExcelUtilities excelUtilities = new ExcelUtilities(); return(excelUtilities.ToExcel(dt, fileUrl)); } else if (files == FileEnum.XMLFiles) { XmlUtilities xmlUtilities = new XmlUtilities(); string xml = xmlUtilities.ConvertDataTableToXML(dt); return(xmlUtilities.SaveXml(xml, fileUrl)); } else { return(false); } }
/// <summary> /// Excel转Json操作 /// </summary> private void ExcelToXmls() { ExcelUtilities excelUtilities = new ExcelUtilities(); var data = excelUtilities.ExcelToDataTable(文件路径.Text); if (data != null && data.Rows.Count > 0) { XmlUtilities xmlUtilities = new XmlUtilities(); string xml = xmlUtilities.ConvertDataTableToXML(data); if (xmlUtilities.SaveXml(xml, 文件夹路径.Text)) { MessageCommon.ShowInf("转换成功"); } else { MessageCommon.ShowErr("转换失败"); } } }