You can't read data directly from an Excel file, as it is not a plain-text file. You will need to first convert it to something like a tab-delimited text file, a CSV file, or even an XML file, and then you would be able to read it directly using a script.
I'm able to manually copy the Excel (or really, probably write a VBA script that saves certain cells into a CSV file). Once I do that, how can I import that CSV into an array? Thank you for the quick response!
You can use a method like readFileIntoStream of the util object, or even import the file as a data-object (importDataObject), read its contents (getDataObjectContents) and then remove it (removeDataObject, all under the Document object).
So I got the readFileIntoStream file explorer to work, but am struggling in understanding how to store that data as an array within my code?
var StringArray = util.readFileIntoStream();
and then later in the code I have
for (var m = 0; m < stringArray.length; m++)
if (string == stringArray
Am I doing this incorrectly? Thank you!
You need to read the documentation of these methods carefully. The readFileIntoStream method returns a Stream object, which you then need to convert into a String, which in turn you can parse by splitting it two times: Once, converting it into an array of lines, and then another time, converting each line to an array of the individual items in it.
Did you expect me to write your full code for you? As you've seen, this is not a simple task. I'm happy to do it for you, for a fee.
You can contact me privately (try6767 at gmail.com) and we could discuss it further.
I'm sorry if it came over as condescending, but I believe I've provided you a lot of valuable information about how this can be achieved, and reading the documentation (which also contains code samples) is truly the best way to learn how to do it for yourself.