Read and Write to Microsoft Excel which support .xlsx format. - C / C++ / MFC Discussion Boards

First Prev Next

Re: How to avoid a Global Variable

C^hris L^osinger30-Jul-09 5:12

C^hris L^osinger

30-Jul-09 5:12

something like this ?

void CMyView::SomeFunc()
{
   CMyDialog dlg;

   if (dlg.DoModal() == IDOK)
   {
       m_myVar = dlg.m_editVar;
   }
}

image processing toolkits | batch image processing

Re: How to avoid a Global Variable

Rick York30-Jul-09 6:07

Rick York

30-Jul-09 6:07

You can also pass the old value to its constructor as the initial value and make a "Get" method in the dialog class to return the new value.

Re: How to avoid a Global Variable

Madhu_Rani30-Jul-09 20:04

Madhu_Rani

30-Jul-09 20:04

THANKS both of you.

Re: How to avoid a Global Variable

Madhu_Rani30-Jul-09 20:36

Madhu_Rani

30-Jul-09 20:36

void CMyView::SomeFunc()
{
CMyDialog dlg;
if (dlg.DoModal() == IDOK)
{
m_myVar = dlg.m_editVar;
}
}

This works fine for OK button but does not work for other buttons such as Connect having id IDCONNECT... any idea why?

if (dlg.DoModal()==IDCONNECT)
{// does not work
}

fwrite for unicode characters...

Rakesh530-Jul-09 1:57

Rakesh5

30-Jul-09 1:57

Hi all,

I am making my application unicode supporting one. i am using visual studio 2008.

when i try to write texts available as columns in my application in to a file using fwrite function, i am getting values like this..

239††††††††먠몭몭몭몭 test†††††††††††††††††††먠몭몭몭몭몭몭몭몭몭".. actually my column values are "239 test".

Can anyone help me why this is coming and how to get rid of this?

Code Snippet:
fwrite(Currentrow, Currentrow.GetLength()1, f) where Currentrow is CString...

Please let me know if am unclear...

Thanks,
Rakesh.

Re: fwrite for unicode characters...

Rajesh R Subramanian30-Jul-09 2:35

Rajesh R Subramanian

30-Jul-09 2:35

First thing is: If you're using MFC, why not use the CFile class instead?

It is a crappy thing, but it's life -^ Carlo Pallini

CMFCPropertyGridCtrl column width

eight30-Jul-09 1:32

eight

30-Jul-09 1:32

Hi,

Is there a way to programmatically change the column width of CMFCPropertyGridCtrl?

Read and Write to Microsoft Excel which support .xlsx format.

Le@rner29-Jul-09 21:41

Le@rner

29-Jul-09 21:41

Hi all,

I want to Read and Write to Microsoft Excel with xls and xlsx format.

i have read an article which works fine but its not support XLSX files.

BasicExcel - A Class to Read and Write to Microsoft Excel[^]

i want to read and write xlsx type files also.

please help me for this.

provide me any guidance and any example for xlsx files.

thanks in advance.

To accomplish great things, we must not only act, but also dream;
not only plan, but also believe.

Re: Read and Write to Microsoft Excel which support .xlsx format.

Adam Roderick J29-Jul-09 22:53

Adam Roderick J

29-Jul-09 22:53

did u tried this one?
Reading Excel files using ODBC[^]

Величие не Бога может быть недооценена.

Re: Read and Write to Microsoft Excel which support .xlsx format.

Le@rner30-Jul-09 0:16

Le@rner

30-Jul-09 0:16

I dont want to use any database or ODBC,please suggest me any other option for this.

thanks in advance.

To accomplish great things, we must not only act, but also dream;
not only plan, but also believe.

Re: Read and Write to Microsoft Excel which support .xlsx format.

Adam Roderick J30-Jul-09 0:28

Adam Roderick J

30-Jul-09 0:28

hope this may be helpful to you Smile | :)

http://support.microsoft.com/default.aspx?scid=kb;en-us;178782[^]

Величие не Бога может быть недооценена.

Re: Read and Write to Microsoft Excel which support .xlsx format.

Rajesh R Subramanian30-Jul-09 0:50

Rajesh R Subramanian

30-Jul-09 0:50

"_$h@nky_" wrote:
i have read an article which works fine but its not support XLSX files.

XLSX follows an entirely different format[^]. So, you shouldn't expect BasicExcel to work with Excel 2007.

"_$h@nky_" wrote:
provide me any guidance and any example for xlsx files.

See if How to automate Excel from C++ without using MFC or #import[^] helps you.

It is a crappy thing, but it's life -^ Carlo Pallini

Re: Read and Write to Microsoft Excel which support .xlsx format.

Dmytro Skrypnyk25-Aug-10 23:14

Dmytro Skrypnyk

25-Aug-10 23:14

This library http://www.libxl.com can read and write xls and xlsx formats directly. Perhaps it will be solution for you.

Using Opengl in Visual C++ Windows Form Application.

emira6729-Jul-09 21:21

emira67

29-Jul-09 21:21

Hello,

I'm new in OpenGl Library.I'm trying to learn Opengl to use it in Visual C++ Windows Form Application .

I can't work application in here:Creating an OpenGL view on a Windows Form[^]I can build it.But never debugging in Visual Stduio 2008.Where can I change in this code?

Another problem of mine.How can I use Opengl in PictureBox toolbox in Visual Studio 2008.I didn't come across any document on internet.Do you know any document,tutorial,code example etc. about this topic?

Could you help me please?

reading & displaying bitmap image

adichavan29-Jul-09 21:03

adichavan

29-Jul-09 21:03

hiiiiiiiiiiiiiiii i want to read & display bitmap image using c.plz help me uptilnow i open the image ,read it ,mesure its width , hight, type etc but I cant put it in the form of array iwant to display array o image as well as i/p image also so plz help me.

Re: reading & displaying bitmap image

CPallini29-Jul-09 22:45

CPallini

29-Jul-09 22:45

See, for instance [^].
Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke

[My articles]

Set Database Password with MFC DAO

sunny_vc29-Jul-09 20:10

sunny_vc

29-Jul-09 20:10

Hi ,
I am working on Access data base using MFC DAO classes.
Can I set/change the password of the data base programmatically.?
If yes please give me an idea.

Regards,
Sunil Kumar

Outlook Folder

john563229-Jul-09 20:00

john5632

29-Jul-09 20:00

Hi,

I have traverse all folder of Outlook in c# but not able to do same in c++.

please guide to do that.

Code is here

foreach (Microsoft.Office.Interop.Outlook.MAPIFolder folder in start)
{
                  node = node.Nodes.Add(folder.Name);

                   Microsoft.Office.Interop.Outlook.MAPIFolder found = TraverseTee(folder.Folders, name, bBuildTree, node);

                   node = node.Parent;

}

Re: Outlook Folder

Adam Roderick J29-Jul-09 20:21

Adam Roderick J

29-Jul-09 20:21

CFileFind can be called recursively to do the same

Величие не Бога может быть недооценена.

Re: Outlook Folder

john563229-Jul-09 20:41

john5632

29-Jul-09 20:41

CFindFile traverse file but I want to traverse folder from outlook.
If this can happen with with please give any idea with code.

Re: Outlook Folder