class ExcelToCsv::CrossPlatformExcel

Public Instance Methods

close_workbook() click to toggle source
# File lib/exceltocsv/cross_platform_excel.rb, line 23
def close_workbook
  # NOP
end
open_workbook(filepath) click to toggle source
# File lib/exceltocsv/cross_platform_excel.rb, line 14
def open_workbook(filepath)
  #   Open an Excel file
  @wb = Spreadsheet.open filepath
end
worksheet_data(worksheet_name) click to toggle source
# File lib/exceltocsv/cross_platform_excel.rb, line 27
def worksheet_data(worksheet_name)
  sheet = @wb.worksheet worksheet_name
  sheet.rows
end
worksheet_names() click to toggle source
# File lib/exceltocsv/cross_platform_excel.rb, line 19
def worksheet_names
  worksheets = @wb.worksheets.collect { |w| w.name }
end