GetMrData.xls has been around for as long as we can remember, but how many of you know about it ? In the article we will show you how to use it and get your data into an excel file. Yes you can export directly out of Data collection to do this directly, but with this file and some customization you could make it do allot more than just that.
Excel
Loading a card column file into Excel
In this article we are going to show you how you might change a quantum output file into something that can be loaded up into Excel. You might want to do this if you just want to look at the data file.
Show all Excel constants
It is often very useful to have a list of all the constants that are used in Excel 2003. One way to get a list is to search the web, but you can produce such a list yourself. All you have to make sure is that you have the following DLL installed TlbInf32.dll. If you don’t have it, search the web and you will find. Once installed create a new mrs file and add the following code
List of All Excel Constants
This is a list of all the Excel constants
Finding the value of EXCEL constants
When you write scripts that utilise Microsoft Excel objects you will definitely come across the need to understand some of the numeric values that are stored as Excel Constants. There are several ways you can find out these values and this article provides you with two ways to do that. Before we get started we need to have some excel code.
Table of Contents for Excel Tables
Ever wish that the tables export to Excel would create a table of contents? Ever wish for sheet names based other than T1, T2, etc.? This post discusses a Dimensions script that creates a Table of Contents sheet, optionally creates links back to the TOC sheet on each table/chart sheet and optionally renames the sheets based on a row in the sheet.