var search_data = {"index":{"searchIndex":["excelcolor","excelconnection","javaexcelcom","minitest","time","workbook","worksheet","active_workbook()","addworksheet()","add_worksheet()","border_color()","border_color=()","close()","connect()","content()","content=()","delete()","display_alerts=()","fill_color()","fill_color=()","font_color()","font_color=()","getactiveworkbook()","getbordercolor()","getcontent()","getfillcolor()","getfontcolor()","getname()","getname()","getversion()","getworksheet()","initialize_com()","name()","name()","name=()","new()","new()","new()","openworkbook()","open_workbook()","quit()","save()","saveas()","save_as()","setbordercolor()","setcontent()","setdisplayalerts()","setfillcolor()","setfontcolor()","setname()","setvisible()","set_border_color()","set_content()","set_fill_color()","set_font_color()","uninitialize_com()","version()","visible=()","workbook()","worksheet()","license","jruby_excelcom.gemspec"],"longSearchIndex":["excelcolor","excelconnection","javaexcelcom","minitest","time","workbook","worksheet","excelconnection#active_workbook()","workbook#addworksheet()","workbook#add_worksheet()","worksheet#border_color()","worksheet#border_color=()","workbook#close()","excelconnection::connect()","worksheet#content()","worksheet#content=()","worksheet#delete()","excelconnection#display_alerts=()","worksheet#fill_color()","worksheet#fill_color=()","worksheet#font_color()","worksheet#font_color=()","excelconnection#getactiveworkbook()","worksheet#getbordercolor()","worksheet#getcontent()","worksheet#getfillcolor()","worksheet#getfontcolor()","workbook#getname()","worksheet#getname()","excelconnection#getversion()","workbook#getworksheet()","excelconnection::initialize_com()","workbook#name()","worksheet#name()","worksheet#name=()","excelconnection::new()","workbook::new()","worksheet::new()","excelconnection#openworkbook()","excelconnection#open_workbook()","excelconnection#quit()","workbook#save()","workbook#saveas()","workbook#save_as()","worksheet#setbordercolor()","worksheet#setcontent()","excelconnection#setdisplayalerts()","worksheet#setfillcolor()","worksheet#setfontcolor()","worksheet#setname()","excelconnection#setvisible()","worksheet#set_border_color()","worksheet#set_content()","worksheet#set_fill_color()","worksheet#set_font_color()","excelconnection::uninitialize_com()","excelconnection#version()","excelconnection#visible=()","excelconnection#workbook()","workbook#worksheet()","",""],"info":[["ExcelColor","","ExcelColor.html","",""],["ExcelConnection","","ExcelConnection.html","",""],["JavaExcelcom","","JavaExcelcom.html","",""],["MiniTest","","MiniTest.html","",""],["Time","","Time.html","",""],["Workbook","","Workbook.html","",""],["Worksheet","","Worksheet.html","",""],["active_workbook","ExcelConnection","ExcelConnection.html#method-i-active_workbook","()","

gets the active workbook\n"],["addWorksheet","Workbook","Workbook.html#method-i-addWorksheet","(name)",""],["add_worksheet","Workbook","Workbook.html#method-i-add_worksheet","(name)","

adds and returns a worksheet to this workbook\n

name — name of new worksheet\n\n"],["border_color","Worksheet","Worksheet.html#method-i-border_color","(range)","

gets the border color of cells in range. Throws a\nNullpointerException if range contains multiple colors …\n"],["border_color=","Worksheet","Worksheet.html#method-i-border_color-3D","(hash)","

sets border color of cells in range\n

hash — must contain :range and :color\n\n"],["close","Workbook","Workbook.html#method-i-close","(save = false)","

closes this workbook\n

save — whether changes should be saved or not, default is false\n\n"],["connect","ExcelConnection","ExcelConnection.html#method-c-connect","(use_active_instance = false)","

see new\n

optional block possible, where ExcelConnection#quit gets\ncalled on blocks end e.g. ExcelConnection::connect{|con| …\n"],["content","Worksheet","Worksheet.html#method-i-content","(range = 'UsedRange')","

returns the content in range as a matrix, a vector or a single value,\ndepending on range's dimensions …\n"],["content=","Worksheet","Worksheet.html#method-i-content-3D","(hash)","

sets content in a range\n

hash — must contain :range and :content, e.g.\n{:range => 'A1:A3', :content …\n\n"],["delete","Worksheet","Worksheet.html#method-i-delete","()","

deletes this worksheet\n"],["display_alerts=","ExcelConnection","ExcelConnection.html#method-i-display_alerts-3D","(da)","

whether dialog boxes should show up or not (e.g. when saving and\noverwriting a file)\n"],["fill_color","Worksheet","Worksheet.html#method-i-fill_color","(range)","

gets the fill color of cells in range. Throws a\nNullpointerException if range contains multiple colors …\n"],["fill_color=","Worksheet","Worksheet.html#method-i-fill_color-3D","(hash)","

fills cells in range with color\n

hash — must contain :range and :color\n\n"],["font_color","Worksheet","Worksheet.html#method-i-font_color","(range)","

gets the font color of cells in range. Throws a\nNullpointerException if range contains multiple colors …\n"],["font_color=","Worksheet","Worksheet.html#method-i-font_color-3D","(hash)","

sets font color of cells in range\n

hash — must contain :range and :color\n\n"],["getActiveWorkbook","ExcelConnection","ExcelConnection.html#method-i-getActiveWorkbook","()",""],["getBorderColor","Worksheet","Worksheet.html#method-i-getBorderColor","(range)",""],["getContent","Worksheet","Worksheet.html#method-i-getContent","(range = 'UsedRange')",""],["getFillColor","Worksheet","Worksheet.html#method-i-getFillColor","(range)",""],["getFontColor","Worksheet","Worksheet.html#method-i-getFontColor","(range)",""],["getName","Workbook","Workbook.html#method-i-getName","()",""],["getName","Worksheet","Worksheet.html#method-i-getName","()",""],["getVersion","ExcelConnection","ExcelConnection.html#method-i-getVersion","()",""],["getWorksheet","Workbook","Workbook.html#method-i-getWorksheet","(name)",""],["initialize_com","ExcelConnection","ExcelConnection.html#method-c-initialize_com","()","

initializes com manually, not recommended! happens automatically when an\ninstance is created\n"],["name","Workbook","Workbook.html#method-i-name","()","

gets the name of this workbook\n"],["name","Worksheet","Worksheet.html#method-i-name","()","

gets the name of this worksheet\n"],["name=","Worksheet","Worksheet.html#method-i-name-3D","(name)","

sets the name of this worksheet\n"],["new","ExcelConnection","ExcelConnection.html#method-c-new","(use_active_instance = false)","

initializes com and connects to an excel instance\n

use_active_instance — whether an existing excel instance …\n\n"],["new","Workbook","Workbook.html#method-c-new","(java_wb)",""],["new","Worksheet","Worksheet.html#method-c-new","(java_ws)",""],["openWorkbook","ExcelConnection","ExcelConnection.html#method-i-openWorkbook","(file)",""],["open_workbook","ExcelConnection","ExcelConnection.html#method-i-open_workbook","(file)",""],["quit","ExcelConnection","ExcelConnection.html#method-i-quit","()","

quits the excel instance and uninitializes com\n"],["save","Workbook","Workbook.html#method-i-save","()","

saves this workbook\n"],["saveAs","Workbook","Workbook.html#method-i-saveAs","(path)",""],["save_as","Workbook","Workbook.html#method-i-save_as","(path)","

saves this workbook to a new location. Every further operations on this\nworkbook will happen to the newly …\n"],["setBorderColor","Worksheet","Worksheet.html#method-i-setBorderColor","(range, color)",""],["setContent","Worksheet","Worksheet.html#method-i-setContent","(range, content)",""],["setDisplayAlerts","ExcelConnection","ExcelConnection.html#method-i-setDisplayAlerts","(da)",""],["setFillColor","Worksheet","Worksheet.html#method-i-setFillColor","(range, color)",""],["setFontColor","Worksheet","Worksheet.html#method-i-setFontColor","(range, color)",""],["setName","Worksheet","Worksheet.html#method-i-setName","(name)",""],["setVisible","ExcelConnection","ExcelConnection.html#method-i-setVisible","(v)",""],["set_border_color","Worksheet","Worksheet.html#method-i-set_border_color","(range, color)","

sets border color of cells in range\n

range — range to be colorized\n

color — color to be used, must be an ExcelColor …\n"],["set_content","Worksheet","Worksheet.html#method-i-set_content","(range, content)","

sets content in a range\n

range — range in worksheet, e.g. 'A1:B3'\n

content — may be a matrix, a vector …\n"],["set_fill_color","Worksheet","Worksheet.html#method-i-set_fill_color","(range, color)","

fills cells in range with color\n

range — range to be colorized\n

color — color to be used, must be an ExcelColor …\n"],["set_font_color","Worksheet","Worksheet.html#method-i-set_font_color","(range, color)","

sets font color of cells in range\n

range — range to be colorized\n

color — color to be used, must be an ExcelColor …\n"],["uninitialize_com","ExcelConnection","ExcelConnection.html#method-c-uninitialize_com","()","

uninitializes com manually, not recommended! should happen automatically\nwhen ExcelConnection#quit is …\n"],["version","ExcelConnection","ExcelConnection.html#method-i-version","()","

gets excel version\n"],["visible=","ExcelConnection","ExcelConnection.html#method-i-visible-3D","(v)","

whether the excel instance should be visible or not\n"],["workbook","ExcelConnection","ExcelConnection.html#method-i-workbook","(file)","

opens a workbook. Optional block possible where workbook gets closed on\nblocks end, e.g. con.workbook{|wb| …\n"],["worksheet","Workbook","Workbook.html#method-i-worksheet","(name)","

gets a worksheet\n

name — name of worksheet to get\n\n"],["LICENSE","","LICENSE.html","","\n

         Apache License\n   Version 2.0, January 2004\nhttp://www.apache.org/licenses/
\n

TERMS AND CONDITIONS …\n"],["jruby_excelcom.gemspec","","jruby_excelcom_gemspec.html","","

Gem::Specification.new do |s|\n\n

s.name          = 'jruby_excelcom'\ns.version       = '0.0.1'\ns.date     ...
\n"]]}}