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
Page 1 / 1
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
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.
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 @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 @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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.