I am trying to export links to excel
dhxTSGrid.setHeader("Terminal Server Name,OS,Type,Username,Password,Notes");
dhxTSGrid.setColTypes("link,ro,ro,ro,ro,ro");
dhxTSGrid.attachEvent("onRightClick", function(id,ind,obj)
{
dhxTSGrid.toExcel("http://localhost/vmatrix/dhtmlx/generate.php");
});
The export works but the links are exported as text . Should’nt that be exported as links to excel? any way to do this?
The grid content xml is :
<?xml version="1.0"?><rows>
<row id="12">
<cell>encompixsrv3^http://localhost/vmatrix/index.php/vmatrix/getrdp/encompixsrv3</cell>
<cell></cell>
<cell>Terminal Server</cell>
<cell></cell>
<cell></cell>
<cell>Support TS for Encompix 9.40 and older</cell>
</row>
<row id="13">
<cell>lab-s-enpx01.consonalab.net^http://localhost/vmatrix/index.php/vmatrix/getrdp/lab-s-enpx01.consonalab.net</cell>
<cell></cell>
<cell>Terminal Server</cell>
<cell></cell>
<cell></cell>
<cell>Support db server for Encompix 9.41 and newer</cell>
</row>
<row id="14">
<cell>lab-s-enpxts01.consonalab.net^http://localhost/vmatrix/index.php/vmatrix/getrdp/lab-s-enpxts01.consonalab.net</cell>
<cell></cell>
<cell>Terminal Server</cell>
<cell></cell>
<cell></cell>
<cell>Support TS for Encompix 9.41 and newer</cell>
</row>
<row id="16">
<cell>lab-s-enpxws01.consonalab.net^http://localhost/vmatrix/index.php/vmatrix/getrdp/lab-s-enpxws01.consonalab.net</cell>
<cell></cell>
<cell>Terminal Server</cell>
<cell></cell>
<cell></cell>
<cell>Test workstation - Windows 7 Enterprise 64-bit</cell>
</row>
<row id="17">
<cell>lab-s-enpxws02.consonalab.net^http://localhost/vmatrix/index.php/vmatrix/getrdp/lab-s-enpxws02.consonalab.net</cell>
<cell></cell>
<cell>Terminal Server</cell>
<cell></cell>
<cell></cell>
<cell>Test workstation - Windows 7 Enterprise 32-bit</cell>
</row>
<row id="18">
<cell>lab-s-enpxws03.consonalab.net^http://localhost/vmatrix/index.php/vmatrix/getrdp/lab-s-enpxws03.consonalab.net</cell>
<cell></cell>
<cell>Terminal Server</cell>
<cell></cell>
<cell></cell>
<cell>Test workstation - Windows XP</cell>
</row>
</rows>
The file attached was archived using 7 zip freely available over the net.
grid.7z (6.77 KB)