Welcome to the Lounge

PIEBALDconsult6-Dec-23 6:36

6-Dec-23 6:36

No it isn't.

Richard MacCutchan6-Dec-23 6:48

6-Dec-23 6:48

Well, what is your point?

PIEBALDconsult6-Dec-23 7:13

6-Dec-23 7:13

Exactly what I said.

Richard MacCutchan6-Dec-23 7:18

6-Dec-23 7:18

I see, just trolling.

PIEBALDconsult6-Dec-23 7:44

6-Dec-23 7:44

Nope, just offering unsolicited advice.

Richard MacCutchan6-Dec-23 7:49

6-Dec-23 7:49

Feel free not to bother in future.

PIEBALDconsult6-Dec-23 8:22

6-Dec-23 8:22

And you needn't bother respond either.

Richard MacCutchan7-Dec-23 0:10

7-Dec-23 0:10

If you don't post pointless or silly comments there will not be anything to respond to.

modified 2 days ago.

PIEBALDconsult7-Dec-23 4:33

7-Dec-23 4:33

Well, there you go again.

adriancs7-Dec-23 0:02

adriancs

7-Dec-23 0:02

Yes, I agree with this. Microsoft Office Interop will launch the actual Excel program in background as external process.

yacCarsten5-Dec-23 11:26

yacCarsten

5-Dec-23 11:26

This is why I avoided ClosedXML and work directly with OpenXML. I didn't like the idea of an update breaking something.

This is an alternate suggestion if it feasible for you, I used the following snippet to build my own function:

https://stackoverflow.com/questions/7208914/how-do-you-convert-excel-to-csv-using-openxml-sdk[^]

~~// TODO: Insert something here~~
Top ten reasons why I'm lazy
1.

kmoorevs5-Dec-23 11:36

kmoorevs

5-Dec-23 11:36

Thanks, This looks promising! Thumbs Up | :thumbsup:

I've requested the problem file be sent as a csv. Failing that, I'll definitely give it a go. Smile | :)

"Go forth into the source" - Neal Morse
"Hope is contagious"

Luca Leonardo Scorcia5-Dec-23 11:56

Luca Leonardo Scorcia

5-Dec-23 11:56

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

PIEBALDconsult5-Dec-23 18:23

5-Dec-23 18:23

Unless "they" who control the data centers don't allow it on the servers.

PIEBALDconsult5-Dec-23 18:25

5-Dec-23 18:25

Never used it. What are you trying to do with it?

Because I only needed to read it, I rolled my own XLSX reader.

pkfox5-Dec-23 22:31

pkfox

5-Dec-23 22:31

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

kmoorevs6-Dec-23 4:24

kmoorevs

6-Dec-23 4:24

pkfox wrote:
NPOI

Funny, the author of the spreadsheets show as Apache POI. Related?

"Go forth into the source" - Neal Morse
"Hope is contagious"

pkfox6-Dec-23 8:20

pkfox

6-Dec-23 8:20

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

Richard Deeming5-Dec-23 23:13

Richard Deeming

5-Dec-23 23:13

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

kmoorevs6-Dec-23 4:23

kmoorevs

6-Dec-23 4:23

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. Smile | :)

"Go forth into the source" - Neal Morse
"Hope is contagious"

Richard Deeming6-Dec-23 4:45

Richard Deeming

6-Dec-23 4:45

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. Smile | :)

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer