From 790c363cceaaa09e91ad579e2d25cb13c1582bba Mon Sep 17 00:00:00 2001
From: xuri <xuri.me@gmail.com>
Date: Sat, 18 Sep 2021 23:20:24 +0800
Subject: This closes #833, closes #845, and closes #1022, breaking changes

- Close spreadsheet and row's iterator required
- New options `WorksheetUnzipMemLimit` have been added
- Improve streaming reading performance, memory usage decrease about 93.7%
---
 stream_test.go | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

(limited to 'stream_test.go')

diff --git a/stream_test.go b/stream_test.go
index fda44fb..6cfed07 100644
--- a/stream_test.go
+++ b/stream_test.go
@@ -115,6 +115,21 @@ func TestStreamWriter(t *testing.T) {
 	cellValue, err := file.GetCellValue("Sheet1", "A1")
 	assert.NoError(t, err)
 	assert.Equal(t, "Data", cellValue)
+
+	// Test stream reader for a worksheet with huge amounts of data.
+	file, err = OpenFile(filepath.Join("test", "TestStreamWriter.xlsx"))
+	assert.NoError(t, err)
+	rows, err := file.Rows("Sheet1")
+	assert.NoError(t, err)
+	cells := 0
+	for rows.Next() {
+		row, err := rows.Columns()
+		assert.NoError(t, err)
+		cells += len(row)
+	}
+	assert.NoError(t, rows.Close())
+	assert.Equal(t, 2559558, cells)
+	assert.NoError(t, file.Close())
 }
 
 func TestStreamSetColWidth(t *testing.T) {
-- 
cgit v1.2.1