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