|
HI ,
I have a Data in ListBox in a Dialog .. build in VC++.
I want to Copy this data to MS Excel .. columns and rows
How can i Do it , / wt is the way to do it .
any Example etc.
thanx
Regards.
|
|
|
|
|
The easiest way is to save the data to a .csv file. A simple text file where every row is a line of text and every column is seperated by commas. Excel can read .csv files to import the data.
If you want to get more difficult, you can search this site for "excel" and you will get articles on reading and writing excel files using ODBC, ADO, COM, etc.
"You're obviously a superstar." - Christian Graus about me - 12 Feb '03
"Obviously ??? You're definitely a superstar!!!" mYkel - 21 Jun '04
Within you lies the power for good - Use it!
Honoured as one of The Most Helpful Members of 2004
|
|
|
|
|
thanx,
I think The way you told is to save the data to a .csv file . and Excel will import it,
But i want to Paste a data in Excel sheet just as we can do by Cut / Copy and Paste.
Copy it from a CList Control and paste in Excel sheet.
How can i do it ?
Thanx for your first response.
Regards.
|
|
|
|
|
From Microsoft Excel Help
[quote]
The format of information pasted from the Clipboard
How pasted information appears in a document Information you cut or copy to another program is pasted, if possible, in a format that the program can edit. For example, cells from Microsoft Excel worksheets and records from Microsoft Access are pasted into Word as Word tables, complete with column widths and font formatting. Text separated by tab characters from Word is pasted into Microsoft Excel in rows and columns of cells, and records from Microsoft Access are pasted into a Microsoft Excel worksheet as rows with each field in a separate column.
If a program can't edit the information, it inserts it as an embedded object, which you can edit in the source program by double-clicking the object. If the information can't be inserted as an embedded object — for example, you're copying the information from a program that does not support OLE, the information is pasted as a static picture that cannot be edited.
How to format pasted information To control the format of information pasted from the Clipboard, use the Paste Special command (Edit menu) instead of Paste
[/quote]
"You're obviously a superstar." - Christian Graus about me - 12 Feb '03
"Obviously ??? You're definitely a superstar!!!" mYkel - 21 Jun '04
Within you lies the power for good - Use it!
Honoured as one of The Most Helpful Members of 2004
|
|
|
|
|
hi !
i'm looking for an article which explain how to extract an audio file from an avi file
someone can help me ? plz
thx
|
|
|
|
|
You need to download the directX9.0 SDK. It has documentation in their for all such things. Specifically look up Directshow, there is an example program called "playwnd" or you may be able to download it seperately. It has code in there for play back video streams, and audio.
But you will need to read the directshow info from the help to understand how to use it. Once you do though its dead easy to create complex multimedia apps.
|
|
|
|
|
Hello, I have a serious problem because i'm programming a application that connect 2 computers and the first computer send to the second the user of windows and de user of the device that is plug in and the other computer authentificate my id's with a OK, but i don't know how can i send the user of windows and the id of the device and the other computer can understand this information. If somebody can help me, thank you very much.
|
|
|
|
|
|
Thanks for this article, but i'm not sure yet because i know how can i send and reciev datas like in this example but i don't know how can i get the id of the device and the id user of windows and send together to the server and the server will check if it's correct because the server has to check that the user session has this id device and if it has it, then it's correct and the server send ok.
I don't know how can hel me this article, but thank you very much, but you have some ideas?.
Thanks
|
|
|
|
|
Hi,
I have following question.
I have created Dialog based application. Now I 'd like to add a chart to the same dialog (simple chart with x and y axis -maybe sth like there is in Windows Task Menager). Is this possible to do in mfc?
Sorry for my English if I made any mistakes :/
|
|
|
|
|
There are two ways to handle it. Either you paint the dialog box yourself or use some ActiveX control like the one provided by Microsoft. I think better option is to use the one provided by MS. Right-click on dialog and click InsertControl... This will show you all the registered controls on your system. Use Microsoft Chart Control and this will ease your task.
"Aerodynamically, the bumble bee shouldn't be able to fly, but the
bumble bee doesn't know it so it goes on flying anyway." - Mary Kay Ash
My Articles
|
|
|
|
|
|
Hi all
I finished my program. Now I want to know rate of functions in the program. Anybody have a free tools for that ? thank alot.
quang
|
|
|
|
|
caoquang wrote:
...rate of functions...
What is this? Are you wanting to profile your program to find where the bottlenecks are?
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
|
|
|
|
|
|
|
Hi rbid!
I'm very thank you for your indication !
hanhquang
|
|
|
|
|
i have a program that displays a lot of images.....these images are needed each time the rpogram runz.....but if i were to put these picturez in my exe(that is in the resourse) the exe getz huge.....i dont want it that way.....so iz there anyway i can do that by using dll(ps:i have no knowledge abt working with dllz).....
can anyone get me ideaz here??.....
cheerz.....
"faith, hope, love remain, these three.....; but the greatest of these is love" -1 Corinthians 13:13
|
|
|
|
|
Yes, you can move the images to a DLL but then doesn't that DLL become huge, too? You'd also have an extra file to ship. Why does a large EXE bother you?
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
|
|
|
|
|
You might also consider using some form of file compression on the images and then expand them into memory. I have seen VERY large bitmaps compress down to much smaller sizes. You can store the compressed images as RC_DATA and then load them from the resources, then expand them into memory. That would save you some space.
|
|
|
|
|
Hi all.
I've written a Visual C++ 6.0 software to calculate the Italian (Codice Fiscale) say that it is like U.S. SSN.
To calculate the C.F. (Codice Fiscale) i use a text file, comma delimited, to find City codes; it works fine.
Now I wander if is possible to embed the text file in the executable to have a compact software made of only one file. Condider that the text file is 247Kb
Thanks to all
|
|
|
|
|
See here.
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
|
|
|
|
|
im study com current, so i m diffculty understand that ,,,,i use visual studio 6.0,,
so i see build error ......Unreserved symbol error,,,,
what i to use com ? library need? i m inclueded all includ file
|
|
|
|
|
|
Please give me some articles or books or sourcecodes.
Thanks!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
