public void Должен_заменить_маркер_на_текст()
{
//assign
var excelHelper = new ExcelHelper();
var templatePath = "Assets/Templates/one-marker.xlsx";
using var workbook = new XLWorkbook(templatePath);
var injection = new TextInjection {
Resource = new TextResourceObject("text")
};
var documentInjectorOptions = new DocumentInjectorOptions
{
ResourceInjector = new VariantResourceInjector(),
InjectionProvider = new FuncInjectionProvider(_ => injection),
MarkerOptions = new MarkerOptions("{", ".", "}"),
};
var documentInjector = new DocumentInjector(documentInjectorOptions);
//act
documentInjector.Inject(workbook);
//assert
var values = excelHelper.ReadCellRangeValues(workbook, (1, 1, 1), (1, 1, 1));
values[0][0].Should().Be("text");
}
public void Должен_вставить_изображение_и_удалить_маркер_из_документа()
{
//assign
var excelHelper = new ExcelHelper();
using var workbook = new XLWorkbook("Assets/Templates/one-marker.xlsx");
var imageBytes = File.ReadAllBytes("Assets/Images/checker.png");
var injection = new ImageInjection {
Resource = new ImageResourceObject(imageBytes)
};
var documentInjectorOptions = new DocumentInjectorOptions
{
ResourceInjector = new VariantResourceInjector(),
InjectionProvider = new FuncInjectionProvider(_ => injection),
MarkerOptions = new MarkerOptions("{", ".", "}"),
};
var documentInjector = new DocumentInjector(documentInjectorOptions);
//act
documentInjector.Inject(workbook);
//assert
var values = excelHelper.ReadCellRangeValues(workbook, (1, 1, 1), (1, 1, 1));
values[0][0].Should().Be(""); //проверяем что маркер удален из документа
}
public TemplateBuilder InjectData(DocumentInjectorOptions options)
{
var documentInjector = new DocumentInjector(options);
documentInjector.Inject(_workbook);
return(this);
}
public void Должен_заменить_маркер_на_таблицу()
{
//assign
var excelHelper = new ExcelHelper();
var templatePath = "Assets/Templates/one-marker.xlsx";
using var workbook = new XLWorkbook(templatePath);
var resourceObject = new TableResourceObject(new List <List <object> > {
new List <object> {
1, 2
},
new List <object> {
3, 4
},
});
var injection = new TableInjection {
Resource = resourceObject, LayoutShift = LayoutShiftType.None
};
var documentInjectorOptions = new DocumentInjectorOptions
{
ResourceInjector = new VariantResourceInjector(),
InjectionProvider = new FuncInjectionProvider(_ => injection),
MarkerOptions = new MarkerOptions("{", ".", "}"),
};
var documentInjector = new DocumentInjector(documentInjectorOptions);
//act
documentInjector.Inject(workbook);
//assert
var values = excelHelper.ReadCellRangeValues(workbook, (1, 1, 1), (2, 2, 2));
values[0][0].Should().Be(1);
values[0][1].Should().Be(2);
values[1][0].Should().Be(3);
values[1][1].Should().Be(4);
}