Well this is embarrassing.
-
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: I wrote it eight years ago. :-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!
"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 -
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: I wrote it eight years ago. :-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!
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. :-D
Latest Articles:
Your one-stop guide for API and web-client Form, XHR, Blob, and Drag & Drop File/Data Uploading -
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: I wrote it eight years ago. :-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!
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:ing :elephant: :wtf: 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, :elephant: es! :D 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 :D
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
-
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: I wrote it eight years ago. :-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!
The memory is the first thing to go, as we age. Trust me. I know.
What's my name again?
-
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: I wrote it eight years ago. :-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!
-
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. :-D
Latest Articles:
Your one-stop guide for API and web-client Form, XHR, Blob, and Drag & Drop File/Data UploadingI only noticed when I tried it and it worked first time, so I went back to upvote it and found it was mine ... :-O :laugh:
"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!
-
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: I wrote it eight years ago. :-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!
Too funny. :-D
Later, JoeSox “Write hard and clear about what hurts.” - Ernest Hemingway Last.fm - CPForAndroid++- Earthboticsai.net
-
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: I wrote it eight years ago. :-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!
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.
-
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 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: I wrote it eight years ago. :-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!
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 :sigh: . After that, there is no place to hide X|
