This section should demonstrate several common tasks which can be done in XiMpLe with a minimal effort.
For more information please see the user's guide which is available in the section download.

1. Copy texts from a simple xml table to Excel
2. Adding new rows prepared in Excel to the XML table
3. Copy a part of an xml document to some other place
4. Manipulate data nested inside a structure
5. Create a table from csv file
6. Remove table rows matching some criteria

5. Create a table from csv file

Let's have some csv file. Open it in some text editor (like notepad). We can open it in XiMpLe too. Of course we get an error message that the file is not well-formed xml file but we need only a text editor for now.
Read csv into XiMpLe text editor

Copy the first row (headings) to the clipboard (Ctrl+C). Data in the csv are usually separated by a comma character so we have to set the separator in XiMpLe general setting (menu Settings/General...) for pasting (a separator can be set even to a string if necessary).
Set separator for pasting in General settings

Now we need to create a new table in a destination xml file.
Append table in a data grid view (xml editor)

Before a new table is created we have to set parameters for this table: a name and a number of columns. If we have already copied headings from csv to clipboard we can see a hint in the top right corner how many columns we need for a new table.
Set parameters for a new table

A new table is created with two empty rows. The columns currently have some predefined column names.
A new table created

A column headings can be overwritten by data stored in clipboard. Don't forget that not all characters are allowed for element names - not allowed characters are replaced by an underscore character.
Overwrite default column headings by headings from csv

Headings are set according the clipboard data.
Headings set according to clipboard data

Now we need to select csv data in a text editor and copy it to clipboard. Then we can paste them to the table. If the last row is selected data are appended at the end of the table.
Paste csv data into table rows

Finally we select first two empty rows and delete them to complete our work.
Data pasted in the table

Final result.
Final result

Previous     Next