I'm trying to specify the output range for impASC, but it continues to import data to the first column in the sheet. Is it possible to make it put the data in the columns 5:10, for example? Here is what I tried:
It seems impASC was not designed to accept the column range for output, maybe because it is a risky operation when the number of imported columns (which is unknown before importing) may be larger than the number of specified columns. As alternative, you can import by setting the Import Mode to Start New Columns (options.ImpMode:=1), and move the imported columns to the destination by colmove x-function such as:
nc1=wks.ncols+1;
impASC ... options.ImpMode:=1 ;
nc2=wks.ncols;
colmove rng:=wcol(nc1):wcol(nc2) operation:=pos col:=col(2); //Note: Output column is only specified the starting position
Of course, you can also put this colmove line in options.Script.RunScriptAfterEachImport option, if you like.
impASC to certain columns
Posted - 08/30/2017 : 07:34:10 AM
