|
I've used .Net to open and read from an excel file and also suffered some crashes until I made it work. The main problem was (AFAICT) that once you create an Excel instance, it becomes a sink for input events, and if any other thread in your application also eats Windows events, this can lead to conflicts.
I solved these problems by opening the sheet, reading whatever I needed into a data structure, and immediately closing it again. I. e. not just closing the excel file, but also the excel application instance! Put all that into a try ... catch block and you're golden.
GOTOs are a bit like wire coat hangers: they tend to breed in the darkness, such that where there once were few, eventually there are many, and the program's architecture collapses beneath them. (Fran Poretto)
|
|
|
|
|
I'm using Spreadsheetlight for this, so I have none of those issues 
|
|
|
|
|
In the team I work in, we always pull all the data out of files into memory and close the file out. We also avoid using an external app to pull the data, so in this case, we would use ACE or INTEROP to rip the data directly from the spreadsheet, close the file and then do whatever else it is we would need or want to do.
|
|
|
|
|
I have some programs I made in NET Framework. Some have 180,000+ lines of code, including "in-house" controls, PDF generator and "visor", intensive graphics and lots of forms and controls.
I compiled the DLLs having the in-house controls in NET 5.0 without changes. Then I linked them to my programs and compile everything. 2 or 3 errors in calls not supported yet by NET Core, that I must rewrite and after that, everything worked OK. No Visual Studio crashes, no problems, no hidden controls... I do not know what could be wrong with your program.
|
|
|
|
|
Not sure if you know about this, but our shop uses this assembly to read/write excel files.
it handles .xls and .xlsx
NuGet Gallery NPOI 2.5.4[^]
|
|
|
|
|
I would use .NET Framework instead. Besides the issues you mentioned, I discovered the hard way that .NET Core didn't even allow me to view the Tab Order function. Once I switched to Framework, I was better off. Your results may vary, but I'd say it's worth a shot.
|
|
|
|
|
I spent a week building out a fairly small Forms application in .NET core (in VB no less!).
While I was able to make it work, I decided after the first week to transition back to Framework for the following reasons:
1. Speed of design - I'm not sure why, but the GUI design is dog-slow for CORE - probably 4x faster in Framework.
2. Build was much slower
3. I could never get my.settings variables to work correctly (seemed to be a known issue)
4. An unreasonable number of IDE crashes or freezes
5. LOTS of little things that just didn't work as expected.
My suggestion is to stick with Framework for at least another year. Let people with lots of free time and patience deal with Microsoft bugs.
"Qulatiy is Job #1"
|
|
|
|
|
determined that was a lie
Who could imagine - commercial company will lie! 
I said before and I repeat - don't be stupid to jump on "new" .NET Core - it is not. It's clumsy try of indian dancers to repeat success of MS Java creators. Never happen again.
.NET (being just virtual machine) was created.... WINDOWS ONLY(!). Unbelievable stupidity. But too much time past and too much code is done. WinForms STILL the best solution for "graphics intensive" apps. WPF still slow, because of many technical issues and architecture.
I really cry Gates and Ballmer left the company - THEY was base of the solid work, THEY hire proper professionals. Now it's just bunch of monkeys after 1-week courses "C# for total idiots". Pity, but MS as a company is walking corpse.
|
|
|
|
|
I'm running Windows.Forms in .NET 5 just fine here. I personally don't consider this particular piece of code anything else but a prototype (which will get replaced with some dialect of XAML later), but it works fine.
That's with .NET 5 though, never tried with .NET Core.
|
|
|
|
|
Same here! These are issues I faced
- Random VS hang
- Form Designer hang
- Controls not moving around properly
- Properties window hang
Behzad
|
|
|
|
|
Placed back around run around during the day(7)
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
Placed LAID
back DIAL
around DI AL
run around (anag)
URN
during the day
DIURNAL
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
YAUT - we won't have to wait until 11.30  how's the kitchen coming along ?
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
Not bad - it's kinda damp today so I won't be doing much to it (I don't have a workshop, so I only do woodwork on dry days as rain and power tools is a bad combination).
I spent far too much time yesterday trying to plan the cuts on two sheets of 8' by 4' birch ply to get the panels out with the grain all running in the same direction and missing the defects until I realised that this was a job for a CAD package ... 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Oh I assumed you had a workshop as you have a routing table et al
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
No, I have to drag it all out on the patio, and drag it all away again when I'm done for the day ...
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Just keep making them easy enough that they're solved by the time I get out of bed! 
I don't think I would've gotten this one, though.
|
|
|
|
|
I'm surprised you said that
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
Thank you for the diagram.
My eye always gloss over when I read the clues.
|
|
|
|
|
You're welcome!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Trying to get to the point of being able to pull the trigger on a re-do of the kitchen. We're not going crazy, but it's still big bucks. I think I have a good contractor, but his cost estimation software blows. Don't even ask me how we get the gas range my wife wants . Damn Italians, no offense, but you make great looking stoves.
On a happier note: Anniversary #43 is tomorrow. And she has *no* idea what her present is. Yeah, I'm knocking her socks off (besides the damn kitchen, but I want that too, so it doesn't count).
If you've never done a kitchen re-do, you are in for a treat. We just want a 36" dual fuel gas range. This means gas burners on top, true electric convection oven below (so why not say so?). So, $3,500 USD give or take later, let's talk range hoods. There are millions of houses designed such that the range hood recirculates into the kitchen. It's total BS and a complete design fail. I'm done with it. I want a real range hood over the new stove. $3,500 for a range hood?  
Good thing I'm on vacation.
Charlie Gilley
<italic>Stuck in a dysfunctional matrix from which I must escape...
"Where liberty dwells, there is my country." B. Franklin, 1783
“They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
|
|
|
|
|
Kitchen make overs are extremely expensive, especially now when everyone seems to be taking advantage of the Covid shortages.
Luckily we finished ours before the big shortage and we did all the work so it wasn't as bad.
The less you need, the more you have.
Even a blind squirrel gets a nut...occasionally.
JaxCoder.com
|
|
|
|
|
Prices are coming down. I'm on the backend of the curve. The funny thing, the sales/quoter/estimator does not understand what a hard requirement is.
He says, "for us to get started, 40% down." <- material purchases I understand. That's a hard requirement for me.
Me: I want a real range vent exhausting to the outside, quote says "vent to exterior wall if possible." bzzzz we have a problem mission control.
I just don't have the time to do all the work, and it needs to be done quickly. I live in this warp bubble. If I try to do on the side work, like renovate a kitchen or do some side work for another company, my primary customer never fails to go bat crap crazy.
Charlie Gilley
<italic>Stuck in a dysfunctional matrix from which I must escape...
"Where liberty dwells, there is my country." B. Franklin, 1783
“They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
|
|
|
|
|
I understand the work and time involved, I've done many over the years.
Just be sure you hire someone reputable, at 40% down that's quite a bit up front.
Good luck
The less you need, the more you have.
Even a blind squirrel gets a nut...occasionally.
JaxCoder.com
|
|
|
|
|
charlieg wrote: He says, "for us to get started, 40% down." <- material purchases I understand. That's a hard requirement for me.
I once had electrical work done where I purchased all of the supplies. Then I did not have to pay the electrician anything until the job was complete. If he had bailed part way through, I'm not out anything because the supplies would be needed no matter who is doing the work. Paying for labor up front is just a recipe for disaster these days.
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
