__xls-2-image-unique-image-unique

__XLS

<h3>Installation</h3>
The Export Modification add-on contains two components:
<ol>
<li>Windows service Sisense.ExportModifications</li>
<li>Client-Side plugin: exportModifications</li>
</ol>
To install the Export Modifications add-on:
<ol>
<li>Download the Export Modifications add-on.</li>
<li>Extract the .zip file.</li>
<li>Save the /Plugin/exportModifications folder in the plugins folder: C:\Program Files\Sisense\app\plugins.If the folder does not exist, create it.</li>
<li>Run the /Service/PSE.Sisense.ExportModifications.msi file.</li>
<li>Restart Sisense services:
<ol>
<li>Open the Configuration Manager from your browser at http://localhost:3030.</li>
<li>Click the Sisense logo five times to display the full list of service configurations on the left.</li>
<li>Click Restart Services.</li>
</ol>
</li>
<li>Configure the Export Modifications add-on, as described below.</li>
<li>Refresh your dashboard.</li>
</ol>
Configure the Export Modifications
<ol>
<li>Open the Configuration Manager from your browser at http://localhost:3030.</li>
<li>Click the Sisense logo five times to display the full list of service configurations on the left.</li>
<li>Click the Export Modification tab. 
<img decoding="async" loading="lazy" class="alignnone" src="https://cdn.sisense.com/wp-content/uploads/export-mod-tab.png" alt="" width="1820" height="1250" /> <img decoding="async" loading="lazy" class="alignnone" src="https://cdn.sisense.com/wp-content/uploads/export-mod-tab-2.png" alt="" width="1820" height="1250" /></li>
</ol>
Configuration options:
<ol>
<li>Alignment &#8211; Excel cell alignment.
<ol>
<li>alignmentNumber left/right/center. Alignment of number values.</li>
<li>alignmentText left/right/center. Alignment of text values.</li>
</ol>
</li>
<li>General
<ol>
<li>configuredFilterTitle text. Specify the title of a dashboard filter to be presented on the first Excel tab.</li>
<li>enabledFilterSheet on/off. Includes an additional tab with the widget and dashboard filters.</li>
<li>enabledReportName on/off. When toggled on, an additional row with the widget name and the configuredFilterTitle is added to the first tab above the table.</li>
<li>grandTotalTop on/off. When toggled on, the grand total row is presented at the top of the table.</li>
<li>make font bold on/off. When toggled on, the column headers are bold.</li>
<li>minExcelColumnWidth number. Set the minimum width of Excel columns.</li>
<li>showFiltersOnCSV on/off. When toggled on, the dashboard and widget filters are included in the CSV file.</li>
</ol>
</li>
<li>InsertImage &#8211; Can be used to brand the Excel and add a logo.
<ol>
<li>enabled on/off. When toggled on, the configured image is added to Excel.</li>
<li>imageHeight number</li>
<li>imagePath text</li>
<li>imageWidth number</li>
</ol>
</li>
<li>NewTextLines &#8211; Additional information
<ol>
<li>dateFormat text. The format of the data date and the export date in the filters tab.</li>
<li>explanatoryText text. The text is added to all Excel files on the Filters tab.</li>
<li>newRowCharacter text. Character to split the explanatory text by.</li>
</ol>
</li>
</ol>

Export Enhancements

excel

export

The Export Modifications add-on enables you to change the style of exported Excel files and add additional information to export CSV and Excel files, such as the dashboard information. The add-on also enables exporting to Excel for table and table with aggregation widgets. 
Note: Export modifications are set from the Configuration Manager and apply to all users for all exports. A user cannot modify a specific Excel or CSV export.
<h3>Excel Modifications</h3>
Apply the following changes to Excel files:
<ul>
<li>Include dashboard information, such as dashboard date and last data update date</li>
<li>Cell content alignment</li>
<li>Include dashboard and widget filters</li>
<li>Insert an image &#8211; can be used to brand the Excel</li>
<li>Modify &#8216;rows&#8217; columns to contain unmerged cells</li>
<li>Move the &#8216;grand total&#8217; row to the top of the table</li>
<li>Make the &#8216;grand total&#8217; row, &#8216;grand total&#8217; columns</li>
<li>Make measures headers bold</li>
</ul>
<h3>CSV Modifications</h3>
Apply the following changes to CSV files:
<ul>
<li>Add filters below the widget data to CSV files</li>
</ul>
<h3>Screenshots</h3>
Dashboard Widget:
<img decoding="async" loading="lazy" class="alignnone" src="https://cdn.sisense.com/wp-content/uploads/export-mod-widget.png" alt="" width="2260" height="1028" />
Export Modifications Off:
<img decoding="async" loading="lazy" class="alignnone" src="https://cdn.sisense.com/wp-content/uploads/export-mod-off.png" alt="" width="1011" height="935" />
Export Modifications On (Report Tab):
<img decoding="async" loading="lazy" class="alignnone" src="https://cdn.sisense.com/wp-content/uploads/export-mod-on-report.png" alt="" width="933" height="935" />
Export Modifications On (Filters Tab):
<img decoding="async" loading="lazy" class="alignnone" src="https://cdn.sisense.com/wp-content/uploads/export-mod-on-filters.png" alt="" width="933" height="935" />
CSV File:
<img decoding="async" loading="lazy" class="alignnone" src="https://cdn.sisense.com/wp-content/uploads/export-mod-csv.png" alt="" width="933" height="859" />

Get the Add-on

Leave Feedback