Re: From tab text to Excel
Re: From tab text to Excel
- Subject: Re: From tab text to Excel
- From: Doug McNutt <email@hidden>
- Date: Mon, 11 Apr 2005 21:21:01 -0600
At 16:51 -0700 4/11/05, Eric Geoffroy wrote:
>I'm going to add a repeat to this once it's working.
>I have a tab delim text file, but putting the items into a worksheet I'm stymied. Some of the text in the file is separated by a space, but I'm only concerned with the tab.
Tab delimited files are native to Excel. It's a great way, for instance, to get data into Excel when it originates as ASCII text from the likes of a scientific instrument. I confess I use Visual Basic macros but all I do is ask Excel to open the *.tsv file and then work with the new workbook that is created moving stuff from there to wherever I want it.
You could, in AppleScript, tell Excel to open your *.tsv file and then copy its contents. A subsequent select of a cell followed by a paste ought to do all you want. You could also, in Excel, turn on the macro recorder, perform the open, copy, and paste, and then look at the VBA it creates.
Excel doesn't mind spaces in a cell but it will choke on tabs and simple returns.
--
--> Life begins at ovulation. Ladies should endeavor to get every young life fertilized. <--
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden