Streamwriter style with alignment

[aphsa]

None of the alignment properties work with Stream writer. In this example the third column shows up too wide with two long words adjacent to each other. WrapText is not getting enforced.
PS: I also like to know what is the correct ReadingOrder value for "Left to Right".

package main

import (
	"fmt"
	"math/rand"

	"github.com/xuri/excelize/v2"
)

func genexcel() {
	file := excelize.NewFile()
	defer func() {
		if err := file.Close(); err != nil {
			fmt.Println(err)
		}
	}()
	streamWriter, err := file.NewStreamWriter("Sheet1")
	if err != nil {
		fmt.Println(err)
	}

	alignment := &excelize.Alignment{Horizontal: "top", Vertical: "top", WrapText: true, ReadingOrder: 0}
	
	style, err := file.NewStyle(&excelize.Style{Alignment: alignment})
	if err != nil {
		fmt.Println(err)
	}

	file.SetSheetName("Sheet1", "Dummy Report")
	header := []interface{}{
		excelize.Cell{StyleID: style, Value: "Name"},
		excelize.Cell{StyleID: style, Value: "DummyH1"},
		excelize.Cell{StyleID: style, Value: "DummyH2"},
	}

	err = streamWriter.SetPanes(&excelize.Panes{
		Freeze:      true,
		YSplit:      1,
		TopLeftCell: "A2",
		ActivePane:  "bottomLeft",
	})

	if err != nil {
		fmt.Println(err)
	}

	streamWriter.SetColWidth(1, 1, 20)
	streamWriter.SetColWidth(2, 2, 9)
	streamWriter.SetColWidth(3, 3, 23)

	err = streamWriter.SetRow("A1", header)

	if err != nil {
		fmt.Println(err)
	}

	// Test Row data
	for rowID := 2; rowID <= 165; rowID++ {
		row := make([]interface{}, 3)
		row[0] = GenerateRandomString(20)
		row[1] = rand.Intn(640000)
		row[2] = GenerateRandomFQDN() + "  " + GenerateRandomFQDN()
		cell, _ := excelize.CoordinatesToCellName(1, rowID)
		if err := streamWriter.SetRow(cell, row); err != nil {
			fmt.Println(err)
		}
	}

	if err := streamWriter.Flush(); err != nil {
		fmt.Println(err)
	}
	if err := file.SaveAs("Book1.xlsx"); err != nil {
		fmt.Println(err)
	}
}

[xuri]

Thanks for your feedback.

1. You only create a style with a top alignment style for the cells in the header row. Currently, because the library doesn't support set column style in stream mode, you need to set alignment for each cell in the third column. I don't make sure what result you expected, if you think the third column is too wide, you can change the column width by the SetColWidth function in stream writer.

2. The WrapText properties should work with \r\n control characters in the cell value, if you want to wrap the text for the header row, please add newline control characters in the cell value, for example:

- excelize.Cell{StyleID: style, Value: "DummyH1"},
+ excelize.Cell{StyleID: style, Value: "Dummy\r\nH1"},

3. The Readingorder indicating whether the reading order (bidirectionality) of the cell is leftto-
   right, right-to-left, or context dependent:

0 - Context Dependent - reading order is determined by scanning the text for the first
non-whitespace character: if it is a strong right-to-left character, the reading order is
right-to-left; otherwise, the reading order left-to-right.
1 - Left-to-Right- reading order is left-to-right in the cell, as in English.
2 - Right-to-Left - reading order is right-to-left in the cell, as in Hebrew.