CREATE AN EXCEL FILE DIRECTLY FROM A PROGRAM

Discussion and announcements related to the BRGroup and ADS conferences.

Moderators: Susan Smith, admin, Gabriel

cdidan
Posts: 7
Joined: Thu Aug 06, 2009 7:10 am
Location: Mount Clemens, MI

CREATE AN EXCEL FILE DIRECTLY FROM A PROGRAM

Postby cdidan » Wed Oct 02, 2013 9:39 am

I have always created a delimited text file and then opened it in excel to create an excel file.
Is it possible to create an excel file directly from a program?
If it is possible how do you do it?

Kevin Klappstein
Posts: 25
Joined: Thu Jun 11, 2009 9:04 am
Location: Edmonton
Contact:

Re: CREATE AN EXCEL FILE DIRECTLY FROM A PROGRAM

Postby Kevin Klappstein » Wed Oct 02, 2013 10:04 am

cdidan wrote:I have always created a delimited text file and then opened it in excel to create an excel file.
Is it possible to create an excel file directly from a program?
If it is possible how do you do it?


Not an native Excel file, but there are a couple of ways to achieve the same result. Louis uses HTML to create Excel spreadsheets, you can also use Excel XML formats: http://en.wikipedia.org/wiki/Microsoft_ ... ML_formats

If you use the .xls extension on your file, it will launch to into Excel automatically, though it will yell at you for a different format that it was expecting (Louis has posted the registry entries to suppress that message somewhere)
Kevin Klappstein
Western Canadian Software


Return to “Conferences”

Who is online

Users browsing this forum: No registered users and 1 guest

cron