Jasonnn

PostsComments

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Nullable<int> and xUnit

thanks for confirming!

9 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Nullable<int> and xUnit

Ok so I definitely got scared because my IDE took time to refresh the warnings

9 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Nullable<int> and xUnit

public int? GetNumber(int row, int column)

9 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Nullable<int> and xUnit

Actually the second was just my IDE that didn't see that I had replaced int by int? I think, the warning just disappeared. My bad. Should I use Assert.Null() even though the XML doc says "object" and I'm technically using it on a value type? Maybe it just boxes my value type automatically?

9 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Reading/Writing in Excel with C#

I've ended up going for ClosedXML, I was looking for something fairly standard rather than extremely efficient but thanks for sharing!

43 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Reading/Writing in Excel with C#

EPPluss seems to not allow commercial use if you don't pay them indeed

43 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Reading/Writing in Excel with C#

I'll dig into the documentation of ClosedXML since it seems to be the most relevant for me

43 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Reading/Writing in Excel with C#

Ok I see, thanks for the help

43 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Reading/Writing in Excel with C#

and that therefore I inferred that I would need to be careful about not keeping it in memory

43 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Reading/Writing in Excel with C#

Just the fact that it uses a using

43 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Reading/Writing in Excel with C#

sorry I don't think unmanaged was the right term

43 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Reading/Writing in Excel with C#

this

43 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Reading/Writing in Excel with C#

https://learn.microsoft.com/en-us/office/open-xml/spreadsheet/how-to-open-a-spreadsheet-document-for-read-only-access?tabs=cs-0%2Ccs-1%2Ccs-2%2Ccs

43 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Reading/Writing in Excel with C#

I had started reading about OpenXML, it seems it uses an unmanaged object that I need to dispose myself, is it standard in C# that I need to be careful about that? Oh was it just OpenXML?

43 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Reading/Writing in Excel with C#

I see, I guess ClosedXML is going to be the one I'll be using

43 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Reading/Writing in Excel with C#

It looks like it's the first one that comes up

43 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Reading/Writing in Excel with C#

The Excel might be a few thousands rows but that shouldn't be too much

43 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Reading/Writing in Excel with C#

I don't need the UI, I really just want to read/write

43 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Reading/Writing in Excel with C#

I can't make the .xlsx file a .csv file because it is the input of the program that is not controlled by me

43 replies

CC#

•Created by Jasonnn on 9/9/2024 in #help

✅ Reading/Writing in Excel with C#

I baiscally just need to read values from a .xlsx file

43 replies