Re: Access to xlsx-format? - C / C++ / MFC Discussion Boards

Re: ifstream

FrankMookie3-Sep-08 5:05

FrankMookie

3-Sep-08 5:05

I did remove the declaration in progect properties.. but didn't work...
But thanks anyway for your help.

"Failure is always an option."

Re: ifstream

toxcct3-Sep-08 5:06

toxcct

3-Sep-08 5:06

yeah, after reading David's Answer, I figured out my mistake...

[VisualCalc][Binary Guide][CommDialogs] | [Forums Guidelines]

Re: ifstream

David Crow3-Sep-08 4:57

David Crow

3-Sep-08 4:57

FrankMookie wrote:
infile_file.open(filename);

Try:

infile_file.open(filename.c_str());

"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: ifstream

FrankMookie3-Sep-08 5:03

FrankMookie

3-Sep-08 5:03

it worked just fine withinfile_file.open(filename.c_str());. Thanks alot!

"Failure is always an option."

Problem with MFC ActiveX and Excel

AnTri3-Sep-08 3:34

AnTri

3-Sep-08 3:34

Hey,

i've written a simple ActiveX-Control which shows a Dialog (CDialog) with some CEdit Controls. All works fine in TestContainer, but when I us the control for e.g. in Excel (2003, 2007) i can't write text to my edit controls. All text is shows on my worksheet.
Help me please...

Access to xlsx-format?

Andy@3-Sep-08 3:34

Andy@

3-Sep-08 3:34

Hello,

i need to get data from an Excel sheet, which is saved as xlsx file.

Is it possible to access a xlsx file over CDaoDatabase and CDaoRecordset like the old xls excel files?

Thanks,
Andy

Re: Access to xlsx-format?

led mike3-Sep-08 4:27

led mike

3-Sep-08 4:27

Andy@ wrote:
Is it possible to access a xlsx file over CDaoDatabase and CDaoRecordset like the old xls excel files?

If the xlsx file is an XML file then probably not.

Do you have a C++ or MFC question?

led mike

Re: Access to xlsx-format?

Andy@3-Sep-08 20:16

Andy@

3-Sep-08 20:16

The code base i use is MFC, with a class that get the Data from the xls Excel format over the MFC classes CDaoDatabase and CDaoRecordset.
I wrote this some times ago. Now i need to handle the new format of xlsx files.

I thought that xlsx is always XML, but i´ve now opend the xlsx file with a hex editor and it seems to be a bin file.

I need a hint or a solution how i can get data from the xlsx file over MFC or Visual C++.

regards,
andy

Re: Access to xlsx-format?

led mike4-Sep-08 8:00

led mike

4-Sep-08 8:00

Andy@ wrote:
The code base i use is MFC, with a class that get the Data from the xls Excel format over the MFC classes CDaoDatabase and CDaoRecordset.
I wrote this some times ago. Now i need to handle the new format of xlsx files.

I don't know if DAO will work but here is some information about using OLEDB/ADO[^]

led mike

Re: Access to xlsx-format?

Andy@4-Sep-08 20:27

Andy@

4-Sep-08 20:27

thanks for the hint,
andy

Selecting an area with mouse From the screen

Nyil3-Sep-08 2:24

Nyil

3-Sep-08 2:24

My Requirement is .

When pressing the start button in My Dialog . the window is minimized.
then the user click and Drag on the screen.
after the drag operation i want to get the selected area.
the selected area is anywhere in the screen.

Also i want to indicate the user about his selection through a marking Rectangle while the Drag Operation.

i am tried the following code

m_bDragging = TRUE;
::SetCapture( ::GetDesktopWindow());

and Mapped the OnMouseMOve Function of my Dialog.
But it did not Work.

Can Anyone help me.

Re: Selecting an area with mouse From the screen

Sarath C3-Sep-08 5:09

Sarath C

3-Sep-08 5:09

Can you check this article to do mouse capture?

http://www.codeproject.com/KB/DLL/PasswordSPY.aspx

-Sarath.
"Great hopes make everything great possible" - Benjamin Franklin

My blog - Sharing My Thoughts, An Article - Understanding Statepattern

Re: Selecting an area with mouse From the screen

Mark Salsbery3-Sep-08 5:17

Mark Salsbery

3-Sep-08 5:17

You won't get any WM_MOUSEMOVE messages in your dialog if you've set
capture to another window.

Mark

Mark Salsbery
Microsoft MVP - Visual C++
Java | [Coffee]

Copy File

cpvc++3-Sep-08 2:00

cpvc++

3-Sep-08 2:00

Hi All

I want to copy file data from Source to destination.I have information about Source file path and Directory path.Can any one give me example. Plz help me

Re: Copy File

toxcct3-Sep-08 2:16

toxcct

3-Sep-08 2:16

what about using CopyFile() ?

[VisualCalc][Binary Guide][CommDialogs] | [Forums Guidelines]

Re: Copy File

sashoalm3-Sep-08 2:17

sashoalm

3-Sep-08 2:17

See here[^]

There is sufficient light for those who desire to see, and there is sufficient darkness for those of a contrary disposition.
Blaise Pascal

Re: Copy File

Sarath C3-Sep-08 2:19

Sarath C

3-Sep-08 2:19

You can use CopyFileEx[^] function

or you can use Shell API SHFileOperation[^]

See a Sample here

Re: Copy File

cpvc++3-Sep-08 2:23

cpvc++

3-Sep-08 2:23

Thx's for Responce..It's helping me..

But i need more information

My Source File Name is Store in String strFileName.

void OnCopy(const CString & strFileName)
{
m_listBox.AddString( _T("File Added: ") + strFileName);
CopyFile(strFileName, "C:\\New Text Document.txt",FALSE);

}

i want to do in this formate..

So plz help me..

Thx's in advance..

Re: Copy File

Sarath C3-Sep-08 2:35

Sarath C

3-Sep-08 2:35

Isn't it working? Any errors?

-Sarath.
"Great hopes make everything great possible" - Benjamin Franklin

My blog - Sharing My Thoughts, An Article - Understanding Statepattern

Re: Copy File

cpvc++3-Sep-08 2:45

cpvc++

3-Sep-08 2:45

No error at all but to Copy file..

Re: Copy File

cpvc++3-Sep-08 2:55

cpvc++

3-Sep-08 2:55

See one interseting point when i debug the code and fixed the break point on

(break)void OnCopy(const CString & strFileName)
	{
		m_listBox.AddString( _T("File Added: ") + strFileName);

		CString ap;
		ap=strFileName;
		

		CopyFile(ap, "C:\\New Text Document1.txt",FALSE);

	}

Then file data is copy.And when i run in simple then file data is not copy..

I cann't figure out why these thing is happen..

Plz help me

Re: Copy File

David Crow3-Sep-08 4:56

David Crow

3-Sep-08 4:56

cpvc++ wrote:
And when i run in simple then file data is not copy..

I cann't figure out why these thing is happen..

Any reason why you are not checking the return value of CopyFile()? What about calling GetLastError()?

"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: Copy File

David Crow3-Sep-08 4:54

David Crow

3-Sep-08 4:54

cpvc++ wrote:
But i need more information

Such as?

cpvc++ wrote:
i want to do in this formate..

What "format" are you referring to?

cpvc++ wrote:
So plz help me..

What exactly is the problem?

"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: Copy File

cpvc++3-Sep-08 18:20

cpvc++

3-Sep-08 18:20

Hello Sir

I am useing

DirectoryChanges

function.It's function return add and remove file/folder name.i want to copy data of these file(DirectoryChanges) which is add or remove.

Add and remove path store in CString

strFileName

. I am useing for source path name strFileName. And destination path is fixed(like c:\ or D:\). So plz help me how Can i copy the data..

Thx's in advance..

Re: Copy File

David Crow4-Sep-08 3:13

David Crow

4-Sep-08 3:13

cpvc++ wrote:
I am useing
DirectoryChanges

Do you mean ReadDirectoryChangesW()?

cpvc++ wrote:
Add and remove path store in CString

Check out PathRemoveFileSpec().

"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

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