ProMeTraWiki/ExcelFormat: Difference between revisions
Jump to navigation
Jump to search
imported>HeikoNeuweger No edit summary |
|||
| (One intermediate revision by one other user not shown) | |||
| 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. | * Only the data in the first spreadsheet of your Excel document will be retrieved. | ||
| Line 8: | Line 8: | ||
* The following image shows a typical Excel sheet that can be uploaded via the ProMeTra interface. | * The following image shows a typical Excel sheet that can be uploaded via the ProMeTra interface. | ||
[[File:ProMeTra_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. | * 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. | ||
Latest revision as of 10:25, 21 March 2012
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.
- 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.