|
I wrote a wizard app for one of our co-workers that merges two Excel spreadsheets by matching selected columns based on one or more matching criteria (this column value == that column value), and combining the selected columns into a single file.
I essentially reduced a 2-5 day process (depending on the size of the two datasets) to no more than an hour. The reason it takes an hour is because the half-assed Telerik spreadsheet control/document code doesn't understand formulas very well, and also doesn't support Date column types, so the user has to manually modify the merged data to suit their ultimate needs.
I would write an article, but the code relies on the Telerik WPF library, which is not free.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
I know what you mean. The volume of kudos that I've got from writing moron-level-simple code for Excel spreadsheets far exceeds any kind of response I've ever got from stuff I've really had to work at.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
You are so correct, but I've learned the reason that is, is that the simple stuff is what more people can connect with. It takes a *special* person to sit their entire life behind a computer, and so deep concepts aren't event familiar to them. It's out of the league so to speak - in regards to computers.
Jeremy Falcon
|
|
|
|
|
Any sufficiently advanced technology will appear as magic to primitives.
|
|
|
|
|
People that don't live in front of a computer aren't primitive. They simply have different interests and therefore know different things. Thinking you're better than someone for knowing more than someone in *your* field isn't advanced - it's arrogant.
Jeremy Falcon
|
|
|
|
|
Jeremy Falcon wrote: Thinking you're better than someone for knowing more than someone in your field isn't advanced - it's arrogant.
Arrogance is kinda my superpower. That, and marksmanship.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
|
I thought your arsenal was your superpower. Arrogance is just part of your charm
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.
|
|
|
|
|
Whena you can single-handedly face a fairly sized battallion it's hard not to get a bit arrogant
DURA LEX, SED LEX
GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver
When I was six, there were no ones and zeroes - only zeroes. And not all of them worked. -- Ravi Bhavnani
|
|
|
|
|
Agree... my wife is very smart (Dr. med.) but coming to gadgets and computers... it hurts to see her using her laptop
But hey... I am still very lucky, I don't get "My computer is not working" more than 1 or 2 times per year
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.
|
|
|
|
|
You are lucky.
My wife managed to infect her PC twice in a month by clicking literally anything in Facebook.
That's when I took away the admin rights from her.
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
In what category do I place people who miss literary allusions?
|
|
|
|
|
In what category do I place people that use obscure euphemisms when attempting to debase the inherent coherency of others in regards to cognitive acuity simply because they complement another's accomplishments?
Jeremy Falcon
|
|
|
|
|
It's also possible that your psychic powers are not quite as good as you imagined, and that you impugned me with malicious motives that were simply never present. I was merely making an on-topic literary allusion, but you went all white knight trying to defend people who were never attacked in the first place to make you feel better about yourself at my expense.
I also object to your claim that Clarke's Three Laws are obscure:
https://en.wikipedia.org/wiki/Clarke's_three_laws
|
|
|
|
|
I'm not interested in knowing you anymore. Toodles!
Jeremy Falcon
|
|
|
|
|
|
Well, I looked around for an adequate excel-like wpf spreadsheet control, and found a product called "ReoGrid". I'll give it a shot to adapt my code to it for an article. Maybe it does formulas better...
".45 ACP - because shooting twice is just silly" - JSOP, 2010
- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
I think Spreadsheet Gear (also not free) may have a WPF control, they has a Silverlight control and it was reasonably useful for a simplistic solution we needed it for.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I can't use a commercial product in an article.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
I'm surprised there isn't a free one here.
|
|
|
|
|
Well, I just checked out "ReoGrid", and in a nutshell, it's crap. It was easy enough to get a spreadsheet control in a window, but after loading a file, the displayed data is, well, not displayed.
A quick check with the debugger shows that the control is actually loaded with the intended file, and shows the correct number of columns and rows, but the display shows nothing, even if I highlight a range of cells.
The search for a free spreadsheet control continues.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
|
SyncFusion has a free version of their stuff that doesn't appear to be time limited. I'll check that out.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Yeah - I blasted him about my problem already because that's the only way I could find to contact him.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Easy. They are wrong.
Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy.
|
|
|
|