Re: How to read a excel file without using microsoft office in mfc? - C / C++ / MFC Discussion Boards

thanh_bkhn30-Jun-13 20:53

30-Jun-13 20:53

Assume you have a HBITMAP hbitmap which already contains your clipboard data. Then you can StretchBlt that data to a destination HDC hdc as below:
1. Create a compatible HDC in memory with your destination hdc

HDC memDC= CreateCompatibleDC(hdc);

2. Select your hbitmap into the memory DC

HBITMAP hOldBmp = (HBITMAP)SelectObject(memDC, hbitmap);

3. Use StretchBlt to resize it

StretchBlt(hdc, 0, 0, new_Width, new_Height, memDC, 0, 0, org_Width, org_Height, SRCCOPY);

4. Restore the old bitmap and free memory

SelectObject(memDC, hOldBmp);
DeleteDC(memDC);

Hope it helps Smile | :)

Re: Resize bitmap from Clipborad?

JoneLe861-Jul-13 9:53

JoneLe86

1-Jul-13 9:53

Thanks it helped me Smile | :)

Re: Resize bitmap from Clipborad?

Jochen Arndt30-Jun-13 21:01

Jochen Arndt

30-Jun-13 21:01

You may use the CopyImage()[^] function:

C++

BITMAP bm;
GetObject(hBitmap, sizeof(bm), &bm);
HBITMAP hCopy = (HBITMAP)CopyImage(hBitmap, IMAGE_BITMAP, 
    bm.bmWidth / 2, bm.bmHeight / 2, 
    LR_COPYDELETEORG);
SetClipboardData(CF_BITMAP, hCopy);

Re: Resize bitmap from Clipborad?

JoneLe861-Jul-13 9:53

JoneLe86

1-Jul-13 9:53

Thanks I did not know that! Big Grin | :-D

gonna check that out

how to cal a single query in visual studio 2010 C++ instead of Stored procedure (Multiple queries)?

kart 230-Jun-13 3:01

kart 2

30-Jun-13 3:01

Can you guys pl explain me how to call (Syntax) a single query directly through visual studio C++ code and stored Procedures (syntax for multiple queries)? What is the difference between them in calling?

How to read a excel file without using microsoft office in mfc?

Le@rner28-Jun-13 22:34

Le@rner

28-Jun-13 22:34

hi all,

I want to read a excel file on pc where Office is not installed.

any idea how can I do this.

thanks.

Re: How to read a excel file without using microsoft office in mfc?

Richard MacCutchan28-Jun-13 23:14

Richard MacCutchan

28-Jun-13 23:14

You can use OLE DB[^].

Use the best guess

Re: How to read a excel file without using microsoft office in mfc?

Le@rner29-Jun-13 0:23

Le@rner

29-Jun-13 0:23

is oledb register on all pc.

I search on using excel and find this

http://exceldatareader.codeplex.com/[^]

they provide a dll.

but here example shows use in c# and vb.net how can I use it.

modified 29-Jun-13 6:29am.

Re: How to read a excel file without using microsoft office in mfc?

Richard MacCutchan29-Jun-13 0:56

Richard MacCutchan

29-Jun-13 0:56

Unfortunately it is not easy, as all the samples I have seen relate to C#/VB.NET. You could use C++/CLI to access the data and then hand it back to your unmanaged code. There are also some articles here on CodeProject[^] that may help you.

Use the best guess

C#,How to parse CSV file with RegularExpression

haha_c28-Jun-13 20:02

haha_c

28-Jun-13 20:02

Hi,I want to parse a csv file using Regex,It contains
1.string Contains "",for example,"It's a "word"" ;
2.string Conatains \r\n

Re: C#,How to parse CSV file with RegularExpression

CPallini28-Jun-13 22:25

CPallini

28-Jun-13 22:25

I would start choosing the right forum. Roll eyes | :rolleyes:

Veni, vidi, vici.

Re: C#,How to parse CSV file with RegularExpression

haha_c28-Jun-13 22:46

haha_c

28-Jun-13 22:46

What? I can not understand,sorry

Re: C#,How to parse CSV file with RegularExpression

CPallini28-Jun-13 22:52

CPallini

28-Jun-13 22:52

This is the C/C++/MFC forum, while you asked about C#.
As a side note, a quick Google search gave me about 830,000 results[^].

Veni, vidi, vici.

Re: C#,How to parse CSV file with RegularExpression

jschell29-Jun-13 11:43

jschell

29-Jun-13 11:43

You can google for that.

Also, if it matters, a parser is probably faster than a regex.

Re: C#,How to parse CSV file with RegularExpression

cooljun_61830-Jun-13 17:16

cooljun_618

30-Jun-13 17:16

you can post it at the c# forum Smile | :)

moonman

how to write UnitTest for a class derived from MFC class like CWinApp?

pk jain28-Jun-13 19:27

pk jain

28-Jun-13 19:27

Hi,

I need do wirte Unit-testing(Automated testing)code for our project. Some of the modules are developed in VC++(Using MFC).Its a Multiple Document Interface[MDI] application.

I tried to use CPPUnit framework ,but i'm getting difficulties. Also CPPUNIT don't have TestCoverage facility.

Hence kidly guide me how can i write test cases for pure MFC code. I mean the Unit testing code can handel MFC library & also the tool can able do the TestCoverage analysis.Any best & friendly Unit tesitng framework is avaialblle?

Kindly help me out. Thanks in advance Smile | :)

modified 30-Jun-13 1:04am.

Re: how to write UnitTest for a class derived from MFC class like CWinApp?

Stefan_Lang4-Jul-13 2:52

Stefan_Lang

4-Jul-13 2:52

Since nobody answered so far...

I've looked around some time ago, and found that almost all frameworks available for Windows require .NET, or at least managed C++. One of the few that doesn't is WinUnit: It requires some work for you (creating test classes for each class to test), but otherwise saves a lot of work by extracting the test cases directly from the binaries.

I haven't yet tried it out myself because it wasn't really what I required, but it may be useful for your purposes. Should be easy enuogh to google for, and IIRC the documentation even contains references of alternate solutions.

How to put checkboxes in any column of ListVIew Control in mfc.?

mbatra3127-Jun-13 20:14

mbatra31

27-Jun-13 20:14

Hi,

I have a list control on a dialog box. I use

LVS_EX_CHECKBOXES

functionality to put check boxes in the list control. I want to put the checkboxes in any other column of list control.

How it can be implemented.

Please share any sample code if you have.

Any help will be appreciated.

Regards,
Mbatra

Re: How to put checkboxes in any column of ListVIew Control in mfc.?

«_Superman_»27-Jun-13 20:48

«_Superman_»

27-Jun-13 20:48

These articles should be able to help you out -
XListCtrl - A custom-draw list control with subitem formatting[^]
CQuickList[^]

«_Superman_»
I love work. It gives me something to do between weekends.

Microsoft MVP (Visual C++) (October 2009 - September 2013)

Polymorphism in C

Re: How to put checkboxes in any column of ListVIew Control in mfc.?

_Flaviu27-Jun-13 21:14

_Flaviu

27-Jun-13 21:14

If you want to have a single column with checkboxes, you may rearrange the order of the columns, in such way to have checkboxes on the desired column ... Smile | :)

You can also check here[^], on this list you can put any kind of control, on any column ...

How to convert office to pdf with acrobat in VC++?

liuli778627-Jun-13 16:16

liuli7786

27-Jun-13 16:16

I hope someone can give me some proposal. I find the PDFMakerAPI.dll in acrobat. so i want to use the PDFMakerAPI.dll to convert in VC++.How to convert office to pdf with acrobat in VC++?

Re: How to convert office to pdf with acrobat in VC++?

Richard MacCutchan27-Jun-13 21:19

Richard MacCutchan

27-Jun-13 21:19

The first thing you need to do is study the documentation for the DLL.

Use the best guess

CreateProcess return code 1 however Process does not start

ForNow27-Jun-13 6:03

ForNow

27-Jun-13 6:03

Hi,

I am getting back a 1 from CreateProcess indicting success however the process never takes off

I can cann't find it in TaskManager Either

Here is the code this code used to work I just cleaned up my computer tried re-building the app

C++

strncpy(&herc_command[0],"HERC_CMD.EXE ",13);

         memset(&si,0,sizeof(si));
         si.cb= sizeof(si);



           sa.nLength =  sizeof(sa);
           sa.lpSecurityDescriptor = NULL;
           sa.bInheritHandle = TRUE;     // Hercmd will inherit this event

           hutil_module = GetModuleHandle("HENGINE");


          hercgui_addr = GetProcAddress(hutil_module,"hercgui_proc");

          if (hercgui_addr == NULL)
               errcd = GetLastError();

          strncpy(&herc_parm[0],&hercgui_addr,8);



       return_code = CreateProcess((LPCSTR) &herc_command[0],      // command
                                   (LPCSTR) &herc_parm[0],         // paramter
                                   (LPCSTR) &sa,
                                   NULL,
                                   TRUE,
                                   (DWORD) NULL,
                                   NULL,
                                   NULL,
                                   &si,
                                   &pi);

    if (return_code == 0 )
        errcd = GetLastError();

Re: CreateProcess return code 1 however Process does not start

Santhosh G_27-Jun-13 6:59

Santhosh G_

27-Jun-13 6:59

Please ensure the target is not started, by adding some log in that process. If process terminates as soon as the startup, then TaskManager cant show it.
Please check the values of returned PROCESS_INFORMATION structure. Process ID is avaialable in pi.dwProcessId.

return_code = CreateProcess((LPCSTR) &herc_command[0],      // command
                                  (LPCSTR) &herc_parm[0],         // paramter
                                  (LPCSTR) &sa,
                                  NULL,
                                  TRUE,
                                  (DWORD) NULL,
                                  NULL,
                                  NULL,
                                  &si,
                                  &pi);

Is third parameter is correct? Conversion to a string is not correct.

Re: CreateProcess return code 1 however Process does not start

ForNow27-Jun-13 8:15

ForNow

27-Jun-13 8:15

I run the code under the debugger in VS
2010

In the child process
I have a __debugbreak at the beginning of the code
Ill move it up to CWinApp::InitInstance as that would seem close to the first piece of code being executed

Thanks

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