how to get json object titles












0















I'm a new programmer , I know how to use dictionary/JSON to get the value of whatever you want like for example var x = {"name":jack,"age":20};

then x.name = jack



but what if I've a table that has been imported through an unknown EXCEL file and I just want to know the title of each column , how can i do that ?



for example 



Var table = [{"id":0 , "name":jack,"age":25,"profession":student},{"id":1 , "name":nora,"age":22,"profession":student}]


i want to make a javascript function that can inform me with titles of each columns , the number of the columns
how can i do that ?






javascript arrays json list







share|improve this question

























  • do note Var table = is invalid syntax, and both name:jack, and profession:student} is likely wrong too, strings must be enclosed in delimiters

    – CertainPerformance
    Nov 25 '18 at 23:37













  • should profession:student be profession:"student" ?

    – Dacre Denny
    Nov 25 '18 at 23:40











  • i fixed it thanks , correct me if iam not wrong but "profession":student is the right syntax

    – za002
    Nov 25 '18 at 23:42











  • Unless student is a variable, you are wrong :D Also, note that JavaScript, like most of the popular programming languages, is case-sensitive, and Var is not var. This is correct: var table = [{"id":0 , "name":"jack","age":25,"profession":"student"},{"id":1 , "name":"nora","age":22,"profession":"student"}]

    – Amadan
    Nov 25 '18 at 23:53











  • You can validate a json online here : jsonlint.com

    – Shim-Sao
    Nov 26 '18 at 0:39
















0















I'm a new programmer , I know how to use dictionary/JSON to get the value of whatever you want like for example var x = {"name":jack,"age":20};

then x.name = jack



but what if I've a table that has been imported through an unknown EXCEL file and I just want to know the title of each column , how can i do that ?



for example 



Var table = [{"id":0 , "name":jack,"age":25,"profession":student},{"id":1 , "name":nora,"age":22,"profession":student}]


i want to make a javascript function that can inform me with titles of each columns , the number of the columns
how can i do that ?






javascript arrays json list







share|improve this question

























  • do note Var table = is invalid syntax, and both name:jack, and profession:student} is likely wrong too, strings must be enclosed in delimiters

    – CertainPerformance
    Nov 25 '18 at 23:37













  • should profession:student be profession:"student" ?

    – Dacre Denny
    Nov 25 '18 at 23:40











  • i fixed it thanks , correct me if iam not wrong but "profession":student is the right syntax

    – za002
    Nov 25 '18 at 23:42











  • Unless student is a variable, you are wrong :D Also, note that JavaScript, like most of the popular programming languages, is case-sensitive, and Var is not var. This is correct: var table = [{"id":0 , "name":"jack","age":25,"profession":"student"},{"id":1 , "name":"nora","age":22,"profession":"student"}]

    – Amadan
    Nov 25 '18 at 23:53











  • You can validate a json online here : jsonlint.com

    – Shim-Sao
    Nov 26 '18 at 0:39














0












0








0


1






I'm a new programmer , I know how to use dictionary/JSON to get the value of whatever you want like for example var x = {"name":jack,"age":20};

then x.name = jack



but what if I've a table that has been imported through an unknown EXCEL file and I just want to know the title of each column , how can i do that ?



for example 



Var table = [{"id":0 , "name":jack,"age":25,"profession":student},{"id":1 , "name":nora,"age":22,"profession":student}]


i want to make a javascript function that can inform me with titles of each columns , the number of the columns
how can i do that ?






javascript arrays json list







share|improve this question
















I'm a new programmer , I know how to use dictionary/JSON to get the value of whatever you want like for example var x = {"name":jack,"age":20};

then x.name = jack



but what if I've a table that has been imported through an unknown EXCEL file and I just want to know the title of each column , how can i do that ?



for example 



Var table = [{"id":0 , "name":jack,"age":25,"profession":student},{"id":1 , "name":nora,"age":22,"profession":student}]


i want to make a javascript function that can inform me with titles of each columns , the number of the columns
how can i do that ?






javascript arrays json list




javascript arrays json list






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 25 '18 at 23:41







za002

















asked Nov 25 '18 at 23:36









za002za002

154




154













  • do note Var table = is invalid syntax, and both name:jack, and profession:student} is likely wrong too, strings must be enclosed in delimiters

    – CertainPerformance
    Nov 25 '18 at 23:37













  • should profession:student be profession:"student" ?

    – Dacre Denny
    Nov 25 '18 at 23:40











  • i fixed it thanks , correct me if iam not wrong but "profession":student is the right syntax

    – za002
    Nov 25 '18 at 23:42











  • Unless student is a variable, you are wrong :D Also, note that JavaScript, like most of the popular programming languages, is case-sensitive, and Var is not var. This is correct: var table = [{"id":0 , "name":"jack","age":25,"profession":"student"},{"id":1 , "name":"nora","age":22,"profession":"student"}]

    – Amadan
    Nov 25 '18 at 23:53











  • You can validate a json online here : jsonlint.com

    – Shim-Sao
    Nov 26 '18 at 0:39



















  • do note Var table = is invalid syntax, and both name:jack, and profession:student} is likely wrong too, strings must be enclosed in delimiters

    – CertainPerformance
    Nov 25 '18 at 23:37













  • should profession:student be profession:"student" ?

    – Dacre Denny
    Nov 25 '18 at 23:40











  • i fixed it thanks , correct me if iam not wrong but "profession":student is the right syntax

    – za002
    Nov 25 '18 at 23:42











  • Unless student is a variable, you are wrong :D Also, note that JavaScript, like most of the popular programming languages, is case-sensitive, and Var is not var. This is correct: var table = [{"id":0 , "name":"jack","age":25,"profession":"student"},{"id":1 , "name":"nora","age":22,"profession":"student"}]

    – Amadan
    Nov 25 '18 at 23:53











  • You can validate a json online here : jsonlint.com

    – Shim-Sao
    Nov 26 '18 at 0:39

















do note Var table = is invalid syntax, and both name:jack, and profession:student} is likely wrong too, strings must be enclosed in delimiters

– CertainPerformance
Nov 25 '18 at 23:37







do note Var table = is invalid syntax, and both name:jack, and profession:student} is likely wrong too, strings must be enclosed in delimiters

– CertainPerformance
Nov 25 '18 at 23:37















should profession:student be profession:"student" ?

– Dacre Denny
Nov 25 '18 at 23:40





should profession:student be profession:"student" ?

– Dacre Denny
Nov 25 '18 at 23:40













i fixed it thanks , correct me if iam not wrong but "profession":student is the right syntax

– za002
Nov 25 '18 at 23:42





i fixed it thanks , correct me if iam not wrong but "profession":student is the right syntax

– za002
Nov 25 '18 at 23:42













Unless student is a variable, you are wrong :D Also, note that JavaScript, like most of the popular programming languages, is case-sensitive, and Var is not var. This is correct: var table = [{"id":0 , "name":"jack","age":25,"profession":"student"},{"id":1 , "name":"nora","age":22,"profession":"student"}]

– Amadan
Nov 25 '18 at 23:53





Unless student is a variable, you are wrong :D Also, note that JavaScript, like most of the popular programming languages, is case-sensitive, and Var is not var. This is correct: var table = [{"id":0 , "name":"jack","age":25,"profession":"student"},{"id":1 , "name":"nora","age":22,"profession":"student"}]

– Amadan
Nov 25 '18 at 23:53













You can validate a json online here : jsonlint.com

– Shim-Sao
Nov 26 '18 at 0:39





You can validate a json online here : jsonlint.com

– Shim-Sao
Nov 26 '18 at 0:39












4 Answers
4






active

oldest

votes


















2














First of all, an object in JavaScript doesn't care if it was constructed out of JSON or not. So your object in JavaScript syntax will look like this:



const x = { name: 'jack', age: 20 };


If you now do Object.keys(x), you will get this:



[ 'name', 'age' ]


And Object.keys(table[0]) should be exactly what you want: the column names of your 'table'



[ 'name', 'age' ]





share|improve this answer































    1














    Object.keys(table[0])


    will give you the keys of the first row; presumably the other rows will behave and follow the pattern.






    share|improve this answer































      1














      You can get a list of the names of the properties of an object in javascript with this :



      Object.keys();


      Documentation here :



      https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Object/keys



      Response of a similar question here :



      Getting the object's property name






      share|improve this answer































        0














        Just iterate over object keys:



        for (var key in table[0]) {console.log(key);}


        or (will work in most modern browsers):



        Object.keys(table[0]).forEach(key => console.log(key));


        Don't forget to check if "table" has elements



        Also see other possible options






        share|improve this answer





















        • 2





          This is not recommended. Try executing Object.prototype.foo = "bar" before running your code for a nice surprise. If you are using for ... in to iterate over object keys, almost always you'll want to test .hasOwnProperty to rule out intruders.

          – Amadan
          Nov 25 '18 at 23:50











        • True. But I assume in this exact situation nothing is being overridden in Object. Iterating in foreach is just faster and works in old IEs. Here are examples of all techniques: hackernoon.com/…

          – Azee
          Nov 26 '18 at 0:17













        Your Answer






        StackExchange.ifUsing("editor", function () {
        StackExchange.using("externalEditor", function () {
        StackExchange.using("snippets", function () {
        StackExchange.snippets.init();
        });
        });
        }, "code-snippets");

        StackExchange.ready(function() {
        var channelOptions = {
        tags: "".split(" "),
        id: "1"
        };
        initTagRenderer("".split(" "), "".split(" "), channelOptions);

        StackExchange.using("externalEditor", function() {
        // Have to fire editor after snippets, if snippets enabled
        if (StackExchange.settings.snippets.snippetsEnabled) {
        StackExchange.using("snippets", function() {
        createEditor();
        });
        }
        else {
        createEditor();
        }
        });

        function createEditor() {
        StackExchange.prepareEditor({
        heartbeatType: 'answer',
        autoActivateHeartbeat: false,
        convertImagesToLinks: true,
        noModals: true,
        showLowRepImageUploadWarning: true,
        reputationToPostImages: 10,
        bindNavPrevention: true,
        postfix: "",
        imageUploader: {
        brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
        contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
        allowUrls: true
        },
        onDemand: true,
        discardSelector: ".discard-answer"
        ,immediatelyShowMarkdownHelp:true
        });


        }
        });














        draft saved

        draft discarded


















        StackExchange.ready(
        function () {
        StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53473088%2fhow-to-get-json-object-titles%23new-answer', 'question_page');
        }
        );

        Post as a guest















        Required, but never shown

























        4 Answers
        4






        active

        oldest

        votes








        4 Answers
        4






        active

        oldest

        votes









        active

        oldest

        votes






        active

        oldest

        votes









        2














        First of all, an object in JavaScript doesn't care if it was constructed out of JSON or not. So your object in JavaScript syntax will look like this:



        const x = { name: 'jack', age: 20 };


        If you now do Object.keys(x), you will get this:



        [ 'name', 'age' ]


        And Object.keys(table[0]) should be exactly what you want: the column names of your 'table'



        [ 'name', 'age' ]





        share|improve this answer




























          2














          First of all, an object in JavaScript doesn't care if it was constructed out of JSON or not. So your object in JavaScript syntax will look like this:



          const x = { name: 'jack', age: 20 };


          If you now do Object.keys(x), you will get this:



          [ 'name', 'age' ]


          And Object.keys(table[0]) should be exactly what you want: the column names of your 'table'



          [ 'name', 'age' ]





          share|improve this answer


























            2












            2








            2







            First of all, an object in JavaScript doesn't care if it was constructed out of JSON or not. So your object in JavaScript syntax will look like this:



            const x = { name: 'jack', age: 20 };


            If you now do Object.keys(x), you will get this:



            [ 'name', 'age' ]


            And Object.keys(table[0]) should be exactly what you want: the column names of your 'table'



            [ 'name', 'age' ]





            share|improve this answer













            First of all, an object in JavaScript doesn't care if it was constructed out of JSON or not. So your object in JavaScript syntax will look like this:



            const x = { name: 'jack', age: 20 };


            If you now do Object.keys(x), you will get this:



            [ 'name', 'age' ]


            And Object.keys(table[0]) should be exactly what you want: the column names of your 'table'



            [ 'name', 'age' ]






            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Nov 25 '18 at 23:55









            BojiBoji

            787




            787

























                1














                Object.keys(table[0])


                will give you the keys of the first row; presumably the other rows will behave and follow the pattern.






                share|improve this answer




























                  1














                  Object.keys(table[0])


                  will give you the keys of the first row; presumably the other rows will behave and follow the pattern.






                  share|improve this answer


























                    1












                    1








                    1







                    Object.keys(table[0])


                    will give you the keys of the first row; presumably the other rows will behave and follow the pattern.






                    share|improve this answer













                    Object.keys(table[0])


                    will give you the keys of the first row; presumably the other rows will behave and follow the pattern.







                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered Nov 25 '18 at 23:44









                    AmadanAmadan

                    133k13146197




                    133k13146197























                        1














                        You can get a list of the names of the properties of an object in javascript with this :



                        Object.keys();


                        Documentation here :



                        https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Object/keys



                        Response of a similar question here :



                        Getting the object's property name






                        share|improve this answer




























                          1














                          You can get a list of the names of the properties of an object in javascript with this :



                          Object.keys();


                          Documentation here :



                          https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Object/keys



                          Response of a similar question here :



                          Getting the object's property name






                          share|improve this answer


























                            1












                            1








                            1







                            You can get a list of the names of the properties of an object in javascript with this :



                            Object.keys();


                            Documentation here :



                            https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Object/keys



                            Response of a similar question here :



                            Getting the object's property name






                            share|improve this answer













                            You can get a list of the names of the properties of an object in javascript with this :



                            Object.keys();


                            Documentation here :



                            https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Object/keys



                            Response of a similar question here :



                            Getting the object's property name







                            share|improve this answer












                            share|improve this answer



                            share|improve this answer










                            answered Nov 25 '18 at 23:45









                            Shim-SaoShim-Sao

                            710414




                            710414























                                0














                                Just iterate over object keys:



                                for (var key in table[0]) {console.log(key);}


                                or (will work in most modern browsers):



                                Object.keys(table[0]).forEach(key => console.log(key));


                                Don't forget to check if "table" has elements



                                Also see other possible options






                                share|improve this answer





















                                • 2





                                  This is not recommended. Try executing Object.prototype.foo = "bar" before running your code for a nice surprise. If you are using for ... in to iterate over object keys, almost always you'll want to test .hasOwnProperty to rule out intruders.

                                  – Amadan
                                  Nov 25 '18 at 23:50











                                • True. But I assume in this exact situation nothing is being overridden in Object. Iterating in foreach is just faster and works in old IEs. Here are examples of all techniques: hackernoon.com/…

                                  – Azee
                                  Nov 26 '18 at 0:17


















                                0














                                Just iterate over object keys:



                                for (var key in table[0]) {console.log(key);}


                                or (will work in most modern browsers):



                                Object.keys(table[0]).forEach(key => console.log(key));


                                Don't forget to check if "table" has elements



                                Also see other possible options






                                share|improve this answer





















                                • 2





                                  This is not recommended. Try executing Object.prototype.foo = "bar" before running your code for a nice surprise. If you are using for ... in to iterate over object keys, almost always you'll want to test .hasOwnProperty to rule out intruders.

                                  – Amadan
                                  Nov 25 '18 at 23:50











                                • True. But I assume in this exact situation nothing is being overridden in Object. Iterating in foreach is just faster and works in old IEs. Here are examples of all techniques: hackernoon.com/…

                                  – Azee
                                  Nov 26 '18 at 0:17
















                                0












                                0








                                0







                                Just iterate over object keys:



                                for (var key in table[0]) {console.log(key);}


                                or (will work in most modern browsers):



                                Object.keys(table[0]).forEach(key => console.log(key));


                                Don't forget to check if "table" has elements



                                Also see other possible options






                                share|improve this answer















                                Just iterate over object keys:



                                for (var key in table[0]) {console.log(key);}


                                or (will work in most modern browsers):



                                Object.keys(table[0]).forEach(key => console.log(key));


                                Don't forget to check if "table" has elements



                                Also see other possible options







                                share|improve this answer














                                share|improve this answer



                                share|improve this answer








                                edited Nov 26 '18 at 0:19

























                                answered Nov 25 '18 at 23:43









                                AzeeAzee

                                1,4841319




                                1,4841319








                                • 2





                                  This is not recommended. Try executing Object.prototype.foo = "bar" before running your code for a nice surprise. If you are using for ... in to iterate over object keys, almost always you'll want to test .hasOwnProperty to rule out intruders.

                                  – Amadan
                                  Nov 25 '18 at 23:50











                                • True. But I assume in this exact situation nothing is being overridden in Object. Iterating in foreach is just faster and works in old IEs. Here are examples of all techniques: hackernoon.com/…

                                  – Azee
                                  Nov 26 '18 at 0:17
















                                • 2





                                  This is not recommended. Try executing Object.prototype.foo = "bar" before running your code for a nice surprise. If you are using for ... in to iterate over object keys, almost always you'll want to test .hasOwnProperty to rule out intruders.

                                  – Amadan
                                  Nov 25 '18 at 23:50











                                • True. But I assume in this exact situation nothing is being overridden in Object. Iterating in foreach is just faster and works in old IEs. Here are examples of all techniques: hackernoon.com/…

                                  – Azee
                                  Nov 26 '18 at 0:17










                                2




                                2





                                This is not recommended. Try executing Object.prototype.foo = "bar" before running your code for a nice surprise. If you are using for ... in to iterate over object keys, almost always you'll want to test .hasOwnProperty to rule out intruders.

                                – Amadan
                                Nov 25 '18 at 23:50





                                This is not recommended. Try executing Object.prototype.foo = "bar" before running your code for a nice surprise. If you are using for ... in to iterate over object keys, almost always you'll want to test .hasOwnProperty to rule out intruders.

                                – Amadan
                                Nov 25 '18 at 23:50













                                True. But I assume in this exact situation nothing is being overridden in Object. Iterating in foreach is just faster and works in old IEs. Here are examples of all techniques: hackernoon.com/…

                                – Azee
                                Nov 26 '18 at 0:17







                                True. But I assume in this exact situation nothing is being overridden in Object. Iterating in foreach is just faster and works in old IEs. Here are examples of all techniques: hackernoon.com/…

                                – Azee
                                Nov 26 '18 at 0:17




















                                draft saved

                                draft discarded




















































                                Thanks for contributing an answer to Stack Overflow!


                                • Please be sure to answer the question. Provide details and share your research!

                                But avoid …



                                • Asking for help, clarification, or responding to other answers.

                                • Making statements based on opinion; back them up with references or personal experience.


                                To learn more, see our tips on writing great answers.




                                draft saved


                                draft discarded














                                StackExchange.ready(
                                function () {
                                StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53473088%2fhow-to-get-json-object-titles%23new-answer', 'question_page');
                                }
                                );

                                Post as a guest















                                Required, but never shown





















































                                Required, but never shown














                                Required, but never shown












                                Required, but never shown







                                Required, but never shown

































                                Required, but never shown














                                Required, but never shown












                                Required, but never shown







                                Required, but never shown







                                -

                                Popular posts from this blog

                                Ottavio Pratesi

                                Image
                                .mw-parser-output .avviso .mbox-text-div>div,.mw-parser-output .avviso .mbox-text-full-div>div{font-size:90%}.mw-parser-output .avviso .mbox-image div{width:52px}.mw-parser-output .avviso .mbox-text-full-div .hide-when-compact{display:block} Questa voce sull'argomento ciclisti italiani è solo un abbozzo . Contribuisci a migliorarla secondo le convenzioni di Wikipedia. Ottavio Pratesi Nazionalità   Italia Ciclismo Specialità Strada Ritirato 1927 Carriera Squadre di club 1910-1911 Individuale 1912   Alcyon-Dunlop 1913 Globo-Dunlop 1914   Alcyon-Dunlop 1915-1922 Individuale 1923 Lygie 1924 Ostende 1925 Individuale   Modifica dati su Wikidata  · Manuale Ottavio Pratesi (Rosignano Marittimo, 1º gennaio 1889 – Livorno, 3 novembre 1977) è stato un ciclista su strada italiano, professionista tra il 1910 ed il 1925, era soprannominato il "Falco di ...
                                Read more

                                Tricia Helfer

                                Image
                                Tricia Helfer Tricia Helfer al Comic-Con 2015 Altezza 179 [1]  cm Misure 86-61-89 [1] Taglia 38 [1] (UE) - 8 [1] (US) Scarpe 40 [1] (UE) - 9 [1] (US) Occhi Azzurri [1] Capelli Biondo scuro [1] Modifica dati su Wikidata  · Manuale Tricia Helfer (Donalda, 11 aprile 1974) è una supermodella e attrice canadese, conosciuta principalmente per il suo ruolo di Numero Sei nella serie televisiva Battlestar Galactica . Indice 1 Carriera 2 Filmografia 2.1 Cinema 2.2 Televisione 2.3 Video musicali 2.4 Doppiatrice 2.4.1 Cinema 2.4.2 Televisione 2.4.3 Videogiochi 2.5 Produttrice 2.6 Agenzie 3 Doppiatrici italiane 4 Note 5 Altri progetti 6 Collegamenti esterni Carriera | Di origine inglese, tedesca, norvegese e svedese, nel 1992 Tricia vinse il concorso di "Ford Models Supermodel of the World", organizzato dall'agenzia Ford Models e fu poi assunta dall'agenzia ...
                                Read more

                                15 giugno

                                Image
                                gennaio  · febbraio  · marzo  · aprile  · maggio  · giugno 2018  · luglio  · agosto  · settembre  · ottobre  · novembre  · dicembre Ve Sa Do Lu Ma Me Gi Ve Sa Do Lu Ma Me Gi Ve Sa Do Lu Ma Me Gi Ve Sa Do Lu Ma Me Gi Ve Sa ← 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 → Il 15 giugno è il 166º giorno del calendario gregoriano (il 167º negli anni bisestili). Mancano 199 giorni alla fine dell'anno. Indice 1 Eventi 2 Nati 3 Morti 4 Feste e ricorrenze 4.1 Civili 4.2 Religiose 5 Altri progetti Eventi | 763 a.C. – Gli Assiri registrano un'eclissi solare 923 – Battaglia di Soissons: re Roberto I di Francia viene ucciso, re Carlo il Semplice viene arrestato dai sostenitori del duca Rodolfo di Borgogna 1094 – Reconquista: Valencia cade nelle mani di El Cid 1215 – Re Giovanni d'Inghilterra appone i...
                                Read more