public void TestExport() { var customers = ExcelImport.Import <CustomerTest>(@"C:\Users\Administrator\Desktop\客户导入.xlsx"); var bytes = ExcelExport.Export(customers, @"C:\Users\Administrator\Desktop\客户导出模板.xlsx", "客户导出", 1, new List <int>() { 6 }); using (var fs = new FileStream(@"C:\Users\Administrator\Desktop\客户导出.xlsx", FileMode.OpenOrCreate, FileAccess.Write)) { fs.Write(bytes, 0, bytes.Length); } }
private void buttonImport_Click(object sender, EventArgs e) { openFileDialog1.FileName = String.Empty; if (openFileDialog1.ShowDialog() == DialogResult.OK) { path = openFileDialog1.FileName; } using (context) { ExcelImport excelImport = new ExcelImport(); excelImport.Import(context, path); } }
/// <summary> /// Excelを作成 /// </summary> private void ExcelExport() { IWorkbook book = new HSSFWorkbook(); //Excelを作成 ISheet sheet = book.CreateSheet("PlayerParameter"); //シートを作成 CreateHeaderRow(book, sheet); //ヘッダー行を作成 AddToExcel(book, sheet); //エクセルに保存 //エクセルファイルを生成 using (var fs = new FileStream(file, FileMode.OpenOrCreate, FileAccess.Write)) { book.Write(fs); } ExcelImport.Import(file, 0); }
public void TestContractImport() { var contracts = ExcelImport.Import <ContractTest>(@"C:\Users\Administrator\Desktop\合同分城市平均天数.xlsx", 4); var groups = contracts.Where(p => p.Cycle.IndexOf("0000-00-00 00:00:00") == -1).GroupBy(p => p.BuildingNo).Select(g => new { No = g.Key, Count = g.Count() }); var buildingNos = groups.Where(p => p.Count > 1).Select(p => p.No).ToList(); contracts = contracts.Where(p => buildingNos.Contains(p.BuildingNo)).ToList(); foreach (var item in contracts) { var times = item.Cycle.Split('至'); item.BeginTime = DateTime.Parse(times[0]); item.EndTime = DateTime.Parse(times[1]); } var treatContracts = new List <ContractTest>(); foreach (var no in buildingNos) { var list = contracts.Where(p => p.BuildingNo == no).ToList(); for (int i = 0; i < list.Count; i++) { for (int j = i + 1; j < list.Count; j++) { if (!list[i].TimeRangeOnly(list[j])) { if (!treatContracts.Any(p => p.ID == list[i].ID)) { treatContracts.Add(list[i]); } treatContracts.Add(list[j]); } } } } var bytes = ExcelExport.Export(treatContracts, @"C:\Users\Administrator\Desktop\合同分城市到处模板.xlsx", "Sheet1", 0); using (var fs = new FileStream(@"C:\Users\Administrator\Desktop\合同分城市导出.xlsx", FileMode.OpenOrCreate, FileAccess.Write)) { fs.Write(bytes, 0, bytes.Length); } }
static void Main(string[] args) { string excelFile = null; string dataFile = null; Side side = Side.All; string headModel = null; string dataFormatStr = null; string dataType = "List<Dictionary<string, object>>"; optionSet = new OptionSet() { { "excelFile=", "Excel folder path", s => excelFile = s }, { "dataFile=", "The code out folder", s => dataFile = s }, { "headModel=", "The last export info.", s => headModel = s }, { "side=", "The last export info.", s => side = (Side)Enum.Parse(typeof(Side), s) }, { "dataFormat=", "Data format", s => dataFormatStr = s }, { "dataType=", "Data Type", s => dataType = s }, }; optionSet.Parse(args); if (string.IsNullOrEmpty(excelFile)) { Console.WriteLine("Excel file is null"); return; } if (string.IsNullOrEmpty(dataFile)) { Console.WriteLine("Code out path is null"); return; } if (!Path.IsPathRooted(excelFile)) { excelFile = Path.Combine(Directory.GetCurrentDirectory(), excelFile); } if (!Path.IsPathRooted(dataFile)) { dataFile = Path.Combine(Directory.GetCurrentDirectory(), dataFile); } ImportSetting setting = new ImportSetting(); if (!string.IsNullOrEmpty(headModel)) { switch (headModel) { case "Normal": setting.headModel = HeadModel.CreateNormalModel(); break; case "Simple": setting.headModel = HeadModel.CreateSimpleModel(); break; //use default have side case "All": default: break; } } ExcelImport import = new ExcelImport(setting); import.side = side; DataFormat dataFormat = (DataFormat)Enum.Parse(typeof(DataFormat), dataFormatStr); import.dataFormat = dataFormat; import.dataType = TypeInfo.Parse(dataType).ToSystemType(); import.Import(dataFile, excelFile); }
public void TestImport() { var customers = ExcelImport.Import <CustomerTest>(@"C:\Users\Administrator\Desktop\客户导入.xlsx"); }