Excel et c++ [FAQ]

**kris1** · 22/04/2008, 11h40

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
#import "C:\Program Files\Microsoft Office\Office\MSO9.DLL"
#import "C:\Program Files\Fichiers communs\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB" no_namespace
#import "C:\Program Files\Microsoft Office\Office\EXCEL9.OLB"no_namespace
 
 
using namespace std;
 
int main()
{
// Initialize COM
CoInitialize(NULL);
try
{
Excel::_ApplicationPtr excel;
// Initialize Excel and make sure it's initialized
HRESULT hr = excel.CreateInstance(L"Excel.Application");
if(FAILED(hr))
{
char msg[1024] = {0};
sprintf(msg, "E: There was an error initializing Excel: %d", hr);
throw std::runtime_error(msg);
}
 
Excel::_WorkbookPtr workbook = excel->Workbooks->Add(static_cast<long>(Excel::xlWorksheet)); // Create the workbook
Excel::_WorksheetPtr worksheet = excel->ActiveSheet; // Get the active sheet
 
// This is how you put the values into the worksheet
worksheet->Range["A1"]->Value = "Hello"; // Set a value
 
worksheet->SaveAs("c:\\test.xls"); // Save it
workbook->Close(); // Close the workbook
excel->Quit(); // Quit excel
}
catch(_com_error &ce)
{
// Handle the error
}
CoUninitialize();

j'ai essayé d'utiliser ce code mais j'ai rencontré beaucoup de problemes au moment de la compilation :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
c:\documents and settings\administrateur\bureau\test\debug\mso9.tlh(931) : warning C4146: unary minus operator applied to unsigned type, result still unsigned
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(315) : error C2367: 'IFilter' : redefinition; different uuid specifiers
        c:\program files\microsoft visual studio\vc98\include\comdef.h(455) : see declaration of 'IFilter'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(535) : error C2367: 'Window' : redefinition; different uuid specifiers
        c:\documents and settings\administrateur\bureau\test\debug\vbe6ext.tlh(310) : see declaration of 'Window'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(537) : error C2367: 'Windows' : redefinition; different uuid specifiers
        c:\documents and settings\administrateur\bureau\test\debug\vbe6ext.tlh(33) : see declaration of 'Windows'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(567) : error C2367: 'AddIn' : redefinition; different uuid specifiers
        c:\documents and settings\administrateur\bureau\test\debug\vbe6ext.tlh(1499) : see declaration of 'AddIn'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(1257) : error C2371: 'WindowPtr' : redefinition; different basic types
        c:\documents and settings\administrateur\bureau\test\debug\vbe6ext.tlh(121) : see declaration of 'WindowPtr'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(1273) : error C2371: 'AddInPtr' : redefinition; different basic types
        c:\documents and settings\administrateur\bureau\test\debug\vbe6ext.tlh(149) : see declaration of 'AddInPtr'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(1334) : error C2923: '_com_IIID' : 'Rectangle' is invalid as template argument '#1', type expected
        c:\program files\microsoft visual studio\vc98\include\wingdi.h(3215) : see declaration of 'Rectangle'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(1338) : error C2923: '_com_IIID' : 'Arc' is invalid as template argument '#1', type expected
        c:\program files\microsoft visual studio\vc98\include\wingdi.h(2608) : see declaration of 'Arc'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : error C2039: 'MsoDiagramNodeType' : is not a member of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : error C2146: syntax error : missing ',' before identifier 'nodeType'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : error C2061: syntax error : identifier 'nodeType'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2616) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2616) : error C2146: syntax error : missing ',' before identifier 'nodeType'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2616) : error C2061: syntax error : identifier 'nodeType'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2630) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2631) : error C2504: '_IMsoDispObj' : base class undefined
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2645) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2645) : error C2146: syntax error : missing ';' before identifier 'Diagram'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2645) : error C2501: 'IMsoDiagramPtr' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2645) : error C2208: 'struct Diagram' : no members defined using this type
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2654) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2654) : error C2146: syntax error : missing ',' before identifier 'pos'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2654) : error C2061: syntax error : identifier 'pos'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2659) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2659) : error C2146: syntax error : missing ',' before identifier 'pos'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2659) : error C2061: syntax error : identifier 'pos'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2668) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2668) : error C2146: syntax error : missing ',' before identifier 'pos'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2668) : error C2061: syntax error : identifier 'pos'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2677) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2677) : error C2146: syntax error : missing ';' before identifier 'GetDiagram'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2677) : error C2501: 'IMsoDiagramPtr' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2678) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2678) : error C2146: syntax error : missing ';' before identifier 'GetLayout'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2680) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2680) : error C2146: syntax error : missing ',' before identifier 'pdgmType'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2680) : error C2061: syntax error : identifier 'pdgmType'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2688) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2688) : error C2146: syntax error : missing ',' before identifier 'pos'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2688) : error C2061: syntax error : identifier 'pos'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2694) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2694) : error C2146: syntax error : missing ',' before identifier 'pos'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2694) : error C2061: syntax error : identifier 'pos'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2703) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2703) : error C2146: syntax error : missing ',' before identifier 'pos'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2703) : error C2061: syntax error : identifier 'pos'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2720) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2720) : error C2011: 'Office' : 'enum' type redefinition
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2720) : error C2143: syntax error : missing ',' before '*'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2720) : error C2059: syntax error : '*'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2722) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2722) : error C2143: syntax error : missing ',' before '*'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2722) : error C2059: syntax error : '*'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2724) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2724) : error C2146: syntax error : missing ',' before identifier 'pdgmType'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2724) : error C2061: syntax error : identifier 'pdgmType'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5785) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5785) : error C2146: syntax error : missing ',' before identifier 'SyncEventType'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5785) : error C2061: syntax error : identifier 'SyncEventType'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5880) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5880) : error C2146: syntax error : missing ',' before identifier 'SyncEventType'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5880) : error C2061: syntax error : identifier 'SyncEventType'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5942) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5942) : error C2146: syntax error : missing ';' before identifier 'Assistant'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5942) : error C2501: 'AssistantPtr' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5942) : error C2501: 'Assistant' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5944) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5944) : error C2146: syntax error : missing ';' before identifier 'CommandBars'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5944) : error C2501: '_CommandBarsPtr' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5944) : error C2501: 'CommandBars' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5998) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5998) : error C2146: syntax error : missing ';' before identifier 'COMAddIns'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5998) : error C2501: 'COMAddInsPtr' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(5998) : error C2501: 'COMAddIns' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6008) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6008) : error C2146: syntax error : missing ';' before identifier 'LanguageSettings'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6008) : error C2501: 'LanguageSettingsPtr' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6008) : error C2501: 'LanguageSettings' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6012) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6012) : error C2146: syntax error : missing ';' before identifier 'AnswerWizard'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6012) : error C2501: 'AnswerWizardPtr' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6012) : error C2501: 'AnswerWizard' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6076) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6076) : error C2146: syntax error : missing ';' before identifier 'FileSearch'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6076) : error C2501: 'FileSearchPtr' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6076) : error C2501: 'FileSearch' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6078) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6078) : error C2146: syntax error : missing ';' before identifier 'FileFind'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6078) : error C2501: 'IFindPtr' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6078) : error C2501: 'FileFind' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6118) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6118) : error C2146: syntax error : missing ';' before identifier 'NewWorkbook'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6118) : error C2501: 'NewFilePtr' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6118) : error C2501: 'NewWorkbook' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6134) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6134) : error C2146: syntax error : missing ';' before identifier 'FileDialog'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6134) : error C2501: 'FileDialogPtr' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6134) : error C2501: 'FileDialog' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6324) : error C2027: use of undefined type 'Office'
        c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(2598) : see declaration of 'Office'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6324) : error C2146: syntax error : missing ';' before identifier 'GetAssistant'
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6324) : error C2501: 'AssistantPtr' : missing storage-class or type specifiers
c:\documents and settings\administrateur\bureau\test\debug\excel.tlh(6324) : fatal error C1003: error count exceeds 100; stopping compilation
Error executing cl.exe.
 
test.exe - 102 error(s), 1 warning(s)

**Médinoc** · 23/04/2008, 17h32

Essaie en supprimant les no_namespace.
Ensuite, tu pourra rajouter les using namespace pour corriger les autres erreurs...

Excel et c++ [FAQ]

MFC

Discussions similaires

Partager

Partager