excelize icon indicating copy to clipboard operation
excelize copied to clipboard

stream rows read data enhancement

Open fudali113 opened this issue 2 years ago • 2 comments

Expect to be able to get more content when streaming reads the data:

such as:

  • [ ] get cols info
  • [ ] get row cells attrs
  • [ ] get mergeCells info
  • [ ] get dimension info
  • [ ] get sheetViews info

etc.

fudali113 avatar Apr 21 '23 02:04 fudali113

Thanks for your issue. The aim of creating the stream mode functions was not re-provide each function as the normal mode functions, it was just used to process the workbook with the huge amount of data, we need to evaluate if those features suit a typical scenario.

xuri avatar Apr 22 '23 11:04 xuri

The problem I am facing now is that obtaining relevant information of sheet is a rigid requirement; When we encounter large files, we can reduce the memory overhead by streaming row data, but when we get other sheet information, we can only downgrade to full memory load.

Because these information can be obtained without performance loss during stream reading, it is hoped to enhance stream reading to obtain relevant information.

fudali113 avatar Apr 23 '23 07:04 fudali113