Importing excel cell range information to Indesign with javascript

Off the top of my head, here's a very simplified approach that can be used (just for illustration):

main();

function main() {
	var doc = app.activeDocument;
	var fileExcel = new File("~/Desktop/Test.xlsx");
	
	if (fileExcel.exists) {
		var ranges = [
							"a1:b1",
							"c1:c3"
							];
		
		for (var i = 0; i < ranges.length; i++) {
			app.excelImportPreferences.rangeName = ranges[i];
			doc.pages[0].textFrames[i].place(fileExcel);		
		}
	}
}

 I have no idea what you're trying to achieve, but let's assume you have a number of text frames per page and want to fill them with data from excel. You can list all ranges in an array and place them all adding pages on the fly. To keep them in the correct order, create a template -- indt-file -- with one page. On this page, you can create a number of text frames and label them in the order you want: e.g. from top left to bottom right. Something like 'range 1', 'range 2', and so on. On adding a page, you can increment these numbers with a simple function. Then the script can find the correct frame by label. Otherwise, the script will use frames in a random order giving unexpected results.
That's the way I did it in my practice.

Alternatively, if you don't need to keep formatting and plain text data is enough for you, you can grab all the data from a spread, or (for Windows only) from all spreads and process them in InDesign. Here's a 'ready to use' function for this task.

— Kas