HI. I have tried this but getting this error even after giving all rights to directory

set sc = ##class(Converter.LibreOffice).convert("C:\Temp\a.csv", "C:\TempC:\InterSystems\Ensemble2018\mgr\Temp\b.xlsx", ".xlxs")

ERROR #5001: Error moving 'C:\InterSystems\Ensemble2018\mgr\Temp\145158\a..xlxs1C:\TempC:\InterSystems\Ensemble2018\mgr\Temp\b.xlsx' with code: -2

JAVA_HOME was not set. It was directly set into PATH

Now it's running. 

Starting ZRExcelServer...

Executing: C:\InterSystems\Ensemble2018\lib\ExcelExporter\runserver.bat -port 5005 -numthreads 5 -loglevel 3 -logfile C:\InterSystems\Ensemble2018\mgr\Temp\ -maxlogfilesize 32000 -logrotationcount 100 -numpingthreads 5 -pingport 5006

Returned from execution:
CACHEPATH=C:\InterSystems\Ensemble2018\lib\ExcelExporter\..\..
LOCALCLASSPATH=;C:\InterSystems\Ensemble2018\lib\ExcelExporter\..\..\lib\ExcelExporter\excelexporter.jar
jun. 04, 2019 8:30:14 A. M. com.intersys.excel.ExcelServer go
INFO: Listening on port 5005
jun. 04, 2019 8:30:14 A. M. com.intersys.excel.PingServer init
INFO: Ping Server Listening on port 5006

The Excel Server has been successfully started

However the command still shows same error. How to route it to use the above tcp ports?

J‰"Cannot contact server on port 0.  

I am getting this error

0 ´‰AError rendering: java probably not in path, Use $LOG=1 to checkdRESTARTV:e^zcomputeDirectStatus+2^%SYS.ZENReportExcelExporter.1^14e^zCommonExport+45^%SYS.ZENReportExcelExporter.1^12e^zgenerateXLSXfromXML+11^Utils.XLSX.1^11e^zgenerateFileFromSQL+6^Utils.XLSX.1^1^^Utils.XLSX.1^01E^zgenerateXMLFromSQL+12^Utils.XLSX.1^11e^zgenerateFileFromSQL+4^Utils.XLSX.1^1e^^^0

Hey Vladimir,

Apology for a late reply, was tied up in something else.

Pls pardon me if I am wrong , from what I can tell this code and all other codes are filtering the table by state which is like saying Select * from Patient where State = 'CA' . Correct?

My problem is quiet the opposite. 
I have picked up this snippet from your own code

<column colName="City" colExpression="Home_City" width="25%" filterType="text"/>
<column colName="State" colExpression="Home_State" width="10%" filterType="query"
filterQuery="SELECT DISTINCT Home_State FROM ZENDemo_Data.Patient ORDER BY Home_State"
 filterOp="="/>

City needs to be "filterQuery" and query should say

Select Distinct city from Patient where State = this.state
So basically this city filter should only show cities of the state we are working on.

<column colName="State" colExpression="Home_State" width="10%" filterType="query"
filterQuery="SELECT DISTINCT Home_State FROM ZENDemo_Data.Patient ORDER BY Home_State"
 filterOp="="/>

Just in this we need to add a where clause which takes a page property which is not working

<column colName="City" colExpression="Home_City" width="10%" filterType="query"
filterQuery="SELECT DISTINCT Home_City FROM ZENDemo_Data.Patient  Where Home_State = #(%page.State)# ORDER BY Home_City"
 filterOp="="/>