Hi,
I would like to add a new row containing some descriptive information from a seperate stream above header row in an excel spreadsheet.
Thanks
David McDermott
Solved
Add row(s) above header in Excel
+6- Contributor
Best answer by takashi
Hi @djmcdermott, a possible way is to write data records starting with a specific row using a FeatureWriter, and then write (insert) descriptive rows starting with the first row in the same sheet using another Excel writer. You can control starting row through the Start Row parameter in the Excel writer feature type. For example, assuming that the number of descriptive rows is three,
FeatureWriter (Excel Writer / Feature Type) Parameters
- Overwrite Existing File: Yes
- Output Field Names: Yes
- Use Attribute Names As Column Positions: No
- Start Position | Start Row: 4 (= 3 + 1)
Excel Writer / Feature Type Parameters
- Overwrite Existing File: No
- Output Field Names: No
- Use Attribute Names As Column Positions: Yes
- Start Position | Start Row: 1
+19- Contributor
- Best Answer
Hi @djmcdermott, a possible way is to write data records starting with a specific row using a FeatureWriter, and then write (insert) descriptive rows starting with the first row in the same sheet using another Excel writer. You can control starting row through the Start Row parameter in the Excel writer feature type. For example, assuming that the number of descriptive rows is three,
FeatureWriter (Excel Writer / Feature Type) Parameters
- Overwrite Existing File: Yes
- Output Field Names: Yes
- Use Attribute Names As Column Positions: No
- Start Position | Start Row: 4 (= 3 + 1)
Excel Writer / Feature Type Parameters
- Overwrite Existing File: No
- Output Field Names: No
- Use Attribute Names As Column Positions: Yes
- Start Position | Start Row: 1
1 person upvoted this
+15- Contributor
Excel reader has a xlsx_row_id attribute.
Read the excel, increase xlsx_row_id by 1.
Create your row to be inserted on top, give it number 0 and sort.
Write to excel.
+6- Contributor
takashi wrote:
Hi @djmcdermott, a possible way is to write data records starting with a specific row using a FeatureWriter, and then write (insert) descriptive rows starting with the first row in the same sheet using another Excel writer. You can control starting row through the Start Row parameter in the Excel writer feature type. For example, assuming that the number of descriptive rows is three,
FeatureWriter (Excel Writer / Feature Type) Parameters
- Overwrite Existing File: Yes
- Output Field Names: Yes
- Use Attribute Names As Column Positions: No
- Start Position | Start Row: 4 (= 3 + 1)
Excel Writer / Feature Type Parameters
- Overwrite Existing File: No
- Output Field Names: No
- Use Attribute Names As Column Positions: Yes
- Start Position | Start Row: 1
+19- Contributor
takashi wrote:
Hi @djmcdermott, a possible way is to write data records starting with a specific row using a FeatureWriter, and then write (insert) descriptive rows starting with the first row in the same sheet using another Excel writer. You can control starting row through the Start Row parameter in the Excel writer feature type. For example, assuming that the number of descriptive rows is three,
FeatureWriter (Excel Writer / Feature Type) Parameters
- Overwrite Existing File: Yes
- Output Field Names: Yes
- Use Attribute Names As Column Positions: No
- Start Position | Start Row: 4 (= 3 + 1)
Excel Writer / Feature Type Parameters
- Overwrite Existing File: No
- Output Field Names: No
- Use Attribute Names As Column Positions: Yes
- Start Position | Start Row: 1
+1takashi wrote:
Hi @djmcdermott, a possible way is to write data records starting with a specific row using a FeatureWriter, and then write (insert) descriptive rows starting with the first row in the same sheet using another Excel writer. You can control starting row through the Start Row parameter in the Excel writer feature type. For example, assuming that the number of descriptive rows is three,
FeatureWriter (Excel Writer / Feature Type) Parameters
- Overwrite Existing File: Yes
- Output Field Names: Yes
- Use Attribute Names As Column Positions: No
- Start Position | Start Row: 4 (= 3 + 1)
Excel Writer / Feature Type Parameters
- Overwrite Existing File: No
- Output Field Names: No
- Use Attribute Names As Column Positions: Yes
- Start Position | Start Row: 1
Hi @Takashi
Your answer help me a lot to solve : https://knowledge.safe.com/questions/112230/how-to-define-some-values-in-excel-header-with-att.html
Thank you
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.