Writing without entire spreadsheet in memory about rubyxl HOT 4 CLOSED

I think supporting this would be quite challenging. The XML data format is not friendly in any way. As I recall, Excel itself does not handle large spreadsheets very gracefully.

from rubyxl.

older versions of excel i think were limited to 64k lines and newer versions implement some kind of paging so performance in newer versions of excel shouldn't be that terrible. However, as amenfredi commented it wouldn't be a simple task to implement a stream if you are looking into this and you only need to output it then you should be able to just have a blank excel file saved some where and then you could copy it open the archive and read in the excel worksheet and then just insert a bunch of cells as text.

1. read in the file
2. print the top half of the file to some new file
3. transform the data row you have and then output it should be simple
4. print the bottom of the file

in the archive the file would be in xl > worksheets > sheet1.xml
the section you would add it into is sheetdata
and example of a row is


0

from rubyxl.

lol github converted the xml I included

they look basicaly like
row r="1"
c r="A1" s="1" t="s"
v 0 /v
/c
/row

from rubyxl.

The problem is that the files are severely interconnected. Besides, how do you imagine further manipulating that Excel file in, well, Excel without loading it into memory? I'm afraid this request is not doable.

from rubyxl.