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)	}