Thread: [Dev-C++] EXCEL files as a datasource
Open Source C & C++ IDE for Windows
Brought to you by:
claplace
|
From: Louis G. <lg...@ya...> - 2003-01-07 22:12:33
|
I trying to use DEV C++ (and the built-in compiler of course) to access MS EXCEL files. The basic idea is to use an EXCEL file as a data source for my C++ code. Any one have any ideas or experience on this matter ? Is it an easy or complex thing to do ? Any help would be appreciated __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com |
|
From: Per W. <pw...@ia...> - 2003-01-07 23:51:22
|
Bad idea. Definitely complex. If you really, really, really have to, you can communicate with a running Excel application and send/receive data, but it isn't easy. And trying to read and/or write *.xls files are not something you want. If you need to share data between Excel and your program, it's easier to let Excel access the data from an alternative source. Export/import of comma-separated text files, storing data in an Access database etc. /Per W On Tue, 7 Jan 2003, Louis Godio wrote: > > I trying to use DEV C++ (and the built-in compiler of course) to access > MS EXCEL files. The basic idea is to use an EXCEL file as a data source > for my C++ code. > > Any one have any ideas or experience on this matter ? Is it an easy or > complex thing to do ? > > Any help would be appreciated > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > > > ------------------------------------------------------- > This SF.NET email is sponsored by: > SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! > http://www.vasoftware.com > _______________________________________________ > Dev-cpp-users mailing list > Dev...@li... > TO UNSUBSCRIBE: http://www.noicys.cjb.net/devcpp/ub.htm > https://lists.sourceforge.net/lists/listinfo/dev-cpp-users > |
|
From: Charles K. <ch...@ke...> - 2003-01-08 02:16:55
|
Why wouldnt' one talk to excel using COM ? ----- Original Message ----- From: "Per Westermark" <pw...@ia...> To: "Louis Godio" <lg...@ya...> Cc: "DEVCppUsers" <dev...@li...> Sent: Tuesday, January 07, 2003 6:50 PM Subject: Re: [Dev-C++] EXCEL files as a datasource > Bad idea. Definitely complex. > > If you really, really, really have to, you can communicate with a running > Excel application and send/receive data, but it isn't easy. And trying to > read and/or write *.xls files are not something you want. > > If you need to share data between Excel and your program, it's easier to > let Excel access the data from an alternative source. > > Export/import of comma-separated text files, storing data in an Access > database etc. > > /Per W > > On Tue, 7 Jan 2003, Louis Godio wrote: > > > > > I trying to use DEV C++ (and the built-in compiler of course) to access > > MS EXCEL files. The basic idea is to use an EXCEL file as a data source > > for my C++ code. > > > > Any one have any ideas or experience on this matter ? Is it an easy or > > complex thing to do ? > > > > Any help would be appreciated > > > > > > __________________________________________________ > > Do you Yahoo!? > > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > > http://mailplus.yahoo.com > > > > > > ------------------------------------------------------- > > This SF.NET email is sponsored by: > > SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! > > http://www.vasoftware.com > > _______________________________________________ > > Dev-cpp-users mailing list > > Dev...@li... > > TO UNSUBSCRIBE: http://www.noicys.cjb.net/devcpp/ub.htm > > https://lists.sourceforge.net/lists/listinfo/dev-cpp-users > > > > > > ------------------------------------------------------- > This SF.NET email is sponsored by: > SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! > http://www.vasoftware.com > _______________________________________________ > Dev-cpp-users mailing list > Dev...@li... > TO UNSUBSCRIBE: http://www.noicys.cjb.net/devcpp/ub.htm > https://lists.sourceforge.net/lists/listinfo/dev-cpp-users > > |
|
From: Per W. <pw...@ia...> - 2003-01-08 08:04:39
|
That's the 'talk with a running Excel application' alternative below, but it's still a lot of work. /Per W On Tue, 7 Jan 2003, Charles Kerr wrote: > Why wouldnt' one talk to excel using COM ? > > > ----- Original Message ----- > From: "Per Westermark" <pw...@ia...> > To: "Louis Godio" <lg...@ya...> > Cc: "DEVCppUsers" <dev...@li...> > Sent: Tuesday, January 07, 2003 6:50 PM > Subject: Re: [Dev-C++] EXCEL files as a datasource > > > > Bad idea. Definitely complex. > > > > If you really, really, really have to, you can communicate with a running > > Excel application and send/receive data, but it isn't easy. And trying to > > read and/or write *.xls files are not something you want. > > > > If you need to share data between Excel and your program, it's easier to > > let Excel access the data from an alternative source. > > > > Export/import of comma-separated text files, storing data in an Access > > database etc. > > > > /Per W > > > > On Tue, 7 Jan 2003, Louis Godio wrote: > > > > > > > > I trying to use DEV C++ (and the built-in compiler of course) to access > > > MS EXCEL files. The basic idea is to use an EXCEL file as a data > source > > > for my C++ code. > > > > > > Any one have any ideas or experience on this matter ? Is it an easy or > > > complex thing to do ? > > > > > > Any help would be appreciated > > > > > > > > > __________________________________________________ > > > Do you Yahoo!? > > > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > > > http://mailplus.yahoo.com > > > > > > > > > ------------------------------------------------------- > > > This SF.NET email is sponsored by: > > > SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! > > > http://www.vasoftware.com > > > _______________________________________________ > > > Dev-cpp-users mailing list > > > Dev...@li... > > > TO UNSUBSCRIBE: http://www.noicys.cjb.net/devcpp/ub.htm > > > https://lists.sourceforge.net/lists/listinfo/dev-cpp-users > > > > > > > > > > > ------------------------------------------------------- > > This SF.NET email is sponsored by: > > SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! > > http://www.vasoftware.com > > _______________________________________________ > > Dev-cpp-users mailing list > > Dev...@li... > > TO UNSUBSCRIBE: http://www.noicys.cjb.net/devcpp/ub.htm > > https://lists.sourceforge.net/lists/listinfo/dev-cpp-users > > > > > > > |
|
From: Teodorescu C. <te...@xt...> - 2003-01-08 10:58:39
|
Louis Godio wrote:
>I trying to use DEV C++ (and the built-in compiler of course) to access
>MS EXCEL files. The basic idea is to use an EXCEL file as a data source
>for my C++ code.
>
>Any one have any ideas or experience on this matter ? Is it an easy or
>complex thing to do ?
>
>
Ok 2 options :
1 : fun with exel com
2:(sugested) ODBC Driver for excel (simple and easy to use) ; also
you can access it via ado,oledb ...
Here is a link for VB but you'll find some tips forconnection string for
ado and a Q from microsoft ..
http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20240822.html
Hope i helped you.
teo.
|