Okay so here is what I did.... I wrote a macro within my Excel document to copy the selected cells and save them to a text file called "Spec.txt". Then write a script that would do a find and replace to fill in the needed data. Finally, the script clears the txt file so that there's no fear of importing the wrong data.
// Get a reference to the currently active document
var doc = app.activeDocument;
var sel = doc.selection;
// Call the function to get the text string from a file and replace the contents of any text frames containing the word "ordnum"
getspecInformation();
// This function reads the contents of a file and returns them as a string
function getspecInformation() {
var specText = getTextString("C:/Users/Public/Spec.txt");
// If the file exists and is not empty
if (specText !== null && specText !== "") {
// Replace the contents of any text frames containing the word "ordnum" with the contents of the file
replaceText(specText);
}
}
// This function reads the contents of a file and returns them as a string
function getTextString(filePath) {
var textString;
var file = new File(filePath);
// If the file exists
if (file.exists) {
// Open the file in read mode
file.open("r"); // "r" stands for read
// Read the contents of the file into a string
textString = file.read();
// Close the file
file.close();
// Return the string containing the file contents
return textString;
} else {
// If the file does not exist, return null
return null;
}
}
// This function searches for the word "ordnum" in any text frames in the document and replaces it with the specified text
function replaceText(specText) {
// Create a regular expression to search for the word "ordnum" (with the "g" flag for a global search)
var searchString = /ordnum/g; // g for global search, remove i to make a case sensitive search
// Get a reference to all the text frames in the document
var textFrames = doc.textFrames;
// Declare some variables for use in the loop
var thisTF, newString;
// If there are any text frames in the document
if (textFrames.length > 0) {
// Loop through each text frame
for (var i = 0; i < textFrames.length; i++) {
thisTF = textFrames[i];
// If the contents of the text frame contain the word "ordnum"
if (thisTF.contents.indexOf("ordnum") !== -1) {
// Replace the word "ordnum" with the specified text
newString = thisTF.contents.replace(searchString, specText);
// Set the contents of the text frame to the new string
thisTF.contents = newString;
}
}
}
// Call the function to clear the contents of the file used for replacement
clearFileContents("C:/Users/Public/Spec.txt");
}
// This function clears the contents of the specified file
function clearFileContents(filePath) {
// Create a new file object using the specified file path
var file = new File(filePath);
// If the file exists
if (file.exists) {
var fileLength = file.length;
if (fileLength > 0) {
file.open("w"); // "w" stands for write
file.close();
}
}
}
7
Replies
AdChoices