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 NoRetainMarkup_OmitsIt()
{
var dom = new HtmlDom(kVerySimpleBook, true);
var exporter = new SpreadsheetExporter();
var sheet = exporter.Export(dom);
var rows = sheet.ContentRows.ToList();
var offset = sheet.StandardLeadingColumns.Length;
Assert.That(rows[0].GetCell(offset).Content.Trim(), Is.EqualTo(
"This elephant is running amok. Causing much damage."));
}
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 RetainMarkup_KeepsIt()
{
var dom = new HtmlDom(kVerySimpleBook, true);
var exporter = new SpreadsheetExporter();
exporter.Params = new SpreadsheetExportParams()
{
RetainMarkup = true
};
var sheet = exporter.Export(dom);
var rows = sheet.ContentRows.ToList();
var offset = sheet.StandardLeadingColumns.Length;
Assert.That(rows[0].GetCell(offset).Content.Trim(), Is.EqualTo(
"<p><span id=\"e4bc05e5-4d65-4016-9bf3-ab44a0df3ea2\" class=\"bloom-highlightSegment\" recordingmd5=\"undefined\">This elephant is running amok.</span> <span id=\"i2ba966b6-4212-4821-9268-04e820e95f50\" class=\"bloom-highlightSegment\" recordingmd5=\"undefined\">Causing much damage.</span></p>"));
}
public void OneTimeSetUp()
{
_dom = new HtmlDom(SpreadsheetTests.kSimpleTwoPageBook, true);
AssertThatXmlIn.Dom(_dom.RawDom).HasSpecifiedNumberOfMatchesForXpath("//div[@lang='en']/p[text()='Riding on elephants can be risky.']", 1); // unchanged
var exporter = new SpreadsheetExporter();
_sheet = exporter.Export(_dom);
var indexDe = _sheet.ColumnForLang("de");
_sheet.Header.SetCell(indexDe, "[tpi]");
_sheet.ContentRows.First().SetCell(_sheet.ColumnForLang("en"), "<p>This elephant is running amok.</p>");
_sheet.ContentRows.Skip(2).First().SetCell(_sheet.ColumnForLang("fr"), "<p>Riding on French elephants can be very risky.</p>");
var importer = new SpreadsheetImporter(this._dom, _sheet);
InitializeImporter(importer);
importer.Import();
}
public static int Handle(SpreadsheetExportParameters options)
{
try
{
var dom = new HtmlDom(XmlHtmlConverter.GetXmlDomFromHtmlFile(options.BookPath, false));
var exporter = new SpreadsheetExporter();
if (!string.IsNullOrEmpty(options.ParamsPath))
{
exporter.Params = SpreadsheetExportParams.FromFile(options.ParamsPath);
}
var _sheet = exporter.Export(dom);
_sheet.WriteToFile(options.OutputPath);
return(0); // all went well
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace);
return(1);
}
}
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();
}
}
public static void Main()
{
Random generator = new Random(Seed: 32);
CompetitorResult[] results =
Enumerable.Repeat(-1, 20)
.Select(_ => CompetitorResult.GetRandom(generator))
.ToArray();
var exporter = new SpreadsheetExporter <CompetitorResult>("The best competition ever")
{
{ "Full Name", x => x.FullName },
{ "Total", x => x.Statuses.Select(y => y.Sum()).Sum().ToString() }
};
exporter.Add("problem1", x => x.Statuses[0].Select(Convert.ToString));
exporter.Add("problem2", x => x.Statuses[1].Select(Convert.ToString));
exporter.Add("problem3", x => x.Statuses[2].Select(Convert.ToString));
exporter.Export("wb.xlsx", data: results);
Process.Start("wb.xlsx");
}