By Mikey


2016-06-22 05:57:15 8 Comments

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

3 comments

@ahmadhanb 2016-06-22 06:58:29

  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

@Mikey 2016-06-22 07:38:05

Thank you, this is a very good solution. It doesn't quite given me the result I need in terms of been able to customize how it looks though,e.g. different font colors for different items within the table etc. I'm also not able to resize it? Its fixed. Added example of table, to original question.

@ahmadhanb 2016-06-22 07:44:02

You can resize it using the cell margin, and you can change the header font as well as the font of items separately. I am using QGIS 2.8.9

@Manoel Guedes 2016-06-22 16:55:43

With the worksheet in Excel you can save to the WEB page where the form will generate a file in HTML format after you push the print composite through HTML frame icon. Tip Select the worksheet and save only the selected area.

enter image description here

enter image description here

@Ed Rollason 2016-06-22 08:01:58

You mention you're using inkscape so you could try flipping your method round rather than doing it all in QGIS. Have you tried exporting the composer to an SVG, open it into inkscape and then import the formatted table as a png?

Related Questions

Sponsored Content

1 Answered Questions

[SOLVED] Adding dashed line in QGIS print composer?

1 Answered Questions

Export raster in pieces to stitch together afterwards or other way to print a big map?

  • 2019-05-16 18:14:06
  • Golar Ramblar
  • 37 View
  • 0 Score
  • 1 Answer
  • Tags:   qgis raster printing

1 Answered Questions

[SOLVED] QGIS 3.4 - Print composer export to image error

4 Answered Questions

0 Answered Questions

Fuzzy PDF export in QGIS running on macSierra OS

2 Answered Questions

[SOLVED] QGIS 2.14 Composer incorrectly renders svg text position

1 Answered Questions

[SOLVED] How to create a customizabe table in QGIS Print Composer?

5 Answered Questions

[SOLVED] Obtaining print quality PDF or PNG output from QGIS?

0 Answered Questions

How to add a large inset svg or pdf in QGIS 2.3 print composer?

2 Answered Questions

[SOLVED] QGIS exporting huge SVG

Sponsored Content