Hi all, I'm new to Indesign Scripting, and I'm hoping someone can help me with the following code:

All I want to do is:

1. open indesign file
2. open excel file
3. place excelfile as a table (with flow enabled)
4. save document & export as PDF

Thanks!

//Define file to open
var myDocumentFile = new File("/d/Projecten/Indesign Server/document.indd");
//Define file to save
//var mySaveFile = new File("/d/Projecten/Indesign Server/document_save.indd");
//Define file to export
var exportPDF = new File("/d/Projecten/Indesign Server/document_save.pdf");
//Open xls-file to place as table
var myExcelFile = new File ("/d/Projecten/Indesign Server/products.xls");
 
var result = "";
if(!myDocumentFile.exists) {
    result = "Unable to find DOCUMENT:  " + myDocumentFile.path;
    $.writeln(result);
    exit();
} else if(!myExcelFile.exists) {
    result = "Unable to find EXCEL:  " + myDocumentFile.path;
    $.writeln(result);
    exit();
} else {
    // Open file
    var myDocument = app.open(myDocumentFile);
    with(app.documents.item(0).pages.item(0)){
        myTarget = textFrames.item("tabel");
    }
    var myPage = myDocument.pages.item(0);
 
    //Set excel placement properties
    setXLimportPrefs();
 
    // Place Excel file
       try {
             $.writeln("Place Excel file");
            //HELP!! HOW TO PLACE EXCEL FILE?
            //myTextFrame.place(myFile);
        }
        catch (e) {
             $.writeln("Place Excel file "  + e + " " + app.excelImportPreferences.errorCode);
            myDocument.close();
            exit();
        } 
    if(!exportPDF.parent.exists && !exportPDF.parent.create()) {
        result = "Not exported.  Unable to create the folder:  " + exportPDF.parent.fullName;
        $.writeln(result);
    } else {
        app.documents.item(0).exportFile(ExportFormat.pdfType, exportPDF, app.pdfExportPresets.item("[Press Quality]"));
    }
    myDocument.exportFile(ExportFormat.PDF_TYPE,exportPDF);
    myDocument.close();
}
 
function setXLimportPrefs(){    $.writeln("setXLimportPrefs()");
        with(app.excelImportPreferences){
            //alignmentStyle property can be:
            //AlignmentStyleOptions.centerAlign
            //AlignmentStyleOptions.leftAlign
            //AlignmentStyleOptions.rightAlign
            //AlignmentStyleOptions.spreadsheet
            alignmentStyle = AlignmentStyleOptions.spreadsheet;
            decimalPlaces = 4;
            preserveGraphics = true;
            //Enter the range you want to import as "start cell:end cell".
            rangeName = "A1:B16";
            sheetIndex = 1;
            sheetName = "Appetizers";
            showHiddenCells = false;
            //tableFormatting property can be:
            //TableFormattingOptions.excelFormattedTable
            //TableFormattingOptions.excelUnformattedTabbedText
            //TableFormattingOptions.excelUnformattedTable
            tableFormatting = TableFormattingOptions.excelFormattedTable;
            useTypographersQuotes = true;
            viewName = "";
        }
}
result;