private void ManageData() { try { /*conf = ConfigClass.GetConfig(); * if (conf == null) * { * throw new Exception("Can not find folder scan."); * }*/ FileInfo f_edit = new FileInfo(txt_path_fileEdit.Text); List <EditDetailModel> listEdit = new List <EditDetailModel>(); //read file edit using (var stream = File.Open(f_edit.FullName, FileMode.Open, FileAccess.Read)) { // Auto-detect format, supports: // - Binary Excel files (2.0-2003 format; *.xls) // - OpenXml Excel files (2007 format; *.xlsx, *.xlsb) using (var reader = ExcelReaderFactory.CreateReader(stream)) { // Choose one of either 1 or 2: // 1. Use the reader methods do { while (reader.Read()) { //Console.WriteLine(reader.GetString(0)); EditDetailModel ed = new EditDetailModel(); ed.MaCode = reader.GetString(0) == null ? "" : reader.GetString(0); ed.NoiDungThayThe = reader.GetString(1) == null ? "" : reader.GetString(1); ed.Description = reader.GetString(2) == null ? "" : reader.GetString(2); listEdit.Add(ed); } } while (reader.NextResult()); } } //read file ho so FileInfo f_hoso = new FileInfo(txt_path_hosomau.Text); Document document = new Document(); document.LoadFromFile(f_hoso.FullName); for (int i = 1; i < listEdit.Count; i++) { document.Replace(listEdit[i].MaCode, listEdit[i].NoiDungThayThe, false, true); } if (!string.IsNullOrEmpty(txt_exportFileName.Text)) { document.SaveToFile(txt_path_result.Text + txt_exportFileName.Text + ".docx", FileFormat.Docx); } else { throw new Exception("Invalid File Name !!!"); } //System.Diagnostics.Process.Start("Replace.docx"); //bgW_ManageData.ReportProgress(0); result = "Success"; UpdateDefaultText(); } catch (Exception ex) { //SetResult(ex.Message); result = ex.Message; return; } }
static void Main(string[] args) { try { conf = ConfigClass.GetConfig(); if (conf == null) { throw new Exception("Can not find folder scan."); } Console.WriteLine("Folder ho so :" + conf.short_part_hosomau); Console.WriteLine("Folder file edit :" + conf.short_part_fileEdit); FileInfo f_edit = new FileInfo(Environment.CurrentDirectory + conf.short_part_fileEdit); List <EditDetailModel> listEdit = new List <EditDetailModel>(); //read file edit using (var stream = File.Open(f_edit.FullName, FileMode.Open, FileAccess.Read)) { // Auto-detect format, supports: // - Binary Excel files (2.0-2003 format; *.xls) // - OpenXml Excel files (2007 format; *.xlsx, *.xlsb) using (var reader = ExcelReaderFactory.CreateReader(stream)) { // Choose one of either 1 or 2: // 1. Use the reader methods do { while (reader.Read()) { count++; //Console.WriteLine(reader.GetString(0)); EditDetailModel ed = new EditDetailModel(); ed.MaCode = reader.GetString(0) == null ? "" : reader.GetString(0); ed.NoiDungThayThe = reader.GetString(1) == null ? "" : reader.GetString(1); ed.Description = reader.GetString(2) == null ? "" : reader.GetString(2); listEdit.Add(ed); } } while (reader.NextResult()); } } //read file ho so FileInfo f_hoso = new FileInfo(Environment.CurrentDirectory + conf.short_part_hosomau); Document document = new Document(); document.LoadFromFile(f_hoso.FullName); for (int i = 1; i < listEdit.Count; i++) { document.Replace(listEdit[i].MaCode, listEdit[i].NoiDungThayThe, false, true); } document.SaveToFile(conf.folder_result + "Replace.docx", FileFormat.Docx); //System.Diagnostics.Process.Start("Replace.docx"); Console.WriteLine("Done"); Console.ReadLine(); } catch (Exception ex) { Console.WriteLine(ex.Message + "\n " + count); Console.ReadLine(); return; } Console.ReadLine(); }