CREATE CLASS ExcelWriterXML_Sheet 
  
    VAR    id 
    VAR    aAddSheet                               INIT {} 
    VAR    cells                                   INIT { => } 
    VAR    colWidth                                INIT { => } 
 ... 
  
 METHOD ExcelWriterXML_Sheet:getSheetXML( handle ) 
 ... 
    xml += "   </Table>" + hb_eol() 
  
    if valtype(::aAddSheet) == 'A' .and. len(::aAddSheet)>0 
      for ir = 1 to len(::aAddSheet) 
        xml +=  ::aAddSheet[ir] + hb_eol() 
      next 
    endif 
  
    xml += "</Worksheet>" + hb_eol() 
 ... 
  
 я  использую для передачи "заморозки" шапки, nFreeze и АвтоФильтра 
  
 aadd(oSh,'  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">') 
 aadd(oSh,'   <Unsynced/>') 
 aadd(oSh,'   <FreezePanes/>') 
 aadd(oSh,'   <FrozenNoSplit/>') 
 aadd(oSh,'   <SplitHorizontal>+[номер строки]+</SplitHorizontal>') 
 aadd(oSh,'   <TopRowBottomPane>+[номер строки]+</TopRowBottomPane>') 
 aadd(oSh,'   <SplitVertical>'+[номер колонки]+'</SplitVertical>') 
 aadd(oSh,'   <LeftColumnRightPane>'+[номер колонки]+'</LeftColumnRightPane>') 
 aadd(oSh,'   <ActivePane>0</ActivePane>') 
 aadd(oSh,'   <Panes>') 
 aadd(oSh,'    <Pane>') 
 aadd(oSh,'     <Number>3</Number>') 
 aadd(oSh,'    </Pane>') 
 aadd(oSh,'    <Pane>') 
 aadd(oSh,'     <Number>1</Number>') 
 aadd(oSh,'     <ActiveCol>2</ActiveCol>') 
 aadd(oSh,'    </Pane>') 
 aadd(oSh,'    <Pane>') 
 aadd(oSh,'     <Number>2</Number>') 
 aadd(oSh,'    </Pane>') 
 aadd(oSh,'    <Pane>') 
 aadd(oSh,'     <Number>0</Number>') 
 aadd(oSh,'     <ActiveCol>0</ActiveCol>') 
 aadd(oSh,'    </Pane>') 
 aadd(oSh,'   </Panes>') 
 aadd(oSh,'   <ProtectObjects>False</ProtectObjects>') 
 aadd(oSh,'   <ProtectScenarios>False</ProtectScenarios>') 
 aadd(oSh,'  </WorksheetOptions>') 
  
 aadd(oSh,'  <AutoFilter x:Range="R+[строка]+C+[колонка]+:R+[строка]+C'+[колонка]+'" xmlns="urn:schemas-microsoft-com:office:excel">') 
 aadd(oSh,'  </AutoFilter>') 
  
  
 

  * Added the new functions for Windows GDI objects memory release. 
     It will activate the GDI objects recording and call CheckRes() 
     to generate the checkres.txt log file on the application quit. 
     Note: This feature will work after setting of debugging mode 
     via the Harbour command Set( _SET_DEBUG, .T. ) or AltD( 1 ). 
  
   * Fixed detected resource leakage of GDI objects at the release of 
     Main form with usage of the new MiniGUI Resources control system. 
  
   * TOOLBAR control: toolbuttons supports an optional ADJUST clause. 
  
   * Revised a hot mouse tracking in the ButtonEx control. 
  
   * Revised a releasing of the AniGif control. 
  
   * Synchronized Extended HMG for compatibility with Official HMG: 
     - COMBOBOXEX supports the optional clause NOTRANSPARENT; 
     - IMAGE CHECKBUTTON supports the optional clause NOTRANSPARENT; 
     - TAB control supports the optional clause NOTRANSPARENT; 
     - TREE control supports the optional clause NOTRANSPARENT. 
  
   * Added the optional color's constants to the header files 
     i_color.ch and i_wincolor.ch. 
  
   * Adaptation FiveWin Class TSBrowse 9.0 in HMG: 
     - added the new variables :lFastDrawCell, :aFastDrawCell and 
       :lFastDrawClear, method :FastDrawClear() for high-speed 
       HASH-based data refreshing in the TSBrowse class; 
       Note: you should set :lFastDrawCell to .T. for switch ON 
       the above mode. 
       Thanks a lot for this GREAT contribution to SergKis and Haz! 
  
   * Updated Sqlite3 library. 
  
   * Added the new interesting samples and updated some examples. 
 

  * Fixed: Browse control without PICTURE option had a wrong formatting for 
            the fields with negative numbers (introduced in the build 20.05). 
            Bug was reported by Pablo Jalabert. 
            Contributed by Grigory Filatov <gfilatov@inbox.ru> 
            (see demo in folder \samples\Basic\Browse_4) 
   * Fixed: Correction in the Imagelist ADD IMAGE commands. 
            Syntax: 
              ADD IMAGE <image> [ MASK <mask> ] TO <control> OF <parent> 
              ADD MASKEDIMAGE <image> [ COLOR <aColor> ] TO <control> ; 
                OF <parent> 
            Contributed by Grigory Filatov <gfilatov@inbox.ru> 
            (see demo in folder \samples\Basic\TOOLBAR_3) 
   * Enhanced: TOOLBAR control: tool buttons respect the BALLOON style of 
            tooltips and the command SET TOOLTIP [ ACTIVATE ] <ON | OFF>. 
            Requested by Ivanil Marcelino <ivanil/at/linkbr.com.br>. 
            Contributed by Grigory Filatov <gfilatov@inbox.ru> 
            (see demo in folder \samples\Basic\TOOLBAR_2) 
   * Enhanced: ANIGIF control: added support of animated GIF from resources. 
            Requested by Ivanil Marcelino <ivanil/at/linkbr.com.br>. 
            Contributed by Grigory Filatov <gfilatov@inbox.ru> 
            (see demo in folder \samples\Advanced\AniGIF) 
   * Enhanced: BtnTextBox and GetBox controls support Controls Context menu. 
            Requested by Ivanil Marcelino <ivanil/at/linkbr.com.br>. 
            Contributed by Grigory Filatov <gfilatov@inbox.ru> 
   * Modified: Adding the new selected values to the multiple selection Grid 
            was significantly accelerated (noticeable for grids with more than 
            one hundred thousand items). 
            Suggested by HMG user Edward. 
            Contributed by Grigory Filatov <gfilatov@inbox.ru> 
   * New: 'Month Calendar control with the bold days and backcolor' sample. 
            Based upon a contribution of Kevin Carmody <i@kevincarmody.com>. 
            Adapted for Minigui Extended by Grigory Filatov <gfilatov@inbox.ru> 
            (see demo3.prg in folder \samples\Basic\MONTHCAL) 
   * New: 'MiniGUI ToolBar ImageList Demo' sample. 
            Contributed by Grigory Filatov <gfilatov@inbox.ru> 
            (see in folder \samples\Basic\TOOLBAR_3)