def close #:nodoc:
    ################################################
    # Prepend in reverse order!!
    #

    # Prepend the sheet dimensions
    store_dimensions

    # Prepend the autofilter filters.
    store_autofilters

    # Prepend the sheet autofilter info.
    store_autofilterinfo

    # Prepend the sheet filtermode record.
    store_filtermode

    # Prepend the COLINFO records if they exist
    @colinfo.reverse.each do |colinfo|
      store_colinfo(colinfo)
    end

    # Prepend the DEFCOLWIDTH record
    store_defcol

    # Prepend the sheet password
    store_password

    # Prepend the sheet protection
    store_protect
    store_obj_protect

    # Prepend the page setup
    store_setup

    # Prepend the bottom margin
    store_margin_bottom

    # Prepend the top margin
    store_margin_top

    # Prepend the right margin
    store_margin_right

    # Prepend the left margin
    store_margin_left

    # Prepend the page vertical centering
    store_vcenter

    # Prepend the page horizontal centering
    store_hcenter

    # Prepend the page footer
    store_footer

    # Prepend the page header
    store_header

    # Prepend the vertical page breaks
    store_vbreak

    # Prepend the horizontal page breaks
    store_hbreak

    # Prepend WSBOOL
    store_wsbool

    # Prepend the default row height.
    store_defrow

    # Prepend GUTS
    store_guts

    # Prepend GRIDSET
    store_gridset

    # Prepend PRINTGRIDLINES
    store_print_gridlines

    # Prepend PRINTHEADERS
    store_print_headers

    #
    # End of prepend. Read upwards from here.
    ################################################
    # Append
    store_table
    store_images
    store_charts
    store_filters
    store_comments
    store_window2
    store_page_view
    store_zoom
    store_panes(*@panes) if @panes && !@panes.empty?
    store_selection(*@selection)
    store_validation_count
    store_validations
    store_tab_color
    store_eof

    # Prepend the BOF and INDEX records
    store_index
    store_bof(0x0010)
  end
def close #:nodoc:
    ################################################
    # Prepend in reverse order!!
    #

    # Prepend the sheet dimensions
    store_dimensions

    # Prepend the autofilter filters.
    store_autofilters

    # Prepend the sheet autofilter info.
    store_autofilterinfo

    # Prepend the sheet filtermode record.
    store_filtermode

    # Prepend the COLINFO records if they exist
    @colinfo.reverse.each do |colinfo|
      store_colinfo(colinfo)
    end

    # Prepend the DEFCOLWIDTH record
    store_defcol

    # Prepend the sheet password
    store_password

    # Prepend the sheet protection
    store_protect
    store_obj_protect

    # Prepend the page setup
    store_setup

    # Prepend the bottom margin
    store_margin_bottom

    # Prepend the top margin
    store_margin_top

    # Prepend the right margin
    store_margin_right

    # Prepend the left margin
    store_margin_left

    # Prepend the page vertical centering
    store_vcenter

    # Prepend the page horizontal centering
    store_hcenter

    # Prepend the page footer
    store_footer

    # Prepend the page header
    store_header

    # Prepend the vertical page breaks
    store_vbreak

    # Prepend the horizontal page breaks
    store_hbreak

    # Prepend WSBOOL
    store_wsbool

    # Prepend the default row height.
    store_defrow

    # Prepend GUTS
    store_guts

    # Prepend GRIDSET
    store_gridset

    # Prepend PRINTGRIDLINES
    store_print_gridlines

    # Prepend PRINTHEADERS
    store_print_headers

    #
    # End of prepend. Read upwards from here.
    ################################################
    # Append
    store_table
    store_images
    store_charts
    store_filters
    store_comments
    store_window2
    store_page_view
    store_zoom
    store_panes(*@panes) if @panes && !@panes.empty?
    store_selection(*@selection)
    store_validation_count
    store_validations
    store_tab_color
    store_eof

    # Prepend the BOF and INDEX records
    store_index
    store_bof(0x0010)
  end
Constructor. Creates a new Worksheet object from a BIFFwriter object


 Add data to the beginning of the workbook (note the reverse order)
 and to the end of the workbook.