473,508 Members | 2,434 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

VC++ & Excel

8 New Member
Hello!

I have a question. I work with Excel from VC++ application. I read csv-file, reorganize it and put data into Excel-file using
Expand|Select|Wrap|Line Numbers
  1. CApplication app.CreateDispatch(_T("Excel.Application));
  2. ...
  3.  
But the problem is I have huge data array and when I try to fill excel file with it, then it continues eternity, it takes minutes (10 min). May be there is some other quick way to put my data to excel file?

Thanks
May 15 '07 #1
2 2815
gpraghuram
1,275 Recognized Expert Top Contributor
Hi,
I have a different idea to put the data into excel file.
Write the output as a comma separated value file(that is CSV) file.
and then open the CSV file using excel.
I dont know this address ur problem but giving a easier approach.

Thanks
Raghuram
May 15 '07 #2
Mariii
8 New Member
Yes, you are right, thanks!:) I came to the same decision.
May 15 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
2360
by: Michael Robbins | last post by:
Please pardon me if this question is common; I didn't see an answer. I have access to a MS Excel Add-In but I want to use the functions from within my Visual C++ code. Can I do this? How?
1
3932
by: st | last post by:
Hi, I'm using xmlDocument.Save(xmlTextWriter) to create an Excel-readable file. All works well, except where I've replaced the carriage return chars in the .innertext to XML-compliant " "; It...
0
980
by: Howard Weiss | last post by:
I am writing an application which automates Excel from Managed Visual C++. I have imported the Microsoft Excel Objects COM object per KB 303871 and KB 303872. If I do this in C# or VB, the...
1
1676
by: Venkat | last post by:
Can we create an Excel Addin with VC++.net? We are developing an application in c# which interacts with Excel application. The UI will be Excel and based on the inputs given through excel I...
2
5955
by: k-w | last post by:
Hi all In vb I do: Dim Ex As New Excel.Application Ex.Workbooks.Open "c:\tmp\Book1.xls" Similar code in VC doesn't work:
4
4383
by: Suzette | last post by:
I have an excel file that automatically updates when opened, pulling information from an Access database into into various pivot tables. I created a macro in Access to perform various necessary...
0
2481
by: SuperFly07 | last post by:
Do any of you know how to write code in c or vc++ to disable password protected excel files? We want to automate this process. I know how we can disable it manually. We are looking to automate the...
0
1172
by: SuperFly07 | last post by:
Do any of you know how to write code in c or vc++ to disable password protected excel files? We want to automate this process. I know how we can disable it manually. We are looking to automate the...
2
3434
by: rajini | last post by:
Hai.... i have Vc++ code . i need to create Dll file by using following code can u help me....here with this i had sent my vc++ code VARIANT root = {0}; // Generic IDispatchs VARIANT...
0
7224
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7379
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7038
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5625
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4706
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3192
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1550
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
763
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
415
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.