Dashboard exportation

[#1]

Hi All,

Does anyone know if there is an option to export all the object in a specific sheet to excel together?

Thanks!

[amit_saini]

Michal,

Go to Settings-> User Preferences-> Export

Thanks,

AS

[#3]

I'm taking about ajax client..

[ashfaq_haseeb]

Hi,

I don't think so.

Will snapshot of a sheet fine for you?

Regards

ASHFAQ

[#5]

Hi Amit! thanks..

please find attached.. in which QV version you are using? we are using 11.20 SR7..

[amit_saini]

Michal,

Macro can help here:

sub ExportWithSelections
      Set XLApp = CreateObject("Excel.Application")
      XLApp.Visible = True 
      Set XLWorkbook = XLApp.Workbooks.Add
      Set XLSheet = XLWorkbook.sheets("Sheet1")
      XLSheet.Range("A3").Select

rem ** copy full chart details to clipboard **
      ActiveDocument.GetSheetObject("CH252").CopyTableToClipboard false
      XLSheet.Paste ' -4163    'values

      XLSheet.Range("J2").Select

rem ** put current selection in J2 **
      ActiveDocument.GetSheetObject("CS12").CopyTableToClipboard true
      XLSheet.Paste ' -4163    'values
      XLApp.Selection.WrapText = False

      set XLSheet = nothing
      set XLWorkbook = nothing
      set XLApp = nothing

end sub

Note: You need to change the "CH252" to the object ID for the chart you want to export

Thanks,

AS

[ashfaq_haseeb]

Hi,

Macro will not work in AJAX.

Regards

ASHFAQ

[amit_saini]

Right Sir

[#9]

what do you mean by snapshot? is there an option to crate a button that does that?

[amit_saini]

Michal,

I'm using this in 11.20 SR2

Thanks,
AS