How to write an array into an excel range using c++

Question

0.00/5 (No votes)

See more:

I have an array of class(say cols 12 and rows 20) which i need to write into an excel sheet.
Is there any way to write the array into a range of an excel sheet at a stretch without looping each cell as like in C#.

Please let know any additional details needed. Thanks in advance.

Posted 24-May-15 20:21pm

Nrajmec

Updated 24-May-15 20:22pm

v2

Add a Solution

Comments

CPallini 25-May-15 3:31am

What's wrong with looping?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

barneyman · Answer 1 · 2015-05-25T14:07:00

your three solutions are

1. use the OLEDB JET Driver for Excel[^]
2. the object model for Excel[^]
3. the Office XML format[^]

The first requires you have a C++ OLEDB client library
The second requires using COM and messing with the godawful Excel Automation model (here we use an Active Script Host in C++ and let a VB script do all the heavy lifting, it's easier to debug, and develop that way)
The third could be done by turning your raw data into a basic XML doc then XSLT'ing it to the required format - again, this involves either a third party XML/XSLT client or getting your hands dirty with MSXML[^]