With easy tables for Confluence, import your data from excel or csv, and the app will build your table automatically. You can add colors and styles from a simple wizard.
Refresh the page, and move mouse in left bottom corner of the table, 3 buttons will appear.
By clicking the button, 'Add Numbers' the app will add numbers, so you can easily find line and column of any cell you want to color.
Configure first line with gray color and first column with orange color. Click save on every line you modified and, in the end, click close. For the line : background-color: #BDBDBD;font-weight: bold; and for the column : background-color: #F5D0A9;font-weight: bold;
Cell 2, 12 will have green background to show the good result in this date. Please note that if you want to remove the style entered for cell 2, 12, just type 2 and 12, and let 3rd input empty, and click save. This will remove the color for the cell. The same for lines, columns, etc.
Let's say you have your employees names, and their photos in different sizes, CVs. You can add them one by one manually or automate the process.
Let say that we have images and files with thoses format. name1-name2.png or .pdf. Add the list of names in Excel.
By putting mouse in right bottom of the cell '.jpg', and keeping mouse clicked, move mouse down to have all column with .jpg value
Select the spaces, and replace them by nothing. In order to have images and files names well written.
Note that you can add images and files from other websites, just type img:http://my-website/my-image.png or for files like this pdf example : pdf:http://my-website/my-file.pdf&&title of the file
For files, default prefix is file: but you can show specific icons using doc: or docx: or pdf: or xls: or xlsx: or ppt: or pptx:
They can be uploaded to the same page or another page. In our case, it is the same page. If you decide to have files in another page, just type 'img:resource page name/image file name' in excel page (previous step)
Click on edit page, and add text to the macro. Note that if you want to have a fixed width for all images, add in the first line of the column : &&width&&no&&all for example &&200px&&no&&all if you want to specify the height 100px add &&200px&&100px&&all
Instead of px you can use %.