diff --git a/ClosedXML_Sandbox/ClosedXML_Sandbox.csproj b/ClosedXML_Sandbox/ClosedXML_Sandbox.csproj
index 3581c95..2b2d041 100644
--- a/ClosedXML_Sandbox/ClosedXML_Sandbox.csproj
+++ b/ClosedXML_Sandbox/ClosedXML_Sandbox.csproj
@@ -63,6 +63,9 @@
+
+ PreserveNewest
+
diff --git a/ClosedXML_Sandbox/PerformanceRunner.cs b/ClosedXML_Sandbox/PerformanceRunner.cs
index 97d3a31..2d4f570 100644
--- a/ClosedXML_Sandbox/PerformanceRunner.cs
+++ b/ClosedXML_Sandbox/PerformanceRunner.cs
@@ -17,7 +17,8 @@
Console.WriteLine("Action done in " + stopwatch.Elapsed);
}
- const int rowCount = 5000;
+ private const int rowCount = 5000;
+
public static void RunInsertTable()
{
var rows = new List();
@@ -39,6 +40,16 @@
EmulateSave(workbook);
}
+ public static void OpenTestFile()
+ {
+ using (var wb = new XLWorkbook("test.xlsx"))
+ {
+ var ws = wb.Worksheets.First();
+ var cell = ws.FirstCellUsed();
+ Console.WriteLine(cell.Value);
+ }
+ }
+
private static void CreateMergedCell(IXLWorksheet worksheet)
{
worksheet.Cell(rowCount + 2, 1).Value = "Merged cell";
diff --git a/ClosedXML_Sandbox/Program.cs b/ClosedXML_Sandbox/Program.cs
index 0cb47d1..9136cbe 100644
--- a/ClosedXML_Sandbox/Program.cs
+++ b/ClosedXML_Sandbox/Program.cs
@@ -2,11 +2,17 @@
namespace ClosedXML_Sandbox
{
- class Program
+ internal class Program
{
private static void Main(string[] args)
{
+ Console.WriteLine("Running {0}", "OpenTestFile");
+ PerformanceRunner.TimeAction(PerformanceRunner.OpenTestFile);
+ Console.WriteLine();
+
+ Console.WriteLine("Running {0}", "RunInsertTable");
PerformanceRunner.TimeAction(PerformanceRunner.RunInsertTable);
+ Console.WriteLine();
Console.WriteLine("Press any key to continue");
Console.ReadKey();
diff --git a/ClosedXML_Sandbox/test.xlsx b/ClosedXML_Sandbox/test.xlsx
new file mode 100644
index 0000000..296c174
--- /dev/null
+++ b/ClosedXML_Sandbox/test.xlsx
Binary files differ