User:Ccsmith/sandbox/wiki2

Creating tables in the Wiki can be a little confusing to patrons. Some find the coding a bit strange and difficult to work with. However, if you are comfortable with spreadsheets such as Excel, you could create your tables in Excel and then import them into the Wiki. In addition, there may already exist a spreadsheet that you want to place in an article. In either case, here is how to place a spreadsheet in to the Wiki

How to copy a spreadsheet table into the Wiki

 * 1) Open the spreadsheet.
 * 2) Resave the spreadsheet with a csv extention. It would be better to save under a different name as well so you don't think it the regular spreadsheet coding.
 * 3) Highlight the cells you want to import and copy with the right click of the mouse or CTRL+C.
 * 4) Open the website, CSV to Wikitext Converter.
 * 5) Paste the data you copied into the left box. The cvs program will automatically convert the file to wikitext coding in the right box.
 * 6) If your table has a row of titles at the top, click on the box located at the top of the webpage, "The first row is the header"
 * 7) Highlight the coding in the right box and click CRTL+C to save to your clipboard.
 * 8) Open the Wiki and click "Edit source" on the page where you want to place the table.
 * 9) Place the cursor where on the page you want it and click CRTL+V. Beware you cannot use the Visual Editor to paste this coding.



Adding Borders to the Table
To add borders to the table:


 * 1) Click on the tab, "Edit source" and locate at the top of the table, "{|".
 * 2) Add the following code to create borders around each cell: class="wikitable"
 * 3) The coding will look like this: {| class="wikitable"
 * 4) Save the page and you will now see borders around each cell.

More Styling to the Cells
Lets use this example to demonstrate:
 * Look at the coding and you will notice two pipes ||.
 * These pipes separate cells. If the coding for cells in a row are all on the same line, you have to separate the cells with double pipes.
 * It is between the two pipes that you can add additional styling in Wikitext such as:

Here is the wikitext coding for this table as might be generated by the spreadsheet conversion program. To add any styling to a row of cells, it is entered after the double pipes. Here's how: Here is what it looks like: