Fix vulnerability for insecure EPPlus test packages

Fixes: b/230278644

I also upgraded this to compile with .NET 10 and replaced FluentAssertions with AwesomeAssertions. I updated the versions of the packages because of the .NET update, but since this required no production code changes so I'm not planning on putting this library into production in AppSheet at this time.

Change-Id: I68675376307e754e1568068fc6e70697c8e928d6
Reviewed-on: https://gnocchi-internal-review.git.corp.google.com/c/third_party/epplus/+/288344
Autosubmit: Hughes Hilton <hugheshilton@google.com>
Reviewed-by: Trevor Ryland <tryland@google.com>

AppsheetEpplus/AppsheetEpplus.csproj

diff --git a/AppsheetEpplus/AppsheetEpplus.csproj b/AppsheetEpplus/AppsheetEpplus.csproj
index e8379f7..0b58b7a 100644
--- a/AppsheetEpplus/AppsheetEpplus.csproj
+++ b/AppsheetEpplus/AppsheetEpplus.csproj
@@ -1,7 +1,7 @@
 <Project Sdk="Microsoft.NET.Sdk">
   <PropertyGroup>
-    <TargetFramework>net8.0</TargetFramework>
+    <TargetFramework>net10.0</TargetFramework>
     <PackageId>Appsheet.AppsheetEpplus</PackageId>
-    <Version>1.0.9</Version>
+    <Version>1.0.10</Version>
   </PropertyGroup>
-</Project>
\ No newline at end of file
+</Project>

EpplusFormulaParser/EpplusFormulaParser.csproj

diff --git a/EpplusFormulaParser/EpplusFormulaParser.csproj b/EpplusFormulaParser/EpplusFormulaParser.csproj
index 366cd3d..af689a0 100644
--- a/EpplusFormulaParser/EpplusFormulaParser.csproj
+++ b/EpplusFormulaParser/EpplusFormulaParser.csproj
@@ -1,8 +1,8 @@
 <Project Sdk="Microsoft.NET.Sdk">
   <PropertyGroup>
-    <TargetFramework>net8.0</TargetFramework>
+    <TargetFramework>net10.0</TargetFramework>
     <PackageId>Appsheet.EpplusFormulaParser</PackageId>
-    <Version>1.0.0</Version>
+    <Version>1.0.1</Version>
     <Nullable>enable</Nullable>
   </PropertyGroup>
 </Project>

NetCoreTests/ExcelPackageTest.cs

diff --git a/NetCoreTests/ExcelPackageTest.cs b/NetCoreTests/ExcelPackageTest.cs
index 77a5c6b..471b935 100644
--- a/NetCoreTests/ExcelPackageTest.cs
+++ b/NetCoreTests/ExcelPackageTest.cs
@@ -1,7 +1,7 @@
 using System.IO;
 using System.Linq;
 using AppsheetEpplus;
-using FluentAssertions;
+using AwesomeAssertions;
 using Microsoft.VisualStudio.TestTools.UnitTesting;
 
 namespace NetCoreTests;

NetCoreTests/NetCoreTests.csproj

diff --git a/NetCoreTests/NetCoreTests.csproj b/NetCoreTests/NetCoreTests.csproj
index 6218500..7638819 100644
--- a/NetCoreTests/NetCoreTests.csproj
+++ b/NetCoreTests/NetCoreTests.csproj
@@ -1,19 +1,13 @@
 <Project Sdk="Microsoft.NET.Sdk">
   <PropertyGroup>
-    <TargetFramework>net8.0</TargetFramework>
+    <TargetFramework>net10.0</TargetFramework>
     <Nullable>enable</Nullable>
   </PropertyGroup>
   <ItemGroup>
-    <PackageReference Include="FluentAssertions" Version="6.6.0"/>
-    <PackageReference Include="MSTest.TestAdapter" Version="2.2.8"/>
-    <PackageReference Include="MSTest.TestFramework" Version="2.2.8"/>
-    <PackageReference Include="Microsoft.NET.Test.SDK" Version="17.1.0"/>
-    <PackageReference Include="System.Net.Http" Version="4.3.4" />
-    <PackageReference Include="System.Text.RegularExpressions" Version="4.3.1" />
+    <PackageReference Include="AwesomeAssertions" Version="9.3.0"/>
+    <PackageReference Include="MSTest" Version="4.0.2"/>
+    <ProjectReference Include="..\AppsheetEpplus\AppsheetEpplus.csproj" />
 
     <None Include="TestWorkbooks/**" CopyToOutputDirectory="PreserveNewest"/>
   </ItemGroup>
-  <ItemGroup>
-    <ProjectReference Include="..\AppsheetEpplus\AppsheetEpplus.csproj" />
-  </ItemGroup>
 </Project>

NetCoreTests/TimeTest.cs

diff --git a/NetCoreTests/TimeTest.cs b/NetCoreTests/TimeTest.cs
index a94ce94..055b39a 100644
--- a/NetCoreTests/TimeTest.cs
+++ b/NetCoreTests/TimeTest.cs
@@ -3,7 +3,7 @@
 using System.Linq;
 using System.Text;
 using AppsheetEpplus;
-using FluentAssertions;
+using AwesomeAssertions;
 using Microsoft.VisualStudio.TestTools.UnitTesting;
 
 namespace NetCoreTests;