Exporting data to Excel worksheet - C / C++ / MFC Discussion Boards

Re: html-based modless Windeow

meinhard_risch9-Feb-06 10:48

meinhard_risch

9-Feb-06 10:48

thanks for all, it works fine !! Smile | :)

Audio audition with WMP?

Jim A. Johnson4-Feb-06 6:11

Jim A. Johnson

4-Feb-06 6:11

I have written a simple audio player that uses MCI to audition audio files from a Windows file dialog, as well as from our own graphic UI.

Unfortunately, since writing it we have learned that MCI does not support several audio file types, notably 24-bit files.

We'd like to rewrite the class to use WMP, but documentation for that technology is hard to find.

Can anyone recommend a way to use WMP to implement the following interface?

class AudioPlayer
{
public:
AudioPlayer();
~AudioPlayer();

void OpenFile(const tstring& strFileName);
void CloseFile();
const tstring& GetFileName() const;

void Play();
void Stop();
bool IsPlaying() const;
bool CanPlay() const;
};

Re: Audio audition with WMP?

EXTEIDE4-Feb-06 8:52

EXTEIDE

4-Feb-06 8:52

How about using directx sound class or directshow?

Refer below,
http://www.codeproject.com/audio/[^]

http://www.codeproject.com/audio/cwaveform.asp[^]

Enjoy Rose | [Rose]

Anderson Sheen (exteide@gmail.com)
The Extension IDE: http://www.exteide.com

-- modified at 14:53 Saturday 4th February, 2006

Video Setting

Hamid_RT4-Feb-06 3:50

Hamid_RT

4-Feb-06 3:50

Hello programmer's
I need to help
How to change MCI_DGV_SETVIDEO_BRIGHTNESS in the MCI_SETVIDEO
I Can't use this parameter it's not response to Value
Thanks for answer

How To Add Menu To Program ? ? ?

Morfix4-Feb-06 3:00

Morfix

4-Feb-06 3:00

Hi...

I'm an administrator in a big network,
i Have made a small app in vb that manages the ip address in the network (it gives u free ip by selecting the desired segment, show reports and etc...)
i wanna integrate this app into active directory so when someone adding new computer he can also get a new ip quickly for this computer.

is there any way that i can add a menu into the menu bar in "active directory users and desktops"?
or if any1 have other idea how i can integrate this app into active directory.

thanks a lot
and sorry about my crappy english.

Re: How To Add Menu To Program ? ? ?

Stephen Hewitt4-Feb-06 4:15

Stephen Hewitt

4-Feb-06 4:15

To a VB program?

Steve

Re: How To Add Menu To Program ? ? ?

Morfix4-Feb-06 7:36

Morfix

4-Feb-06 7:36

no...

i wrote a program in vb.
now i want to integrate this program into a compiled exe.
let's say i wanna add a new menu to notepad.exe menu bar.

is this possible?

Exporting data to Excel worksheet

ddmcr4-Feb-06 1:22

ddmcr

4-Feb-06 1:22

Hello guys,

Consider I have some text data(maybe a Microsoft Access database *.mdb file

too), and I want to save them as Microsoft Excel file.

How can I achieve that ?

thanks.

PS. I have MFC Dialog based Application

"Success is the ability to go from one failure to another with no loss of enthusiasm." - W.Churchill

-- modified at 9:25 Saturday 4th February, 2006

Re: Exporting data to Excel worksheet

Stephen Hewitt4-Feb-06 1:29

Stephen Hewitt

4-Feb-06 1:29

I haven't actually tried this, but you might be able use Microsoft's ODBC driver for Excel[^].

Steve

Re: Exporting data to Excel worksheet

Graham Shanks4-Feb-06 12:47

Graham Shanks

4-Feb-06 12:47

You might want to save the data in Comma Separated Variable (csv) format. Excel can open csv format files directly. For instance:

int value1 = 20;
int value2 = 32;
float value3 = 10.3f;
FILE* myFile;
myFile = fopen("c:\\temp\\foo.csv", "wt");
if(myFile)
{
  fprintf(myFile, "%d, %d, %.1f\n", value1, value2, value3);
}
fclose(myFile);

Graham

Re: Exporting data to Excel worksheet

ddmcr4-Feb-06 23:36

ddmcr

4-Feb-06 23:36

thanks Graham.

"Success is the ability to go from one failure to another with no loss of enthusiasm." - W.Churchill

Re: Exporting data to Excel worksheet

meinhard_risch5-Feb-06 3:53

meinhard_risch

5-Feb-06 3:53

I use this one since a long time. You're able to modify it like you want.

http://www.codeproject.com/printing/testexcel.asp

Re: Exporting data to Excel worksheet

ddmcr5-Feb-06 4:05

ddmcr

5-Feb-06 4:05

meinhard_risch wrote:
http://www.codeproject.com/printing/testexcel.asp

Good link, thanks Smile | :)

"Success is the ability to go from one failure to another with no loss of enthusiasm." - W.Churchill

How can I convert a CString variable to float

mikobi3-Feb-06 23:30

mikobi

3-Feb-06 23:30

Suppose that I have a CString variable inside it there is a float,
How can I affect this value to a variable float:

Ex

CString varstr("1258.59");
float varfloat;

How to affect 1258.59 in varfloat ?

I learn my self

Re: How can I convert a CString variable to float

Stephen Hewitt3-Feb-06 23:45

Stephen Hewitt

3-Feb-06 23:45

One way would be the following:
double dval = _tstof(varstr);

You'll need to make sure <tchar.h> is included.

Steve

Re: How can I convert a CString variable to float

Michael Dunn4-Feb-06 2:12

Michael Dunn

4-Feb-06 2:12

See the FAQ
6.3 How can I change a number into its string representation, or vice versa?[^]

--Mike--
Visual C++ MVP Cool | :cool:

LINKS~! Ericahist | NEW!! PimpFish | CP SearchBar v3.0 | C++ Forum FAQ

Re: How can I convert a CString variable to float

ThatsAlok4-Feb-06 5:09

ThatsAlok

4-Feb-06 5:09

try strtod or neutral _tcstod

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow

cheers, Alok Gupta VC Forum Q&A :- I/ IV

HELP!!!!!! error C2664

Rob2183-Feb-06 22:33

Rob218

3-Feb-06 22:33

Hey everyone.

I keep getting this error while using Visual C++ 2005 Express Edition, does anyone know how to fix this?

Error 1 error C2664: 'MessageBoxW' : cannot convert parameter 2 from 'const char [15]' to 'LPCWSTR' d:\my documents\visual studio 2005\projects\hello-win32\hello-win32\page1.cpp 17

Thanks in Advance Big Grin | :-D

Re: HELP!!!!!! error C2664

Stephen Hewitt3-Feb-06 22:51

Stephen Hewitt

3-Feb-06 22:51

Wrap the strings in your MessageBox in the _T macro like this:
MessageBox(NULL, _T("Hello"), _T("Hello"), MB_OK);
If you get an error saying _T is not defined add #include <tchar.h> to your project (in the precompiled header would be the best).

Steve

Re: HELP!!!!!! error C2664

Gary R. Wheeler5-Feb-06 2:34

Gary R. Wheeler

5-Feb-06 2:34

It sounds like your program is set to compile for UNICODE, which implies that most Windows API functions that take strings expect UNICODE strings. The LPCWSTR in this case refers to a 'Long Pointer to Constant Wide-character STRing'.

The previous suggestion is correct; wrap your strings in the '_T("string")' macro call, which is #define'd in tchar.h. _T("string") evaluates to L"string" when compiling for UNICODE, and just "string" when compiling for MBCS.

Software Zen: delete this;

Fold With Us![^]

Adding dialog to sdi

swaapu3-Feb-06 21:58

swaapu

3-Feb-06 21:58

Hello!!
I am doing MFC programming after a very long time. I had forgot all the basic concepts.
I am working on an mfc sdi application. Could anybody tell me how to add a dialog to it.
I want the dialog to be displayd when i click on a specific menu item.
Thanx

"If you change then change for the good."

Re: Adding dialog to sdi

gan.gary3-Feb-06 22:44

gan.gary

3-Feb-06 22:44

I think by default, there willl be a "About" dialog box when u choose the mfc sdi application, right? Just add a dialog from the resource and see how it map the message then that's it!

simple WebSphere MQ.

jbu203-Feb-06 21:37

jbu20

3-Feb-06 21:37

i am looking on the net for a long time for an example code that shows how can i resolve Channel.

does anybody know?

thanks.

Re: simple WebSphere MQ.

jbu209-Feb-06 21:06

jbu20

9-Feb-06 21:06

can somebody help my please?

help for project

nima13633-Feb-06 20:46

nima1363

3-Feb-06 20:46

I have a problem with my project .My project is about socket programming with multiThread.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.