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 K4, and its units into the cell L4.


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


Entry

Possible options

Notes

Command

Filename

Cell

the Excel template to insert all following entries into

defines each value entry

Row index

<number>

this starts at 1, so cell B2 would be row number 2

Column index

<number>

this starts at  1, so cell B2 would be column number 1

Type of entry

text

variable

units

a text string, inserted exactly as written

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

Qualifier (optional)

<number>

for some values, such as OperatingLength, you can add an extra number defining which operating position.


A list of parameter names is available for compression springs.


Examples of generic names are shown 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