public void TestCreateExcelSpreadSheetQuickClient_FilepathError() { // string.empty Assert.Throws <ArgumentNullException>(() => { var client = new ClientBuilder().Build(ExcelSpreadSheetSettings.Default(), string.Empty); }).Message.Is("Value cannot be null. (Parameter 'filePath')"); // "" Assert.Throws <ArgumentNullException>(() => { var client = new ClientBuilder().Build(ExcelSpreadSheetSettings.Default(), ""); }).Message.Is("Value cannot be null. (Parameter 'filePath')"); // null Assert.Throws <ArgumentNullException>(() => { var client = new ClientBuilder().Build(ExcelSpreadSheetSettings.Default(), null); }).Message.Is("Value cannot be null. (Parameter 'filePath')"); // brank Assert.Throws <ArgumentNullException>(() => { var client = new ClientBuilder().Build(ExcelSpreadSheetSettings.Default(), " "); }).Message.Is("Value cannot be null. (Parameter 'filePath')"); }
public void TestCreateExcelSpreadSheetQuickClient_SettingsError_SheetName() { // setup var settings = new ExcelSpreadSheetSettings(); // string.Empty Assert.Throws <ApplicationException>(() => { settings.SheetName = string.Empty; var client = new ClientBuilder().Build(settings, "./sample.xlsx"); }).Message.Is("The sheet name has not been set."); // "" Assert.Throws <ApplicationException>(() => { settings.SheetName = ""; var client = new ClientBuilder().Build(settings, "./sample.xlsx"); }).Message.Is("The sheet name has not been set."); // null Assert.Throws <ApplicationException>(() => { settings.SheetName = null; var client = new ClientBuilder().Build(settings, "./sample.xlsx"); }).Message.Is("The sheet name has not been set."); // brank Assert.Throws <ApplicationException>(() => { settings.SheetName = " "; var client = new ClientBuilder().Build(settings, "./sample.xlsx"); }).Message.Is("The sheet name has not been set."); }
public void TestCreateInstance() { // setup var settings = new ExcelSpreadSheetSettings(); settings.SheetName.IsNull(); settings.ReadHeaderInfo.Is(ReadHeaderInfo.Property); }
public void TestCreateDefaultInstance() { // setup var settings = ExcelSpreadSheetSettings.Default(); settings.SheetName.Is("Sheet1"); settings.ReadHeaderInfo.Is(ReadHeaderInfo.Property); }
/// <summary> /// On Execute the command. /// </summary> protected override void OnExecute() { var list = Enumerable.Range(0, 200).Select(i => $"Sample_Message-{i}").ToList(); var client = new ClientBuilder().Build(ExcelSpreadSheetSettings.Default(), OutputFilePath); if (!Directory.Exists(BaseOutputDirectory)) { Directory.CreateDirectory(BaseOutputDirectory); } if (File.Exists(OutputFilePath)) { Console.WriteLine("The file already exists. Please check the file."); } else { client.Export(list); } }
public void TestCheckValidate_ReadHeaderInfo() { // setup var settings = ExcelSpreadSheetSettings.Default(); settings.Validate(); // field settings.ReadHeaderInfo = ReadHeaderInfo.Field; settings.ReadHeaderInfo.Is(ReadHeaderInfo.Field); // prop and field settings.ReadHeaderInfo = ReadHeaderInfo.PropertyAndField; settings.ReadHeaderInfo.Is(ReadHeaderInfo.PropertyAndField); // prop settings.ReadHeaderInfo = ReadHeaderInfo.Property; settings.ReadHeaderInfo.Is(ReadHeaderInfo.Property); }
/// <summary> /// On Execute the command. /// </summary> protected override void OnExecute() { var clients = new List <IQuickClient>(); var pSettings = ExcelSpreadSheetSettings.Default(); var propClient = new ClientBuilder().Build(pSettings, Path.Combine(OutputFilePath, "prop_example.xlsx")); clients.Add(propClient); var fSettings = ExcelSpreadSheetSettings.Default(); fSettings.ReadHeaderInfo = ReadHeaderInfo.Field; var fildClient = new ClientBuilder().Build(fSettings, Path.Combine(OutputFilePath, "field_example.xlsx")); clients.Add(fildClient); var pfSettings = ExcelSpreadSheetSettings.Default(); pfSettings.ReadHeaderInfo = ReadHeaderInfo.PropertyAndField; var pAndFClient = new ClientBuilder().Build(pfSettings, Path.Combine(OutputFilePath, "prop_field_example.xlsx")); clients.Add(pAndFClient); var list = createOutputModel(); if (!Directory.Exists(OutputFilePath)) { Directory.CreateDirectory(OutputFilePath); } if (File.Exists(OutputFilePath)) { Console.WriteLine("The file already exists. Please check the file."); } else { clients.AsParallel().ForAll(c => c.Export(list)); } }
public void TestCheckValidate_SheetName() { // setup var settings = ExcelSpreadSheetSettings.Default(); settings.Validate(); // string.Emtpy settings.SheetName = string.Empty; Assert.Throws <ApplicationException>(() => { settings.Validate(); }).Message.Is("The sheet name has not been set."); // "" settings.SheetName = ""; Assert.Throws <ApplicationException>(() => { settings.Validate(); }).Message.Is("The sheet name has not been set."); // null settings.SheetName = null; Assert.Throws <ApplicationException>(() => { settings.Validate(); }).Message.Is("The sheet name has not been set."); // brank settings.SheetName = " "; Assert.Throws <ApplicationException>(() => { settings.Validate(); }).Message.Is("The sheet name has not been set."); }