How to output from c to excel & word

daveba...@gmail.com

unread,

Sep 27, 2018, 3:29:44 PM9/27/18

to

Hello members am Ricky I would like to get advice how to make a report using excel or word I.e output from my file in c. Am using codes blocks IDE thanks.it is a small database

Ian Collins

unread,

Sep 27, 2018, 3:36:35 PM9/27/18

to

Output to a CSV or rich text file file, import into whatever you like.

--
Ian.

David Brown

unread,

Sep 27, 2018, 3:41:59 PM9/27/18

to

I strongly recommend LibreOffice rather than MS Office here - it is
/far/ better at dealing with text import such as csv, tsv, etc.

Of course, the other way to handle the problem is to drop C. If you've
got data in a database, use LibreOffice (or, if you are richer and
slightly masochistic, MS Access) to read from the database and generate
the reports you want.

Rick C. Hodgin

unread,

Sep 27, 2018, 3:56:48 PM9/27/18

to

On 9/27/2018 3:29 PM, daveba...@gmail.com wrote:
> Hello members am Ricky I would like to get advice how to make a report using excel or word I.e output from my file in c. Am using codes blocks IDE thanks.it is a small database
>

You have posted to a C++ group. C is different than C++, though
they have many similarities (from a C user's point of view).

If you are willing to use C++, you can actually instantiate an
instance of the "excel.application" class, and directly control
it using the published OLE verbiage:

See the code around line 4186 "iiObj_getClsidObj_byName"
thru to the content around "iiObj_ole_enumerateInfo".
It is incomplete, but it gets you in the ball park.

http://www.libsf.org:8990/projects/LIB/repos/libsf/browse/source/vjr/source/objects/base.cpp

https://support.microsoft.com/en-us/help/196776/office-automation-using-visual-c

But, it's far far easier to write data out to a CSV format as
the others have indicated, and then import.

--
Rick C. Hodgin

Jorgen Grahn

unread,

Sep 28, 2018, 1:36:33 AM9/28/18

to

It's also not clear what real-world problem he wants to solve. The
"excel or word" part puzzles me, since they are very different tools
for very different needs.

For tasks where you want to present data and Excel and Word are both
candidates -- then things like HTML, SVG, PDF, TeX, troff and so on
are candidates, too.

/Jorgen

--
// Jorgen Grahn <grahn@ Oo o. . .
\X/ snipabacken.se> O o .

Marcel Mueller

unread,

Sep 28, 2018, 5:06:43 AM9/28/18

to

Am 27.09.2018 um 21:29 schrieb daveba...@gmail.com:
> Hello members am Ricky I would like to get advice how to make a report using excel or word I.e output from my file in c.

With reasonable effort?

Simply write an HTML. If you choose a filename extension like .xls it
would open with Excel. Most of your CSS style will survive this. If this
is not sufficient you can use the "mso-..." CSS styles, e.g. to prevent
Excel from destroying large numbers like GTIN codes.

Marcel

Queequeg

unread,

Oct 3, 2018, 6:27:59 AM10/3/18

to

When I need to output data to be imported into Excel, I just produce a
tab-separated text output and paste it there. Works.

--
https://www.youtube.com/watch?v=9lSzL1DqQn0