trainopk.blogg.se - Indesign cc 2017 how do i set a default file to open

If it isn't set, semicolon will be used by default

splitCharColumn - the character to use for splitting the columns in the spreadsheed: e.g.

If it isn't set, pipe (|) will be used by default

splitCharRows - the character to use for splitting the rows in the spreadsheed.

Var excelFilePath = "Test:My Folder:SampleBook.xlsx" excelFilePath - The Mac-specific – colon separated – full path name for the xlsx-file like in the line below:.It works in the same way as the abovementioned counterpart for Windows and was tested in InDesign CC 2015 and Excel 2011 (Version 11) on Mac OS X 10.10 (Yoshemite). Important note: why AppleScript run from JavaScript doesn't work anymore? Important note: if you get the "Cannot create ActiveX Component " error message, run InDesign as administrator to recreate the "Resources for Visual Basic.tlb" file. Here's a sample code illustrating how to use it. Promise that such a perverted script would work.) So I've found the I tried to make a moreĮlegant solution, but it didn't work for some reason: it worked perfectlyĪs a stand alone visual basic script run in VBA, but failed when triggeredįrom JavaScript via doScript method. Number is unavailable) the script breaks the loop. Spreads to try to open, and once an error occurs (the spread with the

The VBS-code has a try-catch block so you can set a maximum number of Recommend you to useĪllows you to get the data from all spreadsheets in a workbook.Īlso, it gets the name of the spreadsheet. I posted all two versions I developed so far. Here’s a practical example: a script that uses this function. It’s possible to reference a spreadsheet by name instead of a number by using a name enclosed with escaped double quotes (inch marks) like so: The same data transfered to InDesign as Array If it isn't set, the first worksheet will be used by default

sheetNumber - the worksheet number: either String or Number.

If it isn't set, semicolon will be used by default.

splitChar - the character to use for splitting the columns in the spreadsheed: e.g.

Var excelFilePath = "D:\\My Test Folder\\SampleBook.xlsx" If you pass it as a string, make sure to double the backslashes in the path like in the line below:

excelFilePath - The platform-specific full path name for the xlsx-file - fsName.

However, this takes an extra step for the user so I decided to write a function that opens an Excel book in background, reads the data from its spreadsheet and returns array. I (and most scripters) believed that the easiest approach was to use a CSV-file exported from Excel. Quite often I have to write scripts that use data originated from an Excel worksheet. Theoretically it should work in all versions from CS (3) to CC 2017 (12). The function was written and tested in InDesign CC 2017 and Excel 2016 (Version 16) on Windows 10.