Community
    • Login

    Import xlsx list

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    import xlsx
    3 Posts 2 Posters 1.8k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Magnus BrodinM
      Magnus Brodin
      last edited by

      Hello,
      I have a document containing several rows (between 100 & 200) with names that I would like to import into an existing xml document so I do not have to type every single row. The names in the xlsx document are arranged in one column and the xml document has other information in each row that needs to be as it is.

      <user login="1235" password="4." name="1 " role="cashier"/>
      <user login="1236" password="4." name="2 " role="cashier"/>
      <user login="1237" password="4." name="3 " role="cashier"/>
      <user login="1238" password="94" name="4 " role="cashier"/>
      <user login="1239" password="94" name="5 " role="cashier"/>
      <user login="1240" password="94" name="6 " role="cashier"/>
      <user login="1241" password="94" name="7 " role="cashier"/>
      <user login="1242" password="94" name="8 " role="cashier"/>
      <user login="1243" password="94" name="9 " role="cashier"/>
      <user login="1244" password="94" name="10" role="cashier"/>
      

      Is there an easy way to copy/paste an entire column with text?

      Regards Magnus

      Claudia FrankC 1 Reply Last reply Reply Quote 1
      • Claudia FrankC
        Claudia Frank @Magnus Brodin
        last edited by

        @Magnus-Brodin

        am I right to assume you do have this

        <user login="1235" password="4." name="1 " role="cashier"/>
        <user login="1236" password="4." name="2 " role="cashier"/>
        <user login="1237" password="4." name="3 " role="cashier"/>
        <user login="1238" password="94" name="4 " role="cashier"/>
        <user login="1239" password="94" name="5 " role="cashier"/>
        <user login="1240" password="94" name="6 " role="cashier"/>
        <user login="1241" password="94" name="7 " role="cashier"/>
        <user login="1242" password="94" name="8 " role="cashier"/>
        <user login="1243" password="94" name="9 " role="cashier"/>
        <user login="1244" password="94" name="10" role="cashier"/>
        

        and text like this

        name_1
        name_2
        name_3
        name_4
        name_5
        name_6
        name_7
        name_8
        name_9
        name_10
        

        and want to get a list like

        <user login="1235" password="4." name="name_1" role="cashier"/>
        <user login="1236" password="4." name="name_2" role="cashier"/>
        <user login="1237" password="4." name="name_3" role="cashier"/>
        <user login="1238" password="94" name="name_4" role="cashier"/>
        <user login="1239" password="94" name="name_5" role="cashier"/>
        <user login="1240" password="94" name="name_6" role="cashier"/>
        <user login="1241" password="94" name="name_7" role="cashier"/>
        <user login="1242" password="94" name="name_8" role="cashier"/>
        <user login="1243" password="94" name="name_9" role="cashier"/>
        <user login="1244" password="94" name="name_10" role="cashier"/>
        

        ??

        Or is the name column not existing in the original xlsx document?

        In both cases you could use the column mode functionality, which means
        pressing SHIFT+ALT and using keyboard or mouse to select the text you want
        to copy and press ctrl+c.
        Then go to the column where you want to do the modification and
        either replace, by, again, select the text as column selection and press ctrl+v
        or if it needs to be inserted, just create a column selection line and press ctrl+v

        Is that what you want/try to achieve?

        Cheers
        Claudia

        1 Reply Last reply Reply Quote 0
        • Magnus BrodinM
          Magnus Brodin
          last edited by

          You are an angel :-) My mistake is that I tried to copy from Excel instead of making a new document i Notepad++ and that resulted in many very strange things. Now everything is ok. Thank you!

          Best regards Magnus

          1 Reply Last reply Reply Quote 1
          • First post
            Last post
          The Community of users of the Notepad++ text editor.
          Powered by NodeBB | Contributors