On Nov 29, 2005, at 1:17 PM, Stephen Koger wrote:
I am trying to use the following to break up a text file I am loading
into
excel.
excel.Range("A"+str(RowNumber)).TextToColumns
Does anyone know the syntax to control how this determines the breaks?
It simply offers user input in determining the breaks.
It opens Excel's TextToColumns "wizard" dialog which provides the user
with options to control the breaks. The dialog displays a preview of
the row-column distribution of the selected text file based on Excel's
default interpretation of breaks, then offers user options to modify
this is in terms of specifying delimiters, etc., before the file is
loaded into the spreadsheet.
Best regards,
Jack
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|