Import xlsx list

Magnus Brodin

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 Frank

@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

Magnus Brodin

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