Import xlsx list



  • 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



  • @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



  • 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


Log in to reply