Automatically convert an Excel table to a checklist for JIRA

JIRA supports a subset of Wiki Markup to add tables and other formatting to fields like Description or Comments. Writing the Wiki Markup manually is quite time consuming though. To make the process a bit easier I ended up writing a Macro that converts an Excel based task tracker list into JIRA. From this: Into … Continue reading Automatically convert an Excel table to a checklist for JIRA

Automatically clean-up excel data with multiple entries per cell separated by comma or line-breaks

This is a follow-up from a previous post where I did the same using PowerShell. A short recap first. The goal is to turn something like this: Into this: In the original state some of the cells have multiple entries that are either separated by comma or line-breaks (via Alt+Enter). Furthermore several of those entries … Continue reading Automatically clean-up excel data with multiple entries per cell separated by comma or line-breaks

How to convert Excel 97-03 (.xls) to new format (.xlsx) using office file converter (ofc.exe)

Usually one would use something like the code below in order to convert Excel 97-03 (.xls) files to the new format (.xlsx) via PowerShell through the Excel COM Interop interface: In my case since I've switched to Excel 2013 the above method (and actually all excel automation via COM Interop) is much slower than compared … Continue reading How to convert Excel 97-03 (.xls) to new format (.xlsx) using office file converter (ofc.exe)

Convert between US and European date formats in Excel

The easiest way I know of (please let me know if you know a better way) to convert between US ("mm/dd/yy") and European ("dd/mm/yy") dates without using VBA in Excel is via "Text to Columns". Let's look at an example: My system's regional settings are setup for US dates, therefore I need to convert the … Continue reading Convert between US and European date formats in Excel

“Please wait while windows configures Microsoft Visual Studio…” when starting Excel

I got this dialog ("Please wait while windows configures Microsoft Visual Studio Professional 2013") on every Excel (2010) start up shortly after I had installed Visual Studio 2013 Community Edition. In my case it delayed the Excel start-up for several minutes. In order to get rid of the quite annoying dialog I just created a … Continue reading “Please wait while windows configures Microsoft Visual Studio…” when starting Excel