Quintiq file version 2.0
#parent: lstSnapshots
Response OnClick (structured[shadow[KpiSnapshotData]] selection) id:Response_lstSnapshots_MenuExportAsEXCEL_OnClick
{
  #keys: '[146450.0.1761583342]'
  Body:
  [*
    //Export to EXCEL file
    nvt := Kpi_GlobalState.ConvertShadowSnapshotDataToNvt( selection );
    xls := KpiExcelConverter::CreateExcelFromNvtContainingMultiple( nvt, KpiTracker );
    
    filename := this.Application().GetSaveFileName( "KpiSnapshot", "xlsx", "Excel workbook (*.xlsx)" );
    if( filename <> '' )
    {
      table := TableHandle::ImportXML( xls );
      
      savefile := Application.GetClientFile( filename );
      XLS::SaveTable( table, savefile.LocalFileName() );
      
      Application.TransferToClient( savefile );
      Application.RemoveLocalCopy( savefile );
    }
  *]
  CanBindMultiple: false
  DefinitionID => /lstSnapshots/Responsedef_lstSnapshots_Menu_OnClick
  Initiator: 'MenuExportAsEXCEL'
}
