The type initializer for 'spr840' threw an exception in C#

I just ran the following code but it worked well on my side.

Workbook workbook = new Workbook();
workbook.LoadFromFile("Input.xlsx");
Worksheet sheet = workbook.Worksheets[0];
//Find all "Phone"
CellRange[] ranges = sheet.FindAllString("Phone", false, false);
foreach (CellRange range in ranges)
{
//Do things you want
}
workbook.SaveToFile("Output.xlsx", ExcelVersion.Version2013);

I supose you only add the spire.xls.dll, please remove it and then reference all the dlls: "Spire.Common.dll" "Spire.License.dll" "Spire.Pdf.dll" "Spire.XLS.dll" from the bin folder into your project and try again. Or you can use the following command in the NuGet Package Manager Console and press enter, it will automatically adds all of the above dlls.

Install-Package FreeSpire.XLS -Version 7.9.1

If it still does not work, let me know.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Leon D8y ago
Accepted answer
I just ran the following code but it worked well on my side.
Workbook workbook = new Workbook();

workbook.LoadFromFile("Input.xlsx");



Worksheet sheet = workbook.Worksheets[0];



//Find all "Phone"

CellRange[] ranges = sheet.FindAllString("Phone", false, false);



foreach (CellRange range in ranges)

{

    //Do things you want

}



workbook.SaveToFile("Output.xlsx", ExcelVersion.Version2013);

I supose you only add the spire.xls.dll, please remove it and then reference all the dlls: "Spire.Common.dll" "Spire.License.dll" "Spire.Pdf.dll" "Spire.XLS.dll" from the bin folder into your project and try again. Or you can use the following command in the NuGet Package Manager Console and press enter, it will automatically adds all of the above dlls.
Install-Package FreeSpire.XLS -Version 7.9.1
If it still does not work, let me know.