How Export to Excel works on server where excel is not installed.

[amars]

Hi all,

I wish to understand how the Export To Excel Function creates the Excel File on the Server (Where Microsoft Excel is not installed).

I wish to send some reports to Excel but some of our policies restricts us from installing Microsoft Excel on the server. Wish to understand from some experts how qlikview works to send Excel data to Excel File and create the Excel Files in Temp directory even though excel is not installed.

My issue is I do not have Excel installed and we wish to export some data to Excel. Now I don't know how should I do it without Excel, Publisher etc.One approach I thought is to send the Data to CSV but I need to export two charts and using CSV it will not be possible.

Please Suggest.

Thanks in advance

Amar

[kaushiknsolanki]

Dear Amar,

     Do you mean that you are trying to export from QlikView Desktop installed on server.

     Then QlikView will not create any file (Excel) even if you click on export to excel. Nothing will work, because no excel is installed on server.

     However if you are trying to export from a browser of a client machine where you have excel installed, then the export to excel will work even though the excel is not installed on the Server from where you are hosting qlikview files.

Regards,

Kaushik Solanki

[amars]

Hi Kaushik,

What I mean here is on Qlikview Server, I open a Dashboard using Qlikview Desktop and click on Export to Excel. Now inside the Temp folder the excel file with the object export is created. I wish to know what method is used for that?

I wish to export two objects inside one Excel Sheet without using CreateObject("Excel.Application")  line inside my Macro (since Excel is not installed on the server).

I know that while using it from IE Plugin, it used the Excel installed on the User machine. Please suggest if any alternative for this.

One alternative I found is to create two different excels using obj.export FileName.xls but I don't wish to do that.

Thanks....

[sushil353]

hi,

if you are trying to export excel from Access point then it is dependent on the client machine that the excel is installed on the local machine or not.

other wise on the server if it not installed then it should not give the output.

HTH

Sushil

[danilodalosse]

Hi Michael!

Did you have any solution for this?

[amars]

Hi Danilo,

I have used some macro still to export. I do not have excel installed on the server so this is the only option possible.

ActiveDocument.ClearAll

  set BookingDt = ActiveDocument.Fields("TransactionDate") 

  BookingDt.Select ActiveDocument.Evaluate("=Today()")    

  set obj = ActiveDocument.GetSheetObject("CH69")

  obj.ExportBiff "D:\Qlikview_Prod\Private Folder\LSTS\QV_Output\Transaction-" & year(date()) & right("0"&month(date()),2) & right("0"&day(date()),2) &  ".xls"

  set obj = ActiveDocument.GetSheetObject("TB01")

  obj.ExportBiff "D:\Qlikview_Prod\Private Folder\LSTS\QV_Output\TransactionData-" & year(date()) & right("0"&month(date()),2) & right("0"&day(date()),2) &  ".xls"

  ActiveDocument.ClearAll

End Sub

See if this helps. Thanks Amar

[kamal_sanguri]

Hi,

I would suggest you to create a .csv file (Which can be opened in Excel or Notepad). Using this method you would be able to write/run/test a macro to export .CSV which you can open in server to check and this method still work in machine where Excel is installed.

[#8]

Micheal,

As an experienced developer there are a number of libraries out there that can export to Excel format without Excel actually being installed on the server. 

If Qliksense can export to Excel without it being installed once, it will never be a problem, as it will use this library to export Excel data.

[danilodalosse]

Thanks a lot Michael!

I'll try this too.