ProMeTraWiki/ExcelFormat: Difference between revisions
imported>HeikoNeuweger No edit summary |
imported>HeikoNeuweger No edit summary |
||
| Line 4: | Line 4: | ||
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. | |||
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. | ||
The | 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. | 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. | 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 | 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 | 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 smaller the individual divisions of the rectangular elements become in the generated images. | ||
Revision as of 22:38, 9 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.