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