Re: Export data to Excel
Re: Export data to Excel
- Subject: Re: Export data to Excel
- From: "Peesapaty Ramesh" <email@hidden>
- Date: Mon, 22 Apr 2002 19:16:55 +0530
Hi,
thanks a lot for ur answers .
i am writing a CSV and a tab delimited file.
in both cases Text Import Wizard comes up .
actually i was trying out Ondra option as follows
"[fileManager changeFileAttributes:(NSDictionary *)[fileManager
fileAttributesAtPath:(NSString *)@"/myproject/features.xls"
traverseLink:(BOOL)YES] atPath:(NSString *)path]"
even then i get the wizard asking for file delimiter .
is there any other way of writing into file where the Text Import Wizard
don't come .
i am using MS-Office 2001 , is that a problem ?
thanks
ramesh
[TABLE NOT SHOWN]
Hi,
On 4/22/02 8:19am, Chris Ridd <email@hidden> wrote:
>
The Excel file format is proprietary to Microsoft, and is a binary
format.
>
You can't just write stuff to a file whose name ends in .xls :-(
>
>
I think the only way you're going to be able to generate XLS is to pay
MS
>
money to get access to it :-( That's probably what P&L (Mesa) had to
do.
Both of the above are true. However, I have a PHP script that sends files
via email with ".xls" extension - it's just base64-encoded tabbed text,
and
Excel opens it just fine.
If you write out a CSV or a tab-delimited file, and drag it onto Excel,
it
"works" fine, and resulting saves leave the document as tab-delimited
text
unless you do something that can't be written as tdt (in which case a
sheet
slides down to ask you what to do).
So I believe what he's asking is how to get the Finder to realize that
double-clicking this file should open Excel. I too think this should
work:
one of my apps creates .csv files and they're given blank icons even
though
I've told Excel to handle _all_ csv files.
Cocoa apps don't write file/creator code, and the file extension takes
precedent in Mac OS X anyway, so I too ask the same question as the
original
poster: _why_ doesn't the Finder realize that his .xls file should open
in
Excel?
I think that's what he was asking... :)
--
Kindest regards,
Erik J. Barzeski
My name is Ozymandias, king of kings:
Look on my works, ye Mighty, and despair!
*******************************************************************
Email: erik@(anything below)
AIM: iacas ICQ: 8186546
http://barzeski.com/ http://weims.net/
http://techstra.net/ http://cocoadevcentral.com/
http://soundsetcentral.com/ http://applescriptcentral.com/
*******************************************************************
_______________________________________________
cocoa-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/cocoa-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
cocoa-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/cocoa-dev
Do not post admin requests to the list. They will be ignored.