Import data (cell range) from excel to InDesign via script

[daniel_pfrommer6917]

Hi, at the moment I'm importing data from a excel file to a frame via "File -> Place -> "Show import options". In the dialog window I choose the named "cell range" and my predefined "table style".

I'm looking for a script which automates this process.

For example: In my excel file I have 10 tables (predefined and named via the "cell range") and in my Indesign document I have 10 frames. I think the best approach would be to make it like placing images in Indesign where you can choose 10 images and then put it to frames one image after the other.

Is there any way I could do this with a script?

Thank you very much in advance.

[Robert at ID-Tasker]

Are you looking for a ready made script - or just for guidance? 

https://www.indesignjs.de/extendscriptAPI/indesign-latest/#ExcelImportPreference.html

There is rangeName property.