public void OneTimeSetUp()
{
var origDom = new HtmlDom(roundtripTestBook, true);
_roundtrippedDom = new HtmlDom(roundtripTestBook, true); //Will get imported into
// We want to test that exporting a book with branding in the data-dive and importing into a book with no branding
// does not reinstate the branding. So we need to remove it from the pre-import DOM, which is otherwise
// (for this test) the same as what we originally exported.
var branding =
_roundtrippedDom.SelectSingleNode("//div[@data-book='outside-back-cover-branding-bottom-html']");
branding.ParentNode.RemoveChild(branding);
AssertThatXmlIn.Dom(origDom.RawDom).HasSpecifiedNumberOfMatchesForXpath("//div[@id='simpleFormattingTest']", 1);
AssertThatXmlIn.Dom(origDom.RawDom).HasSpecifiedNumberOfMatchesForXpath("//div[@id='nestedFormattingTest']", 1);
var mockLangDisplayNameResolver = new Mock <ILanguageDisplayNameResolver>();
mockLangDisplayNameResolver.Setup(x => x.GetLanguageDisplayName("en")).Returns("English");
var exporter = new SpreadsheetExporter(mockLangDisplayNameResolver.Object);
exporter.Params = new SpreadsheetExportParams();
_sheetFromExport = exporter.Export(origDom, "fakeImagesFolderpath");
using (var tempFile = TempFile.WithExtension("xslx"))
{
_sheetFromExport.WriteToFile(tempFile.Path);
var sheet = InternalSpreadsheet.ReadFromFile(tempFile.Path);
var importer = new SpreadsheetImporter(null, _roundtrippedDom);
importer.Import(sheet);
}
}
public void OneTimeSetUp()
{
var dom = new HtmlDom(kSimpleTwoPageBook, true);
_exporter = new SpreadsheetExporter();
_sheetFromExport = _exporter.Export(dom);
_rowsFromExport = _sheetFromExport.ContentRows.ToList();
using (var tempFile = TempFile.WithExtension("xslx"))
{
_sheetFromExport.WriteToFile(tempFile.Path);
_sheetFromFile = InternalSpreadsheet.ReadFromFile(tempFile.Path);
_rowsFromFile = _sheetFromFile.ContentRows.ToList();
}
}
public void RichtextNotUsedWhenNotNeeded()
{
using (var tempFile = TempFile.WithExtension("xslx"))
{
_sheetFromExport.WriteToFile(tempFile.Path);
var info = new FileInfo(tempFile.Path);
using (var package = new ExcelPackage(info))
{
var worksheet = package.Workbook.Worksheets[0];
int c = _sheetFromExport.StandardLeadingColumns.Length;
for (int r = 0; r < 4; r++)
{
ExcelRange currentCell = worksheet.Cells[r + 1, c + 1];
Assert.That(!currentCell.IsRichText);
}
}
}
}
public void OneTimeSetUp()
{
var dom = new HtmlDom(kSimpleTwoPageBook, true);
var langCodesToLangNames = new Dictionary <string, string>();
langCodesToLangNames.Add("en", "English");
langCodesToLangNames.Add("fr", "French");
langCodesToLangNames.Add("de", "German");
var mockLangDisplayNameResolver = new Mock <ILanguageDisplayNameResolver>();
mockLangDisplayNameResolver.Setup(x => x.GetLanguageDisplayName("en")).Returns("English");
mockLangDisplayNameResolver.Setup(x => x.GetLanguageDisplayName("fr")).Returns("French");
mockLangDisplayNameResolver.Setup(x => x.GetLanguageDisplayName("de")).Returns("German");
_exporter = new SpreadsheetExporter(mockLangDisplayNameResolver.Object);
_sheetFromExport = _exporter.Export(dom, "fakeImagesFolderpath");
_rowsFromExport = _sheetFromExport.ContentRows.ToList();
using (var tempFile = TempFile.WithExtension("xslx"))
{
_sheetFromExport.WriteToFile(tempFile.Path);
_sheetFromFile = InternalSpreadsheet.ReadFromFile(tempFile.Path);
_rowsFromFile = _sheetFromFile.ContentRows.ToList();
}
}