Hi,
From your description, I think you can first import your data into a worksheet first, and then re-arrange the data into different workbook, which will be more easier.
After importing the data into a worksheet, you can run the following script to put one line into a new workbook. Also, you can put the script for running after importing. Please note, the data is copied from one line to the first line of new book. If you have different requirement, you need to change the corresponding script.
string strBookName$ = %H; // get the original book name
int nRows = wks.maxRows;
int nCols = wks.nCols;
for(nRowIdx=1; nRowIdx<=nRows; nRowIdx++)
{
range rrSr = [strBookName$]1!col(1)[nRowIdx]:col($(nCols))[nRowIdx]; // source row
newbook; // create a new book
wks.nCols = nCols;
range rrDe = col(1)[1]:col($(nCols))[1]; // destination row
copydata rrSr rrDe; // copy data
sec -p 0.1; // pause for 0.1 second
}
win -cd %(strBookName$); // delete the original book
Penn
