C / C++ / MFC

need help on generate report to excel

7-Jul-05 16:44

msnet wrote:
how to get r, g or b value from class CColorDialog

Does this help?

// Get the selected color from the CColorDialog.
CColorDialog dlg;
if (dlg.DoModal() == IDOK)
{
   COLORREF color = dlg.GetColor();
   TRACE("RGB value of the selected color - red = %u, 
      green = %u, blue = %u\n",
      GetRValue(color), GetGValue(color), GetBValue(color));
}

--
jlr
http://jlamas.blogspot.com/[^]

firebolt777-Jul-05 16:05

7-Jul-05 16:05

hi all.. I am working on a program using visual c++ that has a feature to generate reports in Excel format but I still confused how to do it. Can anybody help?
thx

Jose Lamas Rios7-Jul-05 17:09

7-Jul-05 17:09

Excel has an XML schema in which it can save/read spreadsheets. You can try saving a simple document as XML from Excel itself to see the way it looks, or you can obtain full documentation here:
Office 2003: XML Reference Schemas[^]

I suggest generating first an XML with just the needed data, and then using XSL transformations to convert it to any other format (including Excel's XML schema, but you might also convert it to an HTML page). That way you can separate the logic needed to obtain the data from the presentation format, which is better both in terms of ease of development and of maintenance. The transformation may be done in memory without actually saving an intermediate file.

Hope that helps,

--
jlr
http://jlamas.blogspot.com/[^]

firebolt777-Jul-05 20:03

7-Jul-05 20:03

but if I'm using this method...can the xls file be opened at Ms Excel XP or lower? Because as I know, only Ms Excel 2003 that support XML. Is there any object library that I can use?(I'm using visual c++ 6.0)
thx.

Jose Lamas Rios7-Jul-05 20:12

7-Jul-05 20:12

firebolt77 wrote:
but if I'm using this method...can the xls file be opened at Ms Excel XP or lower?

I have Office XP and Excel can save to XML. I don't know about previous versions, but try it yourself. Open an excel document, select File / Save As, and look at the available formats.

firebolt77 wrote:
Is there any object library that I can use?

I don't know, there might be; I didn't search.

--
jlr
http://jlamas.blogspot.com/[^]

firebolt777-Jul-05 20:25

7-Jul-05 20:25

thx..I've download the references schema..it very helpful. Can u give me some links that provide more examples about the references schema?
thx..

firebolt778-Jul-05 3:36

8-Jul-05 3:36

I've read the microsoft office schema, but it is very complex and I didn't understand. I even try to make an excel using xml by following the instruction from ms office schema, but it doesn't work. Can you give me some examples or maybe other links?
thx.

urxlnc0077-Jul-05 19:23

urxlnc007

7-Jul-05 19:23

i too worked for same thing in ur project, what i did is create
file in write mode in with Cool | :cool:

"filename.xls" by following right tabs and newlines bye..........

Satishvarma.E

firebolt777-Jul-05 21:36

Re: Help finding wmstub.lib

7-Jul-05 21:36

if I use this method, will the cell be resized automatically? Can I make a table(with lines) using this method?
thx..

Help finding wmstub.lib

Lan_Zer07-Jul-05 13:20

Lan_Zer0

7-Jul-05 13:20

Oi, I have searched long and hard for this .lib file, but to no avail. Do any of you know where I can find this on the internet or email me a copy? My email is lanoman97@yahoo.com, thanks.

I have run searches through google and msdn and read other message board topics. I have also d/l the windows media format sdk 9, only to learn that wmstub.lib is only availble in version 7, which of course I also cannot find.

I need this file for a current project I am working on involving directshow and combining the sample DVapp and Jukebox to create a progeam that can save video off a DV camera and then play it back. Well, thats the first step at least, any pointers in that area would be great too =oP

Thank you for your help,

Lan =o)

Christian Graus7-Jul-05 16:45

Christian Graus

7-Jul-05 16:45

The DirectShow SDK has been moved out of DX into the Platform SDK. Try updating your PSDK and see if you get it that way.

Christian Graus - Microsoft MVP - C++

getting a correct structure data

Ista7-Jul-05 12:40

Ista

7-Jul-05 12:40

SelectObject(hdc, font);
LPGLYPHMETRICSFLOAT pLPGLYPHMETRICSFLOAT = NULL;
ZeroMemory( &pLPGLYPHMETRICSFLOAT, sizeof(LPGLYPHMETRICSFLOAT));
DWORD hr=D3DXCreateText(m_pd3dDevice, //Device
hdc, //GDI Device Context
"Hello World", //Text
0.001f, //Maximum chordal deviation from true font outlines
0.4f, //Extrusion depth (along -Z axis)
&_pLetterMesh, //Mesh
NULL, //Adjacency information
pLPGLYPHMETRICSFLOAT); //GlyphMetrics

but I never get a valid glyph(pLPGLYPHMETRICSFLOAT) structure?

what am I doing wrong?

thanks,
Nick

I'm not an expert yet, but I play one at work. Yeah and here too.

Re: getting a correct structure data

ldaoust7-Jul-05 15:12

ldaoust

7-Jul-05 15:12

I am not a DX programmer, but I think it is because you are using a pointer to a structure instead of an actual structure.

try this (bolded text that changed):

GLYPHMETRICSFLOAT MyGLYPHMETRICSFLOAT;
ZeroMemory( &MyGLYPHMETRICSFLOAT, sizeof(GLYPHMETRICSFLOAT));
DWORD hr=D3DXCreateText(m_pd3dDevice, //Device
hdc, //GDI Device Context
"Hello World", //Text
0.001f, //Maximum chordal deviation from true font outlines
0.4f, //Extrusion depth (along -Z axis)
&_pLetterMesh, //Mesh
NULL, //Adjacency information
&MyGLYPHMETRICSFLOAT); //GlyphMetrics

Memory for my application

Ivan Cachicatari7-Jul-05 11:50

Ivan Cachicatari

7-Jul-05 11:50

Hi again,

How to get the allocate (or used) memory for current application ?

Thanks in advance.

Ivan Cachicatari Blog[^]
www.latindevelopers.com

Re: Memory for my application

David Crow7-Jul-05 13:25

David Crow

7-Jul-05 13:25

See here.

"Ideas are a dime a dozen. People who put them into action are priceless." - Unknown

CListCtrl problem

Ivan Cachicatari7-Jul-05 11:47

Ivan Cachicatari

7-Jul-05 11:47

Hi,

How to align the first column of the CListCtrl (report mode) to right.

Thanks in advance.

Ivan Cachicatari Blog[^]
www.latindevelopers.com

Re: CListCtrl problem

David Crow7-Jul-05 13:23

David Crow

7-Jul-05 13:23

Insert a temporary column. Insert the right-aligned column. Delete the temporary column.

I've made an article that shows how to do this in detail, but have not posted it yet.

"Ideas are a dime a dozen. People who put them into action are priceless." - Unknown

ticker tape with images

picazo7-Jul-05 11:26

picazo

7-Jul-05 11:26

Hello,

I have recently created a ticker tape which is used to display strings. It is a common single line ticker. The program currently reads in a file from which it takes in the dimensions, colors, speed, and position of the ticker as well as the string that it should display and the spacing between repetitions of the string.

I would like to write a new ticker however, which also reads the information from a file (preferably an xml file) which scrolls multiple lines at the same time, and which can also scroll images of approximate dimension: 140 X 110 pixels.

For example, it could look something like:

|----140px-------|
__ _______________________________________________________________
| | line1 line1 | |
| | line2 line2 line2 | |
110px | line3 line3 | IMAGE |
| | line4 line4 line4 | |
| | line5 line5 | |
_ |_____line6 line6 line6________________|________________|________

for a file that looked something like:

<ticker>
... <- indicates ticker properties

<item>
<text>line1 line1</text>
<text>line2 line2 line2</text>
<text>line3 line3</text>
<text>line4 line4 line4</text>
<text>line5 line5</text>
<text>line6 line6 line6</text>
</item>
<item>
<image>IMAGE</image>
</item>
</ticker>

where the number of 'text' tags nested in an 'item' tag is fixed (to some number, not necessarily 6) and there is only one 'image' tag per 'item' tag.
Also, another tag which specifies the spacing (pixels or time) between items should be specified in the ticker properties.

The problem is that since I am relatively new to the VS C++ (using .NET 2003), I don't really know how I would go about doing this.

If anyone has done a similar project, or could possibly guide me or help me with the code, it would be greatly appreciated.

Thanks in advance,

-----------------
Genaro

\\\|
_ _
@ @
_\\
--|
_/

Re: ticker tape with images

Jose Lamas Rios7-Jul-05 16:15

Re: ticker tape with images

7-Jul-05 16:15

picazo wrote:
The problem is that since I am relatively new to the VS C++ (using .NET 2003), I don't really know how I would go about doing this.

Any particular thing? It should be a matter of adjusting what you are already doing, no? Maybe if you post some code of what you are doing now with the single line ticker (just the portion where you have doubts, of course), it might be easier to guide you.

--
jlr
http://jlamas.blogspot.com/[^]

picazo8-Jul-05 3:32

picazo

8-Jul-05 3:32

Hello Jose,

First of all, thanks for the reply.

I forgot to mention in the original post that the code for the single-line, text-only ticker is written in VB and that I would very much prefer if the code for the new multi-line, text and image ticker was written in c++. This means that I can probably and would rather not reuse the old code.

As far as if there is anything in particular, sort of. Before, I was using a static label and scrolling it. However, with multiple lines, should I use a read-only multi-line text area or several static labels? And also, since I may have several "messages" (items with nested text), I would need several text areas, or image controls for the images. How do I make all of these areas scroll unanimously? Can I embbed them in another layer and make that layer scroll?

I hope my response was not too confusing.

Thanks a lot,

-----------------
Genaro

\\\|
_ _
@ @
_\\
--|
_/

Dialog as child of dialog

ldaoust7-Jul-05 11:23

ldaoust

7-Jul-05 11:23

I want to create a dialog that is a child of another dialog. This child dialog would have a title bar so I can move it around, but as a child it would be confined (cliped) within it's parent dialog.

I already tried the obvious way. Create a dialog, set type as Child, then create an object for this dialog and call the create method.

ex:

void CParentDialog::CreateChildDialog()
{
    m_ChildDialog.Create( IDD_CHILD, this );
}

What happens is that the dialog is there, but it is being drawn over by other controls in the parent dialog, and also I cannot click on it to activate it or move it around.

Louis.

Re: Dialog as child of dialog

ldaoust7-Jul-05 15:02

ldaoust

7-Jul-05 15:02

ok, i figured out all the settings to achieve what I want...

Basically, what was important, is that I had to set the WS_CLIPSIBLINGS window style to all child of the parent dialog.

case closed.

Automation question

Tom Wright7-Jul-05 11:19

Tom Wright

7-Jul-05 11:19

When the messagebox "Server busy" pops up from an autmation server what exactly does that mean? Busy in that it's processing something, busy in that it is in my event sink waiting to return or something else that I'm not aware of?

Thanks

Tom Wright
tawright915@yahoo.com

Re: Automation question

Jose Lamas Rios7-Jul-05 17:48