|Do you know where your variables are?|
Re^3: Excel > Data > Text to Columns (Win32::OLE)by davies (Parson)
|on Apr 29, 2014 at 14:39 UTC||Need Help??|
Obviously this isn't the way to import the data, but you seem to have solved that already. There are three main changes:
Line 22 calculates the number of rows automatically. There are more complicated ways. Avoid them.
The ConsecutiveDelimiter line treats all spaces as a single delimiter.
The AutoFit line is purely cosmetic.
I can't work out quickly how to stop "Mounted on" being split into 2 columns. If there's anything that can be done about that at generation time, it might help. Or you might insert some code to remove & replace the space. Or live with it. Or something else.