|
Click Click[^]
MSN Messenger.
prakashnadar@msn.com
Tip of the day of visual C++ IDE.
"We use it before you do! Visual C++ was developed using Visual C++"
|
|
|
|
|
I have a requirement to create MS Excel workbook files as part of a reporting application I am developing. I need to produce these files from within a Windows service. I cannot use automation so I need to create the files directly. I have been looking on the web for open-source, or commercial Excel file creation library and have come across a few possibilities. I am evaluating a couple options right now, but before I dive too deep into this, can anyone suggest a decent Excel file creation library for C++. (Again, commercial or open-source.)
PS. I must write to a native Excel format that supports multiple worksheets. BIFF8 or better I believe.
|
|
|
|
|
Excel files can function as an ODBC (and JET) data source, so could it be that you can write an Excel file by using the same procedure, only reversed ?
Is there are reason on why you can't use automation ? It can be kept simple and efficient, with a minimal overhead, if that's a problem..
-Antti Keskinen
----------------------------------------------
The definition of impossible is strictly dependant
on what we think is possible.
|
|
|
|
|
I really hope to do that also, so I'm hoping you get a good response. I've used the alxBase classes I found on this site for .dbf's that writes directly to the file and is super-fast. I have to give the user an option though between .xls and .dbf (for import). I'm using the automation for excel and it's about 10 times as slow as the alxBase classes which are writing directly to the file with the correct offsets.
If it's broken, I probably did it
bdiamond
|
|
|
|
|
I want to write to an Access(*.mdb) file from a form(Record View) and capability to read this access file.
I did like MSDN and i have created a Recordset class and Record View class i have connect record view to Recordset but it does not work. how can i do this?
Mehdi Hosseinpour
|
|
|
|
|
For all database functionality on MFC, I first suggest you read the article by Stefan Chekanov found here[^].
The Access file acts as a data source, and by using Chekanov's article and the classes introduced there, you can execute plain SQL-queries to retrieve custom data sets, and then use a by-index or by-name methods to retrieve the data from the resulting set. After you have the data in a local variable (CString or similar), you can use Dialog Data Exchange implemented by a CFormView-derived class to move data into the form's controls and vice versa.
To write data into the database, use the Field function to get a reference to the CDBField, then use the overloaded assignment '=' operator in CDBField class. Remember to prepare the database for updates first, and then flush the update operations when finished. Otherwise an assertion might occur.
-Antti Keskinen
----------------------------------------------
The definition of impossible is strictly dependant
on what we think is possible.
|
|
|
|
|
Mehdi_Hosseinpour wrote:
...but it does not work.
Which means what? Are you getting compiler, linker, or runtime errors? Please elaborate.
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
|
|
|
|
|
We can't help you if you don't give details!
Don't try it, just do it! 
|
|
|
|
|
What is the difference between platform SDK and service pack for visual C++?
which one should i choose for what ?
Thanx.
MSN Messenger.
prakashnadar@msn.com
Tip of the day of visual C++ IDE.
"We use it before you do! Visual C++ was developed using Visual C++"
|
|
|
|
|
As far as i know
Platform SDK is a set of header files, lib and other such stuff for developing windows application without any MFC or ATL.
Service Packs (for VC++) are generally for MFC, VB and data access(DAO,ADO)
C makes it easy to shoot yourself in the foot; C++ makes it harder, but when you do, it blows away your whole leg
|
|
|
|
|
servicepack is a cumulative fixes for known bugs and problems.
sdk is a downloadable platform for developers. 
greatest thing is to do wot others think you cant
suhredayan@omniquad.com>
messenger :suhredayan@hotmail.com
|
|
|
|
|
Suhredayan P wrote:
servicepack is a cumulative fixes for known bugs and problems.
so microsoft is still fixing bugs in VC6 
MSN Messenger.
prakashnadar@msn.com
Tip of the day of visual C++ IDE.
"We use it before you do! Visual C++ was developed using Visual C++"
|
|
|
|
|
Well, SP5 is not that old. It's safe to say that they would only be concerned with critical issues (e.g., security, data integrity) at this point.
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
|
|
|
|
|
Mr.Prakash wrote:
so microsoft is still fixing bugs in VC6
Nope, they barely support it anymore, as articles keep disappearing from MSDN. VS6SP5 was the last service pack released, and there won't be any more. The PSDK, however, gets a facelift every once in a while, and adds a huge list of functionality missing from the libraries shipped with VS6. Get both.
[EDIT]
I just scrolled down and discovered that SP6 was released yesterday. Yippee! Downloading now...
[/EDIT]
Will Build Nuclear Missile For Food - No Target Too Small
|
|
|
|
|
Uh oh, the service pack contains a few VSS related fixes only. 
<edit>
Ah, it's VSS SP6, not VC++ SP6. That would explain it!
</edit>
/ravi
My new year's resolution: 2048 x 1536
Home | Articles | Freeware | Music
ravib@ravib.com
|
|
|
|
|
Now that's confusing. You're right, the trail leads to a vss6sp6enu download from one path, but to vs6sp6 from another. The latter is 62MB, and is recommended for anyone using VC++6 with VSS, or VB6. I can't believe the fixes for VSS take up 62MB! Usually I like to check what fixes are included in a download, but the documentation links lead only to info about the VSS SP, not the one I just downloaded. Oh well, if it follows tradition there will be about 42 separate README files after I extract it. That should keep me entertained for a while.
Will Build Nuclear Missile For Food - No Target Too Small
|
|
|
|
|
i was pegging away at the keyboard and accidently wrote something like this
int i;
int j=0;
CRect rc;
rc.left = j,i;
(notice the , between j and i)
compiler shows no errors or warnings 
VC6, No service Packs
never seen or heard anything about this before
C makes it easy to shoot yourself in the foot; C++ makes it harder, but when you do, it blows away your whole leg
|
|
|
|
|
mailMonty wrote:
(notice the , between j and i)
compiler shows no errors or warnings
Hey, that ',' is the comma-operator, and you did use it in a syntactically correct way. About what sould the compiler complain?
"We trained hard, but it seemed that every time we were beginning to form up into teams we would be reorganised. I was to learn later in life that we tend to meet any new situation by reorganising: and a wonderful method it can be for creating the illusion of progress, while producing confusion, inefficiency and demoralisation."
-- Caius Petronius, Roman Consul, 66 A.D.
|
|
|
|
|
jhwurmbach wrote:
that ',' is the comma-operator, and you did use it in a syntactically correct way
how is this syntactically correct? 
C makes it easy to shoot yourself in the foot; C++ makes it harder, but when you do, it blows away your whole leg
|
|
|
|
|
mailMonty wrote:
how is this syntactically correct?
You are invoking the comma operator, basically returning only the value of the rightmost expression.
Consider this:
int i = 9;
int j=0;
int rc;
rc = j,i;
After this code fragment, rc has a value of 9.
A brief description is here[^], but google will give you any number of examples.
"We trained hard, but it seemed that every time we were beginning to form up into teams we would be reorganised. I was to learn later in life that we tend to meet any new situation by reorganising: and a wonderful method it can be for creating the illusion of progress, while producing confusion, inefficiency and demoralisation."
-- Caius Petronius, Roman Consul, 66 A.D.
|
|
|
|
|
Thanks 
Learned something new today, this can be good interview material 
C makes it easy to shoot yourself in the foot; C++ makes it harder, but when you do, it blows away your whole leg
|
|
|
|
|
mailMonty wrote:
Learned something new today,
Me too;)
I only had a vague idea what the comma operator does. Doing the test program and the googeling was brushing up my knowledge.
But in reality, I would consider use of the comma operator be bad style.
"We trained hard, but it seemed that every time we were beginning to form up into teams we would be reorganised. I was to learn later in life that we tend to meet any new situation by reorganising: and a wonderful method it can be for creating the illusion of progress, while producing confusion, inefficiency and demoralisation."
-- Caius Petronius, Roman Consul, 66 A.D.
|
|
|
|
|
Another "strange" thing that I stumbled across a few years back was that any code preceeding the #include <stdafx.h> statement is ignored if precompiled headers are being used.
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
|
|
|
|
|
Hi,
I created a table 2*2 rows and columns and i want to change the TD elemeent of a cell to TH element(Table header). But as all the elements under the TABLE object is read only I could't succeed. Plz help me to replace the cell which is TD Element to TH element.Thanx in advance...
Lokesh.K
|
|
|
|
|
keshjesh@sify.com wrote:
I created a table 2*2 rows and columns
How did you create it? using vc++
keshjesh@sify.com wrote:
Plz help me to replace the cell which is TD Element to TH element.Thanx in advance...
Can't you frontpage or something ?
MSN Messenger.
prakashnadar@msn.com
Tip of the day of visual C++ IDE.
"We use it before you do! Visual C++ was developed using Visual C++"
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
