You will need the latest Microsoft Visual Studio for Office Runtime (VSTO 4.0) from Microsoft installed on your PC. It can be downloaded directly from Microsoft here.
There is not differentiation between Office 32 and 64 bit installation any more, below installer works on both setups. |
Latest Installer: R4J_Excel_4.1.0-651-combined.msi
Release notes: Excel Addin 4.1
BETA-Version: R4J_Excel_4.1.7-692-combined.msi
- Fixed performance problem at upload to Jira if issues nested in R4J tree structure
The add-in will add a new ribbon tab, "JIRA", to your Excel interface.
If the new ribbon tab is not visible, please follow these steps.
Before working with your issues, the connection to JIRA must be configured first. To do so, select the option Settings and enter your JIRA URL, username and password. With Save as... you can setup connections to different Jira servers.
Options:
Jira API Token: Alternative option to connect to Jira via Personal access token (after Jira 8.14)
Remember me: stores your password encrypted in a save location
Show changed values as Excel comments: Shows found differences (of Check button) as comment content.
Show Issue Key column as hyperlink: Enables Issue Key to hyperlink into Jira instance
Write Debug Logs: Store send and received messages in log file, to analyze communication issues. Mouse over to retrieve location of log file.
Maximum number of comments per issues: Number of latest comments downloaded from Jira when using the "Comments" field, 0 (zero) retrieves all comments
Afterwards, you can extract issues with the Load Data option and upload them with the Upload Data option. See the user guide.
To easier identify issues in the communication and data quality, the Excel Plugin can create logfile on demand:
Enable "Write Debug Logs" in the instance settings
Get the file "excel-log.txt" from "%appdata%\ease solutions\Office to Jira Integration" folder
"excel-log.txt.*" are older files, up to five files stored.