Excel File Size Growth Due to Row Hiding

[aphsa]

When I don't use the SetRowVisible method, my Excel file remains small, around 7KB. However, here's the code I'm using:

func hideRows(f *excelize.File, sheet string, startRow int) error {
    for row := startRow; row <= 1048576; row++ { // Max rows in Excel
        if err := f.SetRowVisible(sheet, row, false); err != nil {
            return fmt.Errorf("failed to hide row %d: %w", row, err)
        }
    }
    return nil
}

If I apply SetRowVisible to hide all rows from 22 downwards, the size of the Excel file (xlsx) increases dramatically to about 2.5MB. Is there a way to avoid this significant increase in file size?

[SinghNanak]

I use following approach

	if err := f.SetSheetProps(sheetName, &excelize.SheetPropsOptions{ZeroHeight: &enable}); err != nil {
		fmt.Println(err)
	}

	if err := f.SetRowVisible(sheetName, lastUsedRow, true); err != nil {
		log.Printf("Warning: Failed to unhide rows till %d: %v", lastUsedRow, err)
	}