Click here to Skip to main content
15,351,370 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: I was told about this, but ... Pin
erikbrannlund22-Nov-20 23:03
professionalerikbrannlund22-Nov-20 23:03 
GeneralRe: I was told about this, but ... Pin
Jörgen Andersson23-Nov-20 0:51
professionalJörgen Andersson23-Nov-20 0:51 
GeneralRe: I was told about this, but ... ... but Finland isn't Scandinavia! Pin
trønderen23-Nov-20 0:26
Membertrønderen23-Nov-20 0:26 
GeneralRe: I was told about this, but ... Pin
obermd23-Nov-20 3:35
Memberobermd23-Nov-20 3:35 
GeneralI am coming to seriously love JSON. Pin
OriginalGriff21-Nov-20 6:06
mveOriginalGriff21-Nov-20 6:06 
GeneralRe: I am coming to seriously love JSON. Pin
Ron Anders21-Nov-20 6:18
MemberRon Anders21-Nov-20 6:18 
GeneralRe: I am coming to seriously love JSON. Pin
PIEBALDconsult21-Nov-20 6:51
professionalPIEBALDconsult21-Nov-20 6:51 
GeneralRe: I am coming to seriously love JSON. Pin
PIEBALDconsult21-Nov-20 6:49
professionalPIEBALDconsult21-Nov-20 6:49 
You're working too hard. Big Grin | :-D

One of the utilities I've been working on at work recently is a very simple ETL tool.

                    Source Destination
CSV                 Y      Y
JSON                F      F
Sharepoint (list)   Y      N
SPLUNK              F      N
SQL Server          Y      Y
SSAS (OLAP)         Y      N
XHTML               Y      Y
XLSX                Y      N
XML                 Y      Y

Y=Yes , N=No , F=Future support possible


Each "source" provides a DataReader and each "destination" reads a DataReader.

One design decision I made was not to use any third-party technology (e.g. Newtonsoft), it's all .net -- it doesn't use interop either.
I intend to add reading and writing JSON to it once I have .net 4.7 or newer -- which supports JSON natively.


The point being that opening an XLSX file and wrapping a "worksheet" in a DataReader is not all that difficult -- non-trivial, yes.
With the DataReader, you can create and populate a DataTable, but what do you do with it then?
PraiseRe: I am coming to seriously love JSON. Pin
User 1106097921-Nov-20 19:52
MemberUser 1106097921-Nov-20 19:52 
GeneralRe: I am coming to seriously love JSON. Pin
GuyThiebaut21-Nov-20 6:49
professionalGuyThiebaut21-Nov-20 6:49 
GeneralRe: I am coming to seriously love JSON. Pin
PIEBALDconsult21-Nov-20 7:05
professionalPIEBALDconsult21-Nov-20 7:05 
GeneralRe: I am coming to seriously love JSON. Pin
GuyThiebaut21-Nov-20 7:23
professionalGuyThiebaut21-Nov-20 7:23 
GeneralRe: I am coming to seriously love JSON. Pin
PIEBALDconsult21-Nov-20 7:33
professionalPIEBALDconsult21-Nov-20 7:33 
GeneralRe: I am coming to seriously love JSON. Pin
Peter Kassenaar22-Nov-20 19:59
MemberPeter Kassenaar22-Nov-20 19:59 
GeneralRe: I am coming to seriously love JSON. Pin
GuyThiebaut22-Nov-20 22:59
professionalGuyThiebaut22-Nov-20 22:59 
GeneralRe: I am coming to seriously love JSON. Pin
thewazz23-Nov-20 18:04
professionalthewazz23-Nov-20 18:04 
GeneralRe: I am coming to seriously love JSON. Pin
Richard MacCutchan21-Nov-20 6:55
mveRichard MacCutchan21-Nov-20 6:55 
GeneralRe: I am coming to seriously love JSON. Pin
Richard Andrew x6421-Nov-20 7:00
professionalRichard Andrew x6421-Nov-20 7:00 
GeneralRe: I am coming to seriously love JSON. Pin
dandy7221-Nov-20 7:49
Memberdandy7221-Nov-20 7:49 
GeneralRe: I am coming to seriously love JSON. Pin
Slacker00721-Nov-20 8:56
professionalSlacker00721-Nov-20 8:56 
GeneralRe: I am coming to seriously love JSON. Pin
honey the codewitch21-Nov-20 10:03
mvahoney the codewitch21-Nov-20 10:03 
PraiseRe: I am coming to seriously love JSON. Pin
Slacker00721-Nov-20 10:36
professionalSlacker00721-Nov-20 10:36 
GeneralRe: I am coming to seriously love JSON. Pin
W Balboos, GHB22-Nov-20 1:54
mveW Balboos, GHB22-Nov-20 1:54 
GeneralRe: I am coming to seriously love JSON. Pin
Gerry Schmitz22-Nov-20 4:01
mveGerry Schmitz22-Nov-20 4:01 
Generalfor the CodeProject community in locked-down Toronto: best wishes ! Pin
BillWoodruff21-Nov-20 4:42
mveBillWoodruff21-Nov-20 4:42 

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.


Straw Poll

What language are you using for AI development or learning?
Whether you're at work or home, hard core coding or just trying to figure out this AI thing, which languages have you used in your adventures?
  Results   355 votes