I’m using the latest version of ClosedXML from NuGet: .102.3. I can open some spreadsheets with ClosedXML, but there are many which I cannot.

I am trying to set horizontal alignment of cells when exporting data to excel. Cells with numbers should align right.

I’m still quite new to programming and I started with C#. I want to make a simple application that accepts an error number from the user, for example: “F_220”. Read data from the table, find this place in the table and use columns and rows to provide an explanation for this error. For example, there is a table with cells: B:13 – “F_220” and C:13 – “Error, do something”. I found ClosedXML in. If this is a good tool, please help, if not, what can be used?