|
I have a spreadsheet which is reaching the limits of usability - for me that's about 200 rows if I'm adding them regularly, so it should be a DB app instead of a spreadsheet. So today's task was to write the DB app and import the existing data, creating the DB as I go.
So I have spent the morning wrestling with bloody excel, trying to read it from OneDrive and convert it from MS's arcane interop methods to something resembling a sensible format: a DataTable is good. I mean, have you looked at it? The cell content is accessed via a property called "Value2" fer gawds sake ...
And it's difficult - so after piles of googling, trying code samples and such like, I thought - "I'm sure I did this before, and used an article on CP" so I go off and google for it. And top of the list is "Reading an Excel Sheet into a DataTable, generic method". Brilliant! Let's have a look ...
Oh. 
I wrote it eight years ago. 
"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!
|
|
|
|
|
Been there - both regarding discovering I wrote an article for something I'm searching for, and for using your article on reading Excel into a DataTable. 
|
|
|
|
|
I only noticed when I tried it and it worked first time, so I went back to upvote it and found it was mine ...  
"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!
|
|
|
|
|
Been there done that.
Here's another story about my articles though.
I used to work for a company where the entire team was hired externally.
Now there was this architect who was quite full of himself and kept underestimating me.
Like, I asked him "why didn't we use this technology instead of the older technology we're using now?" (I think I wanted Azure Functions and we went with WebJobs).
His answer was "because I didn't think you'd understand the new technology."
Like WTF you ![Elephant | [mastadon]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/elephant.gif) ing 
Anyway, then he and his butt kisser coworker wanted to look up some information about Functions and they used an article and then found out it was mine.
Take that, es! 
Ultimately, the coworker was laid off and the architect made sure I was too a few months later (much to the dislike of the rest of the team).
The architect is still there and got a contract, I understood.
I was really happy to get out of there and I'm now running my own business with some success, so it all worked out in the end
|
|
|
|
|
The memory is the first thing to go, as we age.
Trust me. I know.
What's my name again?
|
|
|
|
|
OriginalGriff wrote: I wrote it eight years ago
I find it scary that some people end up forgetting more things than others will ever learn throughout their entire lifetimes.
|
|
|
|
|
Too funny.
|
|
|
|
|
Legacy Excel (XLS) ? Or modern Excel (XLSX) ?
I used to use the JET/ACE Engine with OLE DB for reading and writing Excel programmatically.
XLSX is really a ZIP file containing XML files, so I open it extract the data from the XML.
|
|
|
|
|
I am a novice. So, I import an Excel sheet into Access. Then convert it to MySql. Not much tech knowledge on my part. But I get good help from CP on many projects.
|
|
|
|
|
I don't think that is embarrassing. A lot happens in eight years and we humans can not keep track of everything.
Really embarrassing would be if you failed to follow your own instructions in front of your boss. I somehow skipped a step when reading  . After that, there is no place to hide 
|
|
|
|
|
Get a booster and have side effects.
With the Real Covid Experience, I lost 6 Kg in two weeks, and while it wasn't an experience I want to repeat, I have kept that weight off, bringing my BMI down from the mid 24's (top end of "healthy", bordering on "fat") to 22 (middle of the "healthy" range) and I'm glad of that.
The first vaccination (AstraZeneca) gave me a day of nasties, but didn't last, the second gave me nothing bad at all other than injection site pain and a little redness.
But the booster (Pfizer) gave me a "mini-covid" experience for three days - nowhere as bad as the full thing, and it wouldn't stop me having another booster when I need one - I suspect because my immune system went "What the heck? You again? you!" and went into overdrive to ensure I was cleared out: not pleasant ... but presumably effective.
And I just weighed myself again ... lost another 1.5Kg, which is probably a good thing. It does mean I can overindulge over Christmas without feeling too guilty!
Side effects are rare, and the intensity of them I experienced kinda makes you think that maybe the vaccination really had "worn off" in just six months. If so, I guess I've got another bout of nasties coming early summer next year ... but that won't stop me having it!
A quick google says that if you have had Covid, you do stand a higher chance of getting side effects from vaccinations: Why vaccine side effects might be more common in people who've already had COVID-19[^]
"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!
|
|
|
|
|
Yeah the Pfizer hits hard, I had it as my 1st and 2nd dose and the second one knocked me out for a couple of days. It's apparently the most effective though.
GCS d--(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--- r+++ y+++* Weapons extension: ma- k++ F+2 X
|
|
|
|
|
I lost 32 pounds from an oral/mouth/throat surgery many years ago. I lost it in the course of about 3-4 weeks, due to the fact that I could not eat any solid food for that time.
Needless to say, I have found that medical\health events are great for weight loss. Now, only if the same could be said after one heals.
I have had both initial Pfizer vaccine doses and a Pfizer booster. I was only "ill" for a couple of days for all 3 vaccine events, but nothing serious to report; no weight loss. Sucks that it hit you harder, it appears.
|
|
|
|
|
I had 2 AZ's in April and July, a Pfizer booster yesterday.
Negligible effects from the first two, feeling generally seedy today, and the injection site is sore if I move that arm.
My son has had 3 Pfizers and says the booster hit him way harder than the first two.
Cheers,
Peter
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
I feel left out - three Pfiezer shots, and all I had was a sore arm. 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I'm not sure if that rates a "jammy bugger" or a "poor you" - since it doesn't show if your immune system is primed to "meet the invader" at all ... 
I'm hoping it's the former option!
"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!
|
|
|
|
|
Same here Richard, and my sore arm wasn't much to write home about
"Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
|
|
|
|
|
Mine gave me a Grand Mal Seizure. Of course I got the flu shot in the other arm at the same time.
Live and learn.
|
|
|
|
|
I had no side effects from the COVID or Shingles vaccines. On the other hand, the old live attenuated virus Typhoid vaccine had me laid up for a week while I recovered from a mild case of Typhoid.
|
|
|
|
|
i lost a ton of weight this year (literally, i used to weight 2140lbs). never thought to associate it with COVID shots. hmm.
|
|
|
|
|
Chris Losinger wrote: 2140lbs
What kind of lbs are these ? That's literally the weight of my car !
|
|
|
|
|
Have to wait 'til after Christmas to get my Borcestershire shots.
|
|
|
|
|
Meh.
I lose that sort of weight every time I check into hospital and sample their "wonderful" menu. My theory is that the hospital food is so bad to ensure that even the dumpster divers will want to check out ASAP. 
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
Repair Washington deceit (9)
"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!
|
|
|
|
|
Whitewash ?
"Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
