|
Well, what is your point?
|
|
|
|
|
|
|
Nope, just offering unsolicited advice.
|
|
|
|
|
Feel free not to bother in future.
|
|
|
|
|
And you needn't bother respond either.
|
|
|
|
|
|
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
|
|
|
|
|
kmoorevs wrote: ClosedXML .Net library to open/read Excel files....I am aware that a new version of OpenXML was released
A commercial production application should be built using the following
1. Identify libraries used.
2. Copy those libraries to a source that is controlled by the company.
3. Those libraries should ONLY be updated manually.
4. When libraries are updated and a dependent application is rebuilt then all of the impacted functionality must be retested.
Note that version identifiers should not be trusted. That is why step 2 is required. Version identifiers are nothing but a hint since nothing stops someone from updating a library and not changing the version number.
If the above is not followed then it is quite possible to go for years without problems. Until the day something quite unexpected shows up.
|
|
|
|
|
I find is amusing that my comments elsewhere (not CP), when it can't be deciphered by AI, needs to go for "review" before it can be released. AI is talking but not really listening.
"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I
|
|
|
|
|
Gerry Schmitz wrote: AI is talking but not really listening.
Damn it... that might be the proof that is becoming like humans faster than we thought...  
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Gerry Schmitz wrote: AI is talking but not really listening.
I have to admit I've had a number of discussions with ChatGPT (after I've repeatedly tried to clarify a question) that have ended with me writing back "now you're just spewing nonsense".
Invariably, the textbox is then grayed out with a button that says "perhaps it's time to move onto a new topic".
|
|
|
|
|
Sounds like my other half, do you know each other perhaps?...
|
|
|
|
|
|
Probably not the only one not fluent in Spanish 
"If builders built buildings the way programmers wrote programs, then the first woodpecker that came along would destroy civilization." ― Gerald Weinberg
|
|
|
|
|
The Lines & Symbols[^] just suddenly appeared when I opened my project. They were not there before the last update.
Anyone know how to turn these off?? Note that I have 'Show procedure line separators' off.
The lines only appear on regions.
The purple boxes open a context menu.
Thanks
In theory, theory and practice are the same. But in practice, they never are.”
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
