spreadsheet-excel-0.3.5.1 MaxSizeError

1 I do excel induced with spreadsheet-excel-0.3.5.1, the following errors were found:

MaxSizeError

vendor/plugins/spreadsheet-excel-0.3.5.1/lib/spreadsheet/olewriter.rb:65:in `set_size'
vendor/plugins/spreadsheet-excel-0.3.5.1/lib/spreadsheet/workbook.rb:99:in `store_ole_file'
vendor/plugins/spreadsheet-excel-0.3.5.1/lib/spreadsheet/olewriter.rb:42:in `open'
vendor/plugins/spreadsheet-excel-0.3.5.1/lib/spreadsheet/workbook.rb:98:in `store_ole_file'
vendor/plugins/spreadsheet-excel-0.3.5.1/lib/spreadsheet/workbook.rb:94:in `store_workbook'
vendor/plugins/spreadsheet-excel-0.3.5.1/lib/spreadsheet/workbook.rb:28:in `close'
app/controllers/v_detail_record_controller.rb:151:in `into_excel'
app/controllers/v_detail_record_controller.rb:118:in `export'
script\server:3

To find out in the end that because the export file content size greater than 7M reported this error!

Search the above error in the Google, the following link:


Excuse me, this problem has no solution?

2 I in accordance with the method to handle the same amount of data of Excel, the speed is slower than that of spreadsheet-excel!
Is there no better method to deal with ruby Excel?

Started by Jeremiah at November 12, 2016 - 1:40 PM

I~

Posted by Lareina at November 26, 2016 - 1:55 PM

Help you find some resources, don't know is it useful?

This paper introduced the basic knowledge of spreadsheet, the plug-in can read and generate the excel file

If, you want to see a more complex example, please click here.
If, you want to see the excel file parsing more simple example, please click here.
If, you want to download the spreadsheet gem package, please click here.
If you want to understand the unique method, excel operating under the windows, please click here.
If, you want to consider additional plug-ins for roo to operate excel, please click here.
If a railsxls plugin, you also want to consider the rails, please click here.

Posted by Adelaide at December 08, 2016 - 2:05 PM