Module: MP4::XLSX::Builder

Defined in:
lib/mp4/xlsx/builder.rb

Class Method Summary collapse

Class Method Details

.add_track_worksheet(workbook, track_id, mp4) ⇒ Object 



19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
 
# File 'lib/mp4/xlsx/builder.rb', line 19

def add_track_worksheet(workbook, track_id, mp4)
  track = mp4.cache.track(track_id)
  track_timescale = track.fetch('timescale')

  workbook.add_worksheet name: "trak_#{track_id}" do |sheet|
    sheet.add_row(['Chunk ID', 'Chunk Offset', 'Sample Number', 'Sample Size', 'Sample Offset', 'Sample Delta', 'Sample C Delta', 'delta sum', 'delta_sum_millsec', 'timestamp', 'Keyframe'])

    mp4.cache.each_sample(track_id) do |row|
      sheet.add_row([
                      row['chunk_index'],
                      row['chunk_offset'],
                      row['sample_index'],
                      row['size'],
                      row['offset'],
                      row['delta'],
                      row['c_delta'],
                      row['delta_sum'],
                      row['delta_sum_millisec'],
                      Time.at(row['delta_sum'].to_f / track_timescale).utc.strftime('%H:%M:%S,%L'),
                      row['keyframe'],
                    ])
    end
  end
end

.call(mp4:, output_path:) ⇒ Object 



5
6
7
8
9
10
11
12
13
14
15
16
17
 
# File 'lib/mp4/xlsx/builder.rb', line 5

def call(mp4:, output_path:)
  require 'axlsx'

  package = Axlsx::Package.new

  package.workbook do |workbook|
    mp4.cache.each_track do |track_id|
      add_track_worksheet(workbook, track_id, mp4)
    end
  end

  package.serialize output_path
end