Back
Share

Insert an Excel file screenshot in a map page setup

Drafted the 2010 10 20

In order to show examples of the world oil production, we want to integrate an Excel spreadsheet screenshot into C&D page setup.

This tip is possible with Windows Vista and Seven operating systems thanks to the capture tool available in the accessories.

Map creation in C&D

The first step is map creation. In this example, we use a polar projection of Northern Hemisphere.

Excel table capture

Then, access the Excel file used for your source data and use the capture tool to select the area you want and save it as png, jpeg or gif format.

Insert an Excel file screenshot in a map page setup - Fig. 2 - Excel table capture

Insert your table in C&D

When your are back to C&D, go the page setup

Insert the Excel table image

Astuce - Insérer un aperçu de fichier Excel dans une mise en page de carte - Fig. 3 - Sélectionnez l’outil « Ajouter une image » puis tracez un rectangle dans lequel devra s’inscrire l’image du tableau Excel

To complete this operation, select the tool “add image” then draw a rectangle in which the Excel table image will be displayed. While the image is still selected, go to Image properties:

Insert an Excel file screenshot in a map page setup -  Fig. 4 - Image properties

Tick the box “keep original shape” in order to keep your image proportions (height/width)

Insert an Excel file screenshot in a map page setup - Fig. 5 - Tick the box “keep original shape” in order to keep your image proportions (height/width)

Prepare map export

Results of the image insertion clearer once the map is exported

Astuce - Insérer un aperçu de fichier Excel dans une mise en page de carte - Fig. 6 - Résultat final

Add A Comment


This is a captcha-picture. It is used to prevent mass-access by robots. (see: www.captcha.net)