Click here to Skip to main content
15,434,147 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

Who do you listen to most when making decisions about software development?
  Results   461 votes