文件名称:
wpf的Excel分类导出数据（Aspose）
开发工具:
文件大小: 6mb
下载次数: 0
上传时间: 2013-05-06
详细说明：
对学习wpf的朋友们有一定的帮助 /// /// 工参表分割类, 按区域进行对数据行进行分割 /// public class AreaSplit { public event EventHandler Opening; public event EventHandler ErrorHappened; public event EventHandler BeginSplit; public event EventHandler Splitting; public event EventHandler Saving; public event EventHandler Splitted; private List m_ColNames; /// /// 执行工参表分割 /// /// 原始工参文件 /// 分割后输出所在总目录 public void StartSplit(string sourceFile, string outPath) { try { Dictionary dict = this.SplitToDictionary(sourceFile); if (dict == null) return; this.SaveToExcels(outPath, dict); } catch (Exception ex) { if (ErrorHappened != null) ErrorHappened(this, new StringEventArgs(ex.Message)); } } /// /// 将工参文件分割为Dictionary /// private Dictionary SplitToDictionary(string sourceFile) { if (!File.Exists(sourceFile)) { if (ErrorHappened != null) ErrorHappened(this, new StringEventArgs("指定路径的文件不存在")); return null; } if (this.Opening != null) this.Opening(this, new StringEventArgs("正在读取原始工参表 ...")); Workbook wb = new Workbook(sourceFile); if (wb.Worksheets.Count == 0) { if (ErrorHappened != null) ErrorHappened(this, new StringEventArgs("缺少有效的工作表")); return null; } Worksheet ws = wb.Worksheets[0]; string areaKey = "区域"; int areaPos = -1; // 获取区域所在列号 this.m_ColNames = new List(); int rowCount = ws.Cells.MaxDataRow + 1; int colCount = ws.Cells.MaxDataColumn + 1; for (int i = 0; i < colCount; i++) { string str = ws.Cells[0, i].StringValue; if (str == null) continue; if (str.Equals(areaKey)) { areaPos = i; } this.m_ColNames.Add(str); } if (areaPos == -1) { if (ErrorHappened != null) ErrorHappened(this, new StringEventArgs("找不到正确的区域列")); return null; } if (BeginSplit != null) BeginSplit(this, new Int32EventArgs(rowCount)); Dictionary dict = new Dictionary(); for (int i = 1; i < rowCount; i++) { string area = ws.Cells[i, areaPos].StringValue; if (string.IsNullOrEmpty(area)) area = "未知区域"; if (!dict.ContainsKey(area)) { DataTable dt = this.GetTable(colCount); dict.Add(area, dt); } DataRow row = dict[area].NewRow(); for (int j = 0; j < colCount; j++) { row[j] = ws.Cells[i, j].StringValue; } dict[area].Rows.Add(row); if (Splitting != null) Splitting(this, new Int32EventArgs(i)); } return dict; } /// /// 将分割后的数据，按区域分别保存为Excel文档 /// /// /// private void SaveToExcels(string outPath, Dictionary dict) { foreach (string key in dict.Keys) { if (Saving != null) this.Saving(this, new StringEventArgs("正在保存 " + key + "工参表")); DataTable dt = dict[key]; if (outPath.Equals("")) outPath = AppDomain.CurrentDomain.BaseDirectory + "分割后工参"; string dir = outPath + "\\" + key; if (!Directory.Exists(dir)) Directory.CreateDirectory(dir); string fn = dir + "\\" + key + "_" + DateTime.Now.ToString("yyyyMMdd") + ".xlsx"; if (File.Exists(fn)) File.Delete(fn); Workbook wb = new Workbook(); wb.Worksheets.Clear(); Worksheet ws = wb.Worksheets.Add(key + "工参表"); for (int i=0; i
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
