def fill_in_empty_cells(cells, row_number, last_col, use_simple_rows_format)
      new_cells = Hash.new

      unless cells.empty?
        last_col = last_col.gsub(row_number, '')

        ("A"..last_col).to_a.each do |column|
          id = use_simple_rows_format ? "#{column}" : "#{column}#{row_number}"
          new_cells[id] = cells[id]
        end
      end

      new_cells
    end
def fill_in_empty_cells(cells, row_number, last_col, use_simple_rows_format)
      new_cells = Hash.new

      unless cells.empty?
        last_col = last_col.gsub(row_number, '')

        ("A"..last_col).to_a.each do |column|
          id = use_simple_rows_format ? "#{column}" : "#{column}#{row_number}"
          new_cells[id] = cells[id]
        end
      end

      new_cells
    end
The unzipped XML file does not contain any node for empty cells.
 Empty cells are being padded in using this function