Saturday, 3 December 2016

Adding excel table to QGIS print composer?


Can anyone suggest some ideas to add a excel table to the print composer which will then be exported as a A3 png while retaining resolution. Attempted pasting in word as an enhanced meta file then saving it as a png > adding to composer, also tried exporting the table as pdf then converting to SVG in Inkscape (which retains resolution / scalability but doesn't render text in columns correctly).


enter image description here



Answer





  1. Save your excel file as CSV file

  2. go to Add Vector Layer in QGIS and navigate to your CSV file and load it

  3. In the print composer, go to Add attribute table, as you can see below:


enter image description here



  1. Select the Source from Layer Feature from the window in the right,as shown below:


enter image description here




  1. You can change the font and formats based on your needs, and here is final output:


enter image description here


UPDATE


In QGIS 2.14.3 there is an extra option (Advanced Customization) that you can change the background color of the header, rows (even OR odd), columns (even OR odd), as you can see in the image below


enter image description here


It will create something close to what you need


enter image description here


No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...