topic Excel Name when exported in QlikView

Excel Name when exported

mohamedafzal — Mon, 19 Dec 2016 13:57:40 GMT

I have a chart with export option. Export can also be done when Right click and select Export or Send to Excel.

When exported, the excel name by default has a junk name. (Say Egs- 76210519debc4f61b6b7426c145d453c.xls)

Can we add predefined name or Chart Name to the Excel when exported. (Egs- Sales Value by Country)

Re: Excel Name when exported

Chip_Matejowsky — Mon, 19 Dec 2016 15:16:06 GMT

Hello Mohamed,

From my experience, this is working as designed. To rename the XLS file, you have two options:

1. In the right-click menu, click Export. Select a file type .XLS and you can name it whatever you wish.

2. You can create a button with underlying macro to Export and use a file type of Excel (BIFF format). See the attached sample .QVW.

Hope this helps

- Chip

Re: Excel Name when exported

sacosta5 — Mon, 19 Dec 2016 15:25:12 GMT

Hello...

Without macro I don't think this is possible.

See this posts:

Table Name while exporting table to excel via access point

Export Table Excel

Re: Excel Name when exported

el_aprendiz111 — Mon, 19 Dec 2016 17:26:03 GMT

Hi,

Sub DeleteFiles
Set filesys = CreateObject("Scripting.FileSystemObject")
If filesys.FileExists("C:\tmp.xlsx") then
filesys.DeleteFile "C:\tmp.xlsx"
Msgbox("Files Deleted")
Else
Msgbox("No Files to delete")
End If
End Sub

sub Export_Excel
set oXL=CreateObject("Excel.Application")

oXL.Workbooks.Add
oXL.visible=True
aSheetObj=Array("CH08","CH09")
for i=0 to UBound(aSheetObj)
oXL.Sheets.Add
Set oSH = oXL.ActiveSheet
oSH.Range("A1").Select
Set obj = ActiveDocument.GetSheetObject(aSheetObj(i))
obj.CopyTableToClipboard True
oSH.Paste
sCaption=obj.GetCaption.Name.v
set obj=Nothing

oSH.Name=left(sCaption,30)
oSH.Rows("1:1").Select
oXL.Selection.Font.Bold = True
oSH.Cells.Select
oXL.Selection.Columns.AutoFit
oSH.Range("A1").Select

next
call DeleteFiles
oSH.SaveAs "C:\tmp.xlsx",51

set oSH=Nothing
set oXL=Nothing
end sub

Re: Excel Name when exported

mohamedafzal — Tue, 20 Dec 2016 11:47:12 GMT

Helo Chip

Thanks for your response.

Option 1 is based on Browser settings. If the Downloads is made to save in the location file, it will prompt the user before saving the excel.

In most cases for the user, the default browser settings, the download happen automatically and it get saved in the Downloads folder. In such cases, we can't give the name of the file.

Option 2 we tried. Macros is not working for AJAX. Hence anything on Macros is not working on server.

Re: Excel Name when exported

saimahasan — Tue, 20 Dec 2016 12:58:01 GMT

Hi Afzal,

To execute macro on AJAX u will need IE Plugin. Install IE Plugin and then try running macros on AJAX. It should work

Re: Excel Name when exported

mohamedafzal — Wed, 21 Dec 2016 13:27:10 GMT

Thanks Saima.

The report should be viewed in all browsers. (IE, Firefox, Crome, Safari)

Can different plugins be installed based on browsers?