Converting txt to excel format

[bs...@pop.dnvr.uswest.net]

I need to convert some text files to files that will be in a Microsoft
Excel format.
This can be done manually . In the Excel application You just select
this as an option on the popdown menu, and then specify what delimeter
seperates the columns. You also tell it the name of the file to import.

My question is how can I do this without having to run Excel. Does
anyone know if Excel has any API calls? I was wondering if these API
calls could be called from a C++ application.

I hope someone can at least refer me to somewhere where I can get help
on this. Is there any type of
Visual C++ newsgroup out there.

Kara G.

[Greg Chicares]

> I need to convert some text files to...Microsoft Excel format...

> My question is how can I do this without having to run Excel. Does
> anyone know if Excel has any API calls? I was wondering if these API
> calls could be called from a C++ application.

Yes. Get the Excel SDK from Microsoft. Book plus CD, about US$50.
There's a C API that you can use from your C++ programs. Of course,
you'll still need to use Excel for this, but you can automate the task.

There's probably some way to do it with OLE automation as well. You
might find some examples in the examples directory of your Borland
compiler.

Or get Formula 1 from www.visualcomp.com and use it to read a
tab-delimited file and write an Excel file. This method doesn't require
using Excel at all.

The SDK book also explains the file format, so that you can write your
own routines.

> Is there any type of Visual C++ newsgroup out there

Try this news server:
msnews.microsoft.com