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.");
}
