|
|
I have used it on a number of occasions and it works well.
|
|
|
|
|
|
But that was the implication from:
Quote: Avoid Interop.
|
|
|
|
|
|
Well, what is your point?
|
|
|
|
|
|
|
Nope, just offering unsolicited advice.
|
|
|
|
|
Feel free not to bother in future.
|
|
|
|
|
And you needn't bother respond either.
|
|
|
|
|
If you don't post pointless or silly comments there will not be anything to respond to.
modified 7-Dec-23 5:25am.
|
|
|
|
|
Well, there you go again.
|
|
|
|
|
Yes, I agree with this. Microsoft Office Interop will launch the actual Excel program in background as external process.
|
|
|
|
|
|
Thanks, This looks promising! I've requested the problem file be sent as a csv. Failing that, I'll definitely give it a go.
"Go forth into the source" - Neal Morse
"Hope is contagious"
|
|
|
|
|
There's also the option to use Excel spreadsheet library for .NET Framework/Core - EPPlus Software[^] . There's a FAQ about licensing, depending on your requirements YMMV.
Luca
The Price of Freedom is Eternal Vigilance. -- Wing Commander IV
En Það Besta Sem Guð Hefur Skapað, Er Nýr Dagur.
(But the best thing God has created, is a New Day.)
-- Sigur Ròs - Viðrar vel til loftárása
|
|
|
|
|
Unless "they" who control the data centers don't allow it on the servers.
|
|
|
|
|
Never used it. What are you trying to do with it?
Because I only needed to read it, I rolled my own XLSX reader.
|
|
|
|
|
I've used NPOI for years without any problems
In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP
|
|
|
|
|
pkfox wrote: NPOI
Funny, the author of the spreadsheets show as Apache POI. Related?
"Go forth into the source" - Neal Morse
"Hope is contagious"
|
|
|
|
|
Yes they ported it from POI
In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP
|
|
|
|
|
kmoorevs wrote: .net framework upgrade to 4.6+
...
whines about a netstandard library that it can't find
Which version did you actually upgrade to?
.NET Standard 2.0 sort-of works with 4.6.1+, but it has several issues. Microsoft recommend using at least 4.7.2:
.NET Standard - .NET | Microsoft Learn[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Richard Deeming wrote: Which version did you actually upgrade to?
4.6.1 first then 4.7.2. Neither worked. Back to 4.5.2.
"Go forth into the source" - Neal Morse
"Hope is contagious"
|
|
|
|
|
Any particular reason? 4.7.2 will make your life much easier when you want to reference a .NET Standard 2.0 library, and I don't recall seeing any breaking changes.
I think the only thing that "broke" for me was an ambiguous reference error for a custom extension method I'd written, which had the same name as one they added to the BCL in 4.7.2.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|