[Data files with multiple sheets]

Dmiller,

Here is some code for you to be able to call a certain sheet in an excel file.

var xdf = new ExternalDataFileEx("data.xls", "Excel", "Sheet 2");

 

[Alignment change between Connected Text Frames]

Drew,

Sorry, that you didn't get a good experience with FusionPro Support. This would be something they would have to task to one of their programmers.

You could use a text rule like this with 2 text frames and it should what I think you want. Put this rule in Frame A and then link it to Frame B.

//Rule_info
var myinfo = "";

//Creating an array to see how many fields are being used.
//You can swop out any of these with the rules with the prefix text ("Direct: ", "Cell: ", "Main: ", or "NMLS #")
var allinfo = [Field("Street Address"),Field("City State ZIP"),Field("Direct"),Field("Cell"),Field("Main"),Field("Email"),Field("Website"),Field("NMLS")];

//This is the tagged markup for the right justified text with a leading of 9pt
var rightjust = '<p style="(no style)" override="true" quad="R" leading="90" findent="0" lindent="0" rindent="0" leadbefore="0" leadafter="0" keeplines="true" widows="1" kerning="true" hyphenate="false" skipifempty="true" skipifemptyvar="false" noparabreakoncopyfit="false"><tracking newsize="0"><f name="ITC Avant Garde Std Bk"><z newsize="7.0"><color name="C=0 M=100 Y=0 K=0">';

//This is the tagged markup for the left justified text with a leading of 9pt
var leftjust = '<p style="(no style)" override="true" quad="L" leading="90" findent="0" lindent="0" rindent="0" leadbefore="0" leadafter="0" keeplines="true" widows="1" kerning="true" hyphenate="false" skipifempty="true" skipifemptyvar="false" noparabreakoncopyfit="false"><tracking newsize="0"><f name="ITC Avant Garde Std Bk"><z newsize="7.0"><color name="C=0 M=100 Y=0 K=0">';

//This is the loop to pull everything in
for (i=0; i<allinfo.length; i++)
{
    if (i<5)
        var mysep = rightjust+'<p>';    //This sets the right justification for the first 5 fields
    else
        var mysep = leftjust+'<p>';    //This sets the left justification for the rest
        
    if (i < 1)
        myinfo = AppendText(myinfo, "", rightjust + allinfo[i]);    //set the right justification for the first field
    else
        myinfo = AppendText(myinfo, mysep, allinfo[i]);
}
return myinfo;

//You can put this in the Javascript Globals so you can use it in all rules.
function AppendText(FullText, Delimiter, NewText)
{
    if (NewText != "")
    {
        if (FullText != "")
            FullText += Delimiter;
        FullText += NewText;
    }
    return FullText;
}