Excel Export

<< Click to Display Table of Contents >>

Navigation:  Project Data and Reporting > Lab Reports > Chemistry Table > Chem Table Layout >

Excel Export

Previous pageReturn to chapter overviewNext page

 

The Excel Export menu allows users to export the Chem Table to Excel, as well as configuring default export settings.

 

clip4104

 

There are two options for exporting a Chem Table to Excel:

 

1.Horizontal - displays the Chem Names horizontally across the page (as shown on the Chem Table view).

clip4106

 

2.Vertical - displays the Chem Names vertically down the page

clip4105

 

 

Excel Export Settings

 

The Excel Export Settings allow users to configure settings for the print view and how the report will be shown in Excel.

 

This is split into four different sections.

 

General

This section includes options for general page layout and print option and relate to the corresponding page and print settings in Excel.  The exception is "Use 4 Column Style", which will be explained in more detail here.

Formatting

Default font size and table row and column heading formatting.

Header Content

Allows for the population of Excel header with default Excel header content (such as page number, date, etc.) as well as specific ESdat data related to the Chem Table such as Licencee Logo, Project ID, Site Name, etc.

Footer Content

Allows for the population of Excel footer with default Excel footer content (such as page number, date, etc.) as well as specific ESdat data related to the Chem Table such as Licencee Logo, Project ID, Site Name, etc.

 

General

 

clip4107

 

Formatting

 

clip4108

 

Header Content

 

Header content is specified across three main sections, left center and right of the page. Select an item from the Insert drop down for inclusion in the header.

 

If a logo has been uploaded for the Licencee it will be available in this drop down for selection into the header, as well as many other database values.  Auto values (populated by ESdat or Excel) are shown with a red border.

 

Free text can also be typed into the cell with font formatting available.  

 

clip4110

 

Note that there is a length limit to how much content can be set in the header, which is an Excel constraint. If the allowed length is breached an error notification will be displayed in the print view and the content will need to be revised to fit.  

 

Footer Content

 

The Footer content is configured the same as for the Header, and has the same options.

 

clip4111