module PIM::Services::ExcelService

# File services.rb, line 2386
def __excel_service
  __service(:excelService)
end

# File services.rb, line 2372
def create_sheet workbook, sheetname
  __excel_service.create_sheet(workbook, sheetname)
end

# File services.rb, line 2275
def create_xls_workbook
  __excel_service.create_xls_workbook
end

# File services.rb, line 2241
def create_xlsx_stream_writing_workbook
  __excel_service.create_xlsx_stream_writing_workbook
end

# File services.rb, line 2237
def create_xlsx_workbook
  __excel_service.create_xlsx_workbook
end

# File services.rb, line 2297
def get_cell_value workbook, cell_name
  __excel_service.get_cell_value(workbook, cell_name)
end

# File services.rb, line 2322
def get_cell_value_at workbook, sheetnum, rownum, colnum
  __excel_service.get_cell_value_at(workbook, sheetnum, rownum, colnum)
end

# File services.rb, line 2349
def get_next_row row_iterator
  row_iterator.each do |row|
    return row if not row.nil?
  end
  nil
end

# File services.rb, line 2342
def get_row_cell_value_at row, colnum
  __excel_service.get_cell_value_at(row, colnum)
end

# File services.rb, line 2338
def get_row_cell_values row
  __excel_service.get_row_cell_values(row)
end

# File services.rb, line 2330
def get_row_cell_values_at workbook, sheetnum, rownum
  __excel_service.get_row_cell_values_at(workbook, sheetnum, rownum)
end

# File services.rb, line 2326
def get_sheet_cell_value_at sheet, rownum, colnum
  __excel_service.get_cell_value_at(sheet, rownum, colnum)
end

# File services.rb, line 2334
def get_sheet_row_cell_values_at sheet, rownum
  __excel_service.get_row_cell_values_at(sheet, rownum)
end

# File services.rb, line 2361
def iterate_rows row_iterator, start_row_num = nil, end_row_num = nil, &block
  row_iterator.each do |row|
    next if row.nil?
    row_num = row.get_row_num
    next if start_row_num and row_num < start_row_num
    break if end_row_num and row_num > end_row_num
    block.call(row)
  end
end

# File services.rb, line 2279
def open_xls_workbook path_or_stream = nil, gathering_key = nil
  if path_or_stream.nil? and gathering_key.nil?
    create_xls_workbook
  elsif path_or_stream.is_a?(String) and not gathering_key.nil?
    __excel_service.open_xls_workbook(path_or_stream, gathering_key)
  else
    __excel_service.open_xls_workbook(path_or_stream)
  end
end

# File services.rb, line 2255
def open_xlsx_stream_reading_workbook path_or_stream, gathering_key = nil
  if path_or_stream.nil?
    raise "Path or stream must be specified"
  elsif path_or_stream.is_a?(String) and not gathering_key.nil?
    __excel_service.open_xlsx_stream_reading_workbook(path_or_stream, gathering_key)
  else
    __excel_service.open_xlsx_stream_reading_workbook(path_or_stream)
  end
end

# File services.rb, line 2265
def open_xlsx_stream_writing_workbook path_or_stream = nil, gathering_key = nil
  if path_or_stream.nil? and gathering_key.nil?
    create_xlsx_stream_writing_workbook
  elsif path_or_stream.is_a?(String) and not gathering_key.nil?
    __excel_service.open_xlsx_stream_writing_workbook(path_or_stream, gathering_key)
  else
    __excel_service.open_xlsx_stream_writing_workbook(path_or_stream)
  end
end

# File services.rb, line 2245
def open_xlsx_workbook path_or_stream = nil, gathering_key = nil
  if path_or_stream.nil? and gathering_key.nil?
    create_xlsx_workbook
  elsif path_or_stream.is_a?(String) and not gathering_key.nil?
    __excel_service.open_xlsx_workbook(path_or_stream, gathering_key)
  else
    __excel_service.open_xlsx_workbook(path_or_stream)
  end
end

# File services.rb, line 2382
def remove_sheet workbook, sheetname
  __excel_service.remove_sheet(workbook, sheetname)
end

# File services.rb, line 2377
def remove_sheet_at workbook, index
  __excel_service.remove_sheet_at(workbook, index)
end

# File services.rb, line 2289
def save_workbook workbook, path_or_stream = nil, gathering_key = nil
  if path_or_stream.is_a?(String) and not gathering_key.nil?
    __excel_service.save_workbook(workbook, path_or_stream, gathering_key)
  else
    __excel_service.save_workbook(workbook, path_or_stream)
  end
end

# File services.rb, line 2307
def set_cell_value workbook, cell_name, value
  __excel_service.set_cell_value(workbook, cell_name, value)
end

# File services.rb, line 2312
def set_cell_value_at workbook, sheetnum_or_sheetname, cell_name, value
  __excel_service.set_cell_value_at(workbook, sheetnum_or_sheetname, cell_name, value)
end