StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POEmbarcadero C++ builder Excel Automation C++ does not quit
primarykey
Id
11742897
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
7
CommunityOwnedDate
CreationDate
2012-07-31T14:53:06.760
FavoriteCount
1
LastActivityDate
2014-03-11T09:09:59.640
LastEditDate
2014-03-11T09:09:59.640
LastEditorUserId
3235496
OwnerUserId
1566019
ParentId
0
PostTypeId
1
Score
0
ViewCount
1290
LastEditorDisplayName
text
Body
I am trying to Automate Excel so that it generates a report on a server and then emails this to a user when requested. The problem I have is that once I have created an excel document and written the data into it, the program does not not quit even after issuing the pXL->Quit(); command. This is what my instructions for "closing" excel: <pre><code>pXL->Workbooks->Close(LCID(LOCALE_USER_DEFAULT)); pXLWSs.Reset(); //Releases Worksheets pXLWS.Reset();//Releases Workbooks pXL->Quit();// "Quits" Excel ---> This does not quit excel pXL.Reset();//Release Excel application? CoUninitialize();//Uninitialise COMS </code></pre> I have read quite a few articles and blog about this particular issue and it seems that this is because I am not freeing all the COMS associated with Excel. So I tried uninitialising COMS a few times. I issued the <pre><code>CoUninitialize(); </code></pre> 4 times and this worked! But to my disappointment, it does not work all the time. Does anyone know how to gracefully close Excel? I know Microsoft does not support server side Excel Automation but I was hoping to find a work around. I am also aware that you can simply <pre><code>WinExec("taskkill /F /IM \"excel.exe\"",0); </code></pre> which kills Excel altogether but I am worried about the future of the app when it will be generating quite a number of excel applications in which case I would have to kill Excel individually and it all just gets messy from there.... Any help would be much appreciated!
Tags
<c++><excel><automation><c++builder>
Title
Embarcadero C++ builder Excel Automation C++ does not quit
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USdRagonsRage
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POEmbarcadero C++ builder Excel Automation C++ does not quit
 UserUserId
 USdRagonsRage
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.