public void MainTest()
{
var excelWriter = new ExcelWriter();
int rowIndex = 1;
int colIndex = 1;
for (int i = 0; i < 5; i++)
{
var sheet = excelWriter.AddSheet("sheet" + i);
foreach (var row in rows)
{
foreach (var col in row.Columns)
{
sheet.AddCell(rowIndex, colIndex++, "default", "testvalue");
}
rowIndex++;
}
}
Stopwatch sp = new Stopwatch(); sp.Start();
excelWriter.Generate();
sp.Stop();
}
public void AddSheetTest()
{
var filename = TestUtility.OutputPath + "add-sheet-test.xlsx";
var sheetname = "Sheet2";
File.Delete(filename);
TimeSeries ts1 = TestUtility.CreateTimeSeries(10);
ExcelWriter w = new ExcelWriter(filename);
w.AddSheet(sheetname);
w.Write(ts1, sheetname);
ExcelReader r = new ExcelReader(filename);
var ts2 = r.GetTimeSeries(sheetname);
Assert.IsTrue(Enumerable.SequenceEqual(ts1.Times, ts2.Times));
Assert.IsTrue(Enumerable.SequenceEqual(ts1.Values, ts2.Values));
File.Delete(filename);
}
public void BasicTest()
{
string filePath = Path.Combine(TestContext.CurrentContext.TestDirectory,
$@"{DateTime.Now.ToString(CultureInfo.InvariantCulture).GetSafeFileName()}.xlsx");
CellBase[] nullArray = null;
using (var writer = new ExcelWriter(filePath))
{
writer.AddSheet("test_1")
.ApplyColumnWidths(100, 20, 20, 20)
.FreezeTopNRows(1)
.AddColumnFilter(1, 1)
.AddHeader("text_1", "datetime_1", "money_1", "count_1")
.AddRow(new StringCell(@"some /\ text"),
new DateTimeCell(DateTime.Now)
{
Bold = true, Strike = true, FontColor = ExcelColors.Red, BackgroundColor = ExcelColors.Green
},
new DecimalCell(555.77M)
{
BackgroundColor = ExcelColors.Blue
},
new IntegerCell(55))
.AddRow(new StringCell("more staff"),
new DateTimeCell(DateTime.UtcNow)
{
Bold = true, FontColor = ExcelColors.Red, BackgroundColor = ExcelColors.Green
},
new DecimalCell(999.77M)
{
BackgroundColor = ExcelColors.Blue
},
new IntegerCell(999))
.AddRow(nullArray)
.AddRow(null);
writer.AddSheet("test_2")
.AddHeader("text_2", "datetime_2", "money_2", "count_2")
.AddColumnFilters(1, 3, 1)
.AddRow(new StringCell("hi im here")
{
Bold = true
},
new DateTimeCell(DateTime.UtcNow)
{
FontColor = ExcelColors.Red
},
new DecimalCell(222.88M)
{
FontColor = ExcelColors.Green
},
new IntegerCell(1277));
writer.AddSheet("test_3")
.AddRow(new DecimalCell(222.88M), new DecimalCell(666M), new DecimalHorizontalSumCell(1, 2))
.AddRow(new DecimalCell(11M), new DecimalCell(22M), new DecimalHorizontalSumCell(1, 2))
.AddRow(new DecimalVerticalSumCell(1, 2), new DecimalVerticalSumCell(1, 2), new DecimalSumCell(1, 2, 1, 2))
.AddRow(new StringCell("a1"), new DecimalCell(5.5M), new StringCell("c1"), new StringCell("d1"))
.AddRow(new DateTimeCell(DateTime.UtcNow), new StringCell("b2"), new StringCell("c2"), new StringCell("d2"))
.AddRow(new DecimalCell(6.6M), new StringCell("b3"), new StringCell("c3"), new StringCell("d3"))
.AddRow(new StringCell("a4"), new DateTimeCell(DateTime.UtcNow), new StringCell("c4"), new StringCell("d4"))
.AddRow(new StringCell("a5"), new StringCell("b5"), new StringCell("c5"), new StringCell("d5"))
.MergeCells(4, 4, 1, 3)
.MergeCells(5, 6, 1, 1)
.MergeCells(7, 8, 1, 3);
}
}
public ExcelWriterTests()
{
_writer = new ExcelWriter();
_writer.AddSheet("test", defaultColWidth: _defaultColWidth);
}