Exporting Excel files

The file that defines an export to Microsoft Excel is a comma-separated plain text file. It contains a link to the basic template, and a list of the data items that you want to insert, together with their location. A basic example might look like this:

Filename,Example template.xlsx

Cell,4,11,variable,WireDiameter

Cell,4,12,units,WireDiameter

The first line tells us to load in the file Example template.xlsx, while the two lines below this will write the value of the spring's wire diameter into the cell L5, and its units into the cell M5.

All data export lines follow the same pattern, with the following comma-separated values:

Entry	Possible options	Notes
Command	Cell
Row index	<number>	this starts at index 0, so cell B2 would be row index 1
Column index	<number>	this starts at index 0, so cell B2 would be column index 1
Type of entry	text variable units	a text string the numerical value of the parameter in the next entry the currently selected units of the parameter in the next entry
Parameter	<name of data item to export>	case sensitive, and must match up exactly

A list of the available parameter names is below:

WireDiameter

CoilDiameter

OutsideDiameter

MeanCoilDiameter

InsideDiameter

HousingDiameter

RodDiameter

TotalCoils

ActiveCoils

SpringRate

FreeLength

SolidLength

SolidLoad

SolidStress

SolidStressUncorrected

SolidStressCorrected

StressCorrectionFactor

WorkingStress

SpringIndex

HelixAngle

SpringPitch

BucklingPossible

BucklingDefinite

WireLength

SpringWeight

NaturalFrequency

WireDiameterTolerance

WorkingLength1

WorkingLength2

WorkingLoad1

WorkingLoad2

Travel

Energy

FatigueLifeFactor

MinimumLength

ODExpansionSolid

YoungsModulus

RigidityModulus

Density