ProMeTraWiki/ExcelFormat: Difference between revisions
Jump to navigation
Jump to search
imported>HeikoNeuweger No edit summary |
imported>HeikoNeuweger No edit summary |
||
| Line 2: | Line 2: | ||
== Supported Excel Formats == | == Supported Excel Formats == | ||
Please upload only Excel files in the .xls format (Office 1997-2004). | * Please upload only Excel files in the .xls format (Office 1997-2004). | ||
* ProMeTra does not yet support Office 2008 documents. | |||
ProMeTra does not yet support Office 2008 documents. | * Only the data in the first spreadsheet of your Excel document will be retrieved. | ||
* The ProMeTra parser automatically reads the experimental factors from the first row and the individual identifiers of the proteins, transcripts or metabolites from the first column. ProMeTra does only support numerical data matrices. Please make sure that no text elements occur elsewhere than in the first row and column. | |||
Only the data in the first spreadsheet of your Excel document will be retrieved. | * The following image shows a typical Excel sheet that can be uploaded via the ProMeTra interface. | ||
The ProMeTra parser automatically reads the experimental factors from the first row and the individual | |||
identifiers of the proteins, transcripts or metabolites from the first column. ProMeTra does only | |||
support numerical data matrices. Please make sure that no text elements occur elsewhere than in the first row and column. | |||
The following image shows a typical Excel sheet that can be uploaded via the ProMeTra interface. | |||
[[Image:ProMeTraWiki$$ExcelFormat$excel.png]] | [[Image:ProMeTraWiki$$ExcelFormat$excel.png]] | ||
The number of factors should be adjusted to the width of the rectangular elements in your Pathway- and GenomeMaps. | * The number of factors should be adjusted to the width of the rectangular elements in your Pathway- and [[GenomeMaps]]. For the standard GenomeMap up to ten factors are a reasonable number, the more factors ProMeTra has to visualize, the smaller the individual divisions of the rectangular elements become in the generated images. | ||
For the standard GenomeMap up to ten factors are a reasonable number, the more factors ProMeTra has to visualize, | |||
the smaller the individual divisions of the rectangular elements become in the generated images. | |||
Revision as of 00:10, 10 March 2009
Supported Excel Formats
- Please upload only Excel files in the .xls format (Office 1997-2004).
- ProMeTra does not yet support Office 2008 documents.
- Only the data in the first spreadsheet of your Excel document will be retrieved.
- The ProMeTra parser automatically reads the experimental factors from the first row and the individual identifiers of the proteins, transcripts or metabolites from the first column. ProMeTra does only support numerical data matrices. Please make sure that no text elements occur elsewhere than in the first row and column.
- The following image shows a typical Excel sheet that can be uploaded via the ProMeTra interface.
File:ProMeTraWiki$$ExcelFormat$excel.png
- The number of factors should be adjusted to the width of the rectangular elements in your Pathway- and GenomeMaps. For the standard GenomeMap up to ten factors are a reasonable number, the more factors ProMeTra has to visualize, the smaller the individual divisions of the rectangular elements become in the generated images.