Be warned, I am a very new to AppleScript and most programming in general. The basic purpose of the script I've been working on is to read information from Excel files and put it into a FileMaker Pro database. Everything is working well so far, except when attempting to get the value of cells containing dates. Since the dates in the Excel file are already formatted correctly (mm/dd/yy) for the database they are to be put in, I would like to simply read and write them as strings.
The problem arises here, where AppleScript outputs the values as dates in the format (day of the week, month dd, yyyy at 12:00:00 AM) despite my attempt to read them as strings. Below is a shortened version of the script that shows where the problem is occurring.
tell application "Finder" activate application "Microsoft Excel" open the first file in folder "Macintosh HD:Users:theUser:Documents:attachments test" tell application "Microsoft Excel" tell active sheet tell used range set rowCount to count of rows repeat with i from 2 to rowCount set colA to "A" & i & ":A" & i set theDate to get value of range colA as string set rowB to "B" & i & ":B" & i set theTime to get value of range rowB as real set colC to "C" & i & ":C" & i set serialNo to get value of range colC as integer set colD to "D" & i & ":D" & i set pH to get value of range colD as real set colE to "E" & i & ":E" & i set theVolume to get value of range colE as real display dialog "The serial number of row " & i & " is: " & serialNo & " and the pH value is: " & pH & " and the volume is: " & theVolume & " and the date is: " & theDate & " and the time is: " & theTime end repeat end tell end tell end tell end tell
I also tried another method to deal with the problem by setting a variable each for day, month, and year, but ran into another issue where month is not recognized as a purple word (whatever that should be called) and is instead blue (again, I cannot find what these terms are called anywhere). In the image below are three different ways I attempted to get these values from the date in format (day of the week, month dd, yyyy at 12:00:00 AM) so that they could then be reorganized manually.
My only guess for the initial problem is that 'as string' does not work when placed after the other parts of the line, but I have no clue why month is refusing to cooperate. Any guidance would be greatly appreciated!