Unreadable content

[ghost]

Hi,

I am getting the Excel could not open <filename>.xlsx because some content is unreadable error that requires subsequent repair. Browsing your git seems to suggest there might be corrupted/incompatible content in our data, but I get the error even when using your exact doc example:

      def to_xls
        Axlsx::Package.new do |p|
          p.workbook.add_worksheet(:name => "Pie Chart") do |sheet|
            sheet.add_row ["Simple Pie Chart"]
            %w(first second third).each { |label| sheet.add_row [label, rand(24)+1] }
            sheet.add_chart(Axlsx::Pie3DChart, :start_at => [0,5], :end_at => [10, 20], :title => "example 3: Pie Chart") do |chart|
              chart.add_series :data => sheet["B2:B4"], :labels => sheet["A2:A4"],  :colors => ['FF0000', '00FF00', '0000FF']
            end
          end
          p.serialize('simple.xlsx')
        end
      end

It might be worth mentioning that simple.xlsx then got attached to an email and thats where it reports the error.

Thanks!

[loybert]

Hi @pbeckinger: this might be an issue with #498

We had issues with Excel could not open file ..., when we rendered multiple sheets simultaneously. Forcing to render the sheets by a single worker one by one, solved those corrupt files, but loosing lots of performance due discarding parallel data processing.

Maybe you can enforce this single-worker-mode too, to determine the source of your error.