Extracting data from Excel To Illustrator javascript or vbscript

As text… \n is new line character and \r is return character. I can't remember which excel uses but they both equate to a line/paragraph… I very quickly threw together an example for you…

#target Illustrator
textToPDF();
function textToPDF() {
          if ( app.documents.length == 0 ) { return; }
          var doc, csvFile, i, fileArray, opts;
          csvFile = File( '~/Desktop/ScriptTest/Test.csv' );
          if ( !csvFile.exists ) { return; }
          fileArray = readInCSV( csvFile );
          doc = app.activeDocument;
          opts = new PDFSaveOptions();
          opts.pDFPreset = '[Press Quality]';
  
          // Here we loop the main array
          for ( i = 0; i < fileArray.length; i++ ) {
  
                    // Here we get the second item of sub array i
                    doc.textFrames.getByName( 'DWG' ).contents = fileArray.[1];
  
                    // Here we get the first item of sub array i
                    doc.saveAs( File( fileArray.[0] ), opts );
          };
};
function readInCSV( fileObj ) {
          var fileArray, thisLine, csvArray;
          fileArray =[];
          fileObj.open( 'r' );
          while( !fileObj.eof ) {
                    thisLine = fileObj.readln();
                    csvArray = thisLine.split( ',' );
                    fileArray.push( csvArray );
          };
          fileObj.close();
          return fileArray;
};

I haven't tested it but it should be close…?