Re: Add data to existing excel file - C / C++ / MFC Discussion Boards

First Prev Next

Re: Hide and show Dialog Application

David Crow6-Nov-08 5:09

David Crow

6-Nov-08 5:09

Are you looking for something like this?

"Love people and use things, not love things and use people." - Unknown

"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch

Add data to existing excel file

hellogany5-Nov-08 19:52

hellogany

5-Nov-08 19:52

Hi ,
My application basically contains a text box.

Once user presses a button, the data from the text box, should be added to an excel file.

Data should be appended..

Any solutions?

Re: Add data to existing excel file

SandipG 5-Nov-08 20:06

SandipG

5-Nov-08 20:06

Does this[^] or this[^] help?

Regards,
Sandip.

Re: Add data to existing excel file

hellogany5-Nov-08 21:39

hellogany

5-Nov-08 21:39

Any other example
???

data should be added

Re: Add data to existing excel file

Iain Clarke, Warrior Programmer6-Nov-08 1:12

Iain Clarke, Warrior Programmer

6-Nov-08 1:12

Erm, added where? Any cell number? Any work sheet?
Will you set a cell format?
Do you process how many active cells in a column there are, so your numnber can be added?

There are many questions for you to work out, before you dive in to the examples another poster just gave you.

Programming is all about being the whiny paranoid 6 year old saying "why?" and "what if?" all the time.

Iain.

Re: Add data to existing excel file

David Crow6-Nov-08 5:10

David Crow

6-Nov-08 5:10

hellogany wrote:
Any solutions?

See here.

"Love people and use things, not love things and use people." - Unknown

"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch

Re: Add data to existing excel file

hellogany6-Nov-08 17:01

hellogany

6-Nov-08 17:01

Hi
i tired one ag in msdn

datas need to be appended...i.e data should be keep on adding.

But in the example, the old datas get erased

there is also one paramter Saveas. It keeps on asking whenevr i add a data
Data should be added with out asking the question

Is ther any solutions?

Re: Add data to existing excel file

David Crow7-Nov-08 2:33

David Crow

7-Nov-08 2:33

Unlike other data files where you open them, go to the end, and start writing, Excel files must be told where (i.e., what cell) to put the data. How are you doing this?

hellogany wrote:
It keeps on asking...with out asking the question

Huh?

hellogany wrote:
Is ther any solutions?

Not without seeing what you are currently doing.

"Love people and use things, not love things and use people." - Unknown

"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch

hide toolbar buttons progmmatically.

h@$@n5-Nov-08 19:34

h@$@n

5-Nov-08 19:34

hi i m using MFC

how i can hide specific button in a toolbar without creating any disturbance for other buttons.

please guide.

Thanks

destined to win

Displaying tooltip

ashtwin5-Nov-08 19:19

ashtwin

5-Nov-08 19:19

Hi,
i want to display a tooltip when the mouse pointer is over a specific part of window.
I am using the following code

if(IsResizable(ptHit))
			{
				//CRect boundingBox;
				//BOOL rval = TRUE;
				if (::IsWindow(mToolTip.GetSafeHwnd()))
				{
					mToolTip.UpdateTipText(_T("Resizing not possible"), this, 60000);
					mToolTip.Activate(TRUE);
				}
				else
				{
					BOOL rVal = TRUE;
					rVal = mToolTip.Create(this, TTS_ALWAYSTIP);
					if(rVal)
					{
	                    BOOL result = mToolTip.AddTool(this, _T("Resizing not possible"), CRect(100, 150, 200, 200), 60000);
						if(result)
						{
						  mToolTip.Activate(TRUE);
						}
					}
				}
			}

But the tooltip is not coming.

Thanks

Re: Displaying tooltip

Varghese Paul M5-Nov-08 23:44

Varghese Paul M

5-Nov-08 23:44

Call method EnableToolTips().
Capture message TTN_NEEDTEXT.
Add ON_NOTIFY_EX( TTN_NEEDTEXT, 0, OnToolTipNotify) in the message map and implement method OnToolTipNotify.

cheers
Varghese Paul

Re: Displaying tooltip

ashtwin17-Nov-08 21:29

ashtwin

17-Nov-08 21:29

Hi,
Thanks for replying. Actually it was my fault because the coordinates which i was using as boundry for tooltip were not correct.

Set Focus on Button Control.

Le@rner5-Nov-08 18:26

Le@rner

5-Nov-08 18:26

Hi all,

i have two diffrent buttons.

when keyboard use instead of mouse.

if i (press enter)clicked button 1 than focus set to the next button that is button 2.

i have use SetFocus() on Clicked event of button1,but its not done.

please tell me how can i do this.

thanks in advance.

IN A DAY, WHEN YOU DON'T COME ACROSS ANY PROBLEMS - YOU CAN BE SURE THAT YOU ARE TRAVELLING IN A WRONG PATH

Re: Set Focus on Button Control.

Varghese Paul M5-Nov-08 23:49

Varghese Paul M

5-Nov-08 23:49

Use GotoDlgCtrl() instead of SetFocus()

cheers
Varghese Paul

Re: Set Focus on Button Control.

Le@rner6-Nov-08 0:34

Le@rner

6-Nov-08 0:34

Thanks its done.

IN A DAY, WHEN YOU DON'T COME ACROSS ANY PROBLEMS - YOU CAN BE SURE THAT YOU ARE TRAVELLING IN A WRONG PATH

Bitmap Image Problem

ShilpiP5-Nov-08 18:23

ShilpiP

5-Nov-08 18:23

Hi All,
I am creating one application in which i want to convert text to image.I dont have any idea about it.Is their any API so that i convert that text to image.
Please Click This Link[^]

Thanks in Advance Smile | :)

Yes U Can ...If U Can ,Dream it , U can do it ...ICAN

Re: Bitmap Image Problem

Saurabh.Garg5-Nov-08 19:07

Saurabh.Garg

5-Nov-08 19:07

I believe you can use GDI to render the text to a window or a memory context and then save its contents as an image.

-Saurabh

Re: Bitmap Image Problem

ShilpiP5-Nov-08 19:21

ShilpiP

5-Nov-08 19:21

Thanks For your kind help Saurabh but i really dont have any idea about it. Can you please provide me any article or API so that it is easy for me to understand Smile | :)

Yes U Can ...If U Can ,Dream it , U can do it ...ICAN

Re: Bitmap Image Problem

Saurabh.Garg5-Nov-08 19:47

Saurabh.Garg

5-Nov-08 19:47

These are the function for drawing using GDI Font and Text Functions[^].

You can try to look up for memory DC and how to save it to a image.

-Saurabh

Re: Bitmap Image Problem

ShilpiP5-Nov-08 20:12

ShilpiP

5-Nov-08 20:12

Thank you so much Smile | :)

Yes U Can ...If U Can ,Dream it , U can do it ...ICAN

List View problem

trioum5-Nov-08 18:12

trioum

5-Nov-08 18:12

I am using listview in recordview with checkbox when I check and unchecked checkbox
of particular row then that row not selected.It only selected when I click
on that row item. so what I want that row should also get selected when I check and
uncheck the checkbox of the row. How It is possible???

Trioum

How to convert UNIT into wstring

CodingLover5-Nov-08 17:34

CodingLover

5-Nov-08 17:34

Hi all,

How can I convert an UINT into wstring.

Initially I convert it into CStringW, using Format(). But wstring there is no such thing. I want to avoid MFC here.

Any idea?

Thanks

I appreciate your help all the time...
CodingLover Smile | :)

Re: How to convert UNIT into wstring

Saurabh.Garg5-Nov-08 19:10

Saurabh.Garg

5-Nov-08 19:10

#include <sstream>

UINT i = 100;
std::wstringstream str;
str << i;
wstring s = str.str();

-Saurabh

Re: How to convert UNIT into wstring

CodingLover5-Nov-08 19:17

CodingLover

5-Nov-08 19:17

Thanks,

How about this way?

		<br />
wchar_t buf[8];<br />
wstring str(L"");<br />
_itow(12, buf, 10);<br />
str.append(buf);

Actually I want to do this for values from 0 to 31 only. So I think my buffer size is enough.

I appreciate your help all the time...
CodingLover Smile | :)

Re: How to convert UNIT into wstring

Saurabh.Garg5-Nov-08 19:38

Saurabh.Garg

5-Nov-08 19:38

Sure you can do this way but I will recommend using wstringstream. It is more general, you don't have to worry about buffer size.

-Saurabh

Last Visit: 31-Dec-99 18:00 Last Update: 8-Oct-24 8:27

Refresh

ᐊ Prev 1...3909 3910 3911 391239133914 3915 3916 3917 3918 Next ᐅ

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