Click here to Skip to main content
15,891,567 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Just thought I'd mention. TotD Pin
honey the codewitch17-Dec-21 15:58
mvahoney the codewitch17-Dec-21 15:58 
GeneralSound of the Week Pin
Sander Rossel17-Dec-21 1:12
professionalSander Rossel17-Dec-21 1:12 
GeneralRe: Sound of the Week Pin
yacCarsten17-Dec-21 2:02
yacCarsten17-Dec-21 2:02 
GeneralRe: Sound of the Week Pin
Sander Rossel17-Dec-21 3:18
professionalSander Rossel17-Dec-21 3:18 
GeneralRe: Sound of the Week Pin
David O'Neil17-Dec-21 2:19
professionalDavid O'Neil17-Dec-21 2:19 
GeneralRe: Sound of the Week Pin
Sander Rossel17-Dec-21 3:24
professionalSander Rossel17-Dec-21 3:24 
GeneralRe: Sound of the Week Pin
David O'Neil17-Dec-21 4:49
professionalDavid O'Neil17-Dec-21 4:49 
GeneralWell this is embarrassing. Pin
OriginalGriff17-Dec-21 1:12
mveOriginalGriff17-Dec-21 1:12 
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. Sigh | :sigh:

I wrote it eight years ago. Blush | :O
"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!

GeneralRe: Well this is embarrassing. Pin
Marc Clifton17-Dec-21 1:19
mvaMarc Clifton17-Dec-21 1:19 
GeneralRe: Well this is embarrassing. Pin
OriginalGriff17-Dec-21 4:19
mveOriginalGriff17-Dec-21 4:19 
GeneralRe: Well this is embarrassing. Pin
Sander Rossel17-Dec-21 1:21
professionalSander Rossel17-Dec-21 1:21 
GeneralRe: Well this is embarrassing. Pin
Slow Eddie17-Dec-21 1:50
professionalSlow Eddie17-Dec-21 1:50 
GeneralRe: Well this is embarrassing. Pin
dandy7217-Dec-21 3:49
dandy7217-Dec-21 3:49 
GeneralRe: Well this is embarrassing. Pin
JoeSox17-Dec-21 5:11
JoeSox17-Dec-21 5:11 
GeneralRe: Well this is embarrassing. Pin
PIEBALDconsult17-Dec-21 6:00
mvePIEBALDconsult17-Dec-21 6:00 
GeneralRe: Well this is embarrassing. Pin
BobbyStrain17-Dec-21 6:46
BobbyStrain17-Dec-21 6:46 
GeneralRe: Well this is embarrassing. Pin
ElectronProgrammer17-Dec-21 7:56
ElectronProgrammer17-Dec-21 7:56 
GeneralI have a working weight loss formula. Pin
OriginalGriff16-Dec-21 23:45
mveOriginalGriff16-Dec-21 23:45 
GeneralRe: I have a working weight loss formula. Pin
den2k8816-Dec-21 23:48
professionalden2k8816-Dec-21 23:48 
GeneralRe: I have a working weight loss formula. Pin
Slacker00716-Dec-21 23:53
professionalSlacker00716-Dec-21 23:53 
GeneralRe: I have a working weight loss formula. Pin
Peter_in_278017-Dec-21 0:06
professionalPeter_in_278017-Dec-21 0:06 
GeneralRe: I have a working weight loss formula. Pin
Richard Deeming17-Dec-21 0:23
mveRichard Deeming17-Dec-21 0:23 
GeneralRe: I have a working weight loss formula. Pin
OriginalGriff17-Dec-21 1:19
mveOriginalGriff17-Dec-21 1:19 
GeneralRe: I have a working weight loss formula. Pin
pkfox17-Dec-21 5:56
professionalpkfox17-Dec-21 5:56 
GeneralRe: I have a working weight loss formula. Pin
Slow Eddie17-Dec-21 1:52
professionalSlow Eddie17-Dec-21 1:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.