|
hello,
i have excel from which i need to read the data.
Excel having groued columns so iam not able to read those columns.
can any one tell me how to un group excel column and save tht changed excel.
thnaks in advance.
|
|
|
|
|
What code did you try that failed?
|
|
|
|
|
private void UnGroupRowsAndColumns(Workbook workbook)
{
Worksheet worksheet = workbook.Worksheets[0];
worksheet.Cells.UngroupRows(0, 9);
worksheet.Cells.UngroupColumns(0, 1);
}
|
|
|
|
|
Hi all. I have a console application, running under Windows, that asks for a folder or directory and includes those files it supports and leave the rest. The following code is part of the definition of the function that does it:
....
....
char filePath[280] = {0};
....
....
strcat(filePath, "*.mp3");
....
....
The application searches the folder for files to add. The above code works when FindFirstFile() is called. But I want a way through which other file extensions (e.g. .wav., .wma, etc) can be included so that files with these other file extensions will be returned. I did something as follows, which I only guessed as I did not know how to do it, and it did not work:
strcat(filePath, "*.mp3;*.wav;*.wma");
When FindFirstFile() is called, it returns INVALID_HANDLE_VALUE;
I need help on how to solve this problem. Thanks.
|
|
|
|
|
There is no immediate support for what you want. The FindFirstFile API takes a single API, much like Windows Explorer lets you search for one thing at a time. The filter may contain wildcards, but does not support alternatives.
The obvious solution to such limitation is to have a loop, that iterates over your alternatives; so it would search all *.wav, then all *.wma, then... However it is up to you to add such loop.
There is one alternative that may or may not suit your app: you could relax the filter so all required files match, possibly yielding false positives, which you then have to skip by adding some tests. That could boil down to searching for *.*, then checking the extension is one of some. The disadvantage is you get a lot of matches; the advantage is the filesystem is searched only once.
|
|
|
|
|
I have used *.* but when I call FindFirstFile() for the first time, it returns the character '.', when it is called the second time, it returns '..', then subsequent calls return the files in the directory. Is there a way to prevent what the function returns for the first two calls? Then I will use a loop to check the file extensions.
|
|
|
|
|
AFAIK . and .. represent the current folder and the parent folder; if you get them (even when they don't really match your filter), AFAIK there is nothing you can do except test for them afterwards. The behavior of FindFirstFile may depend on your operating system and your file system. I tend to code defensively, and not to rely on observed behavior.
|
|
|
|
|
In a way to get rid of the '.' and "..", I have added the following code:
while (findData.cFileName[0] == '.' || findData.cFileName == "..")
{
FindNextFile(handle, &findData);
}
Although it's working, I don't know if it is efficient to do it like this. The loop is executed after FindFirstFile() has been called and its return value checked not to be INVALID_HANDLE_VALUE. When the loop breaks, the &findData has its member cFileName pointing to one of the files in the directory.
|
|
|
|
|
That sounds OK. You could create your own MyFindFirst() function that contains the original FindFirst call and your skip-loop, hiding all of it from the user.
|
|
|
|
|
Thanks very much for your guidance. I really appreciate your contributions.
|
|
|
|
|
You could also just check the attributes of the returned item in your findData structure and ignore entries with FILE_ATTRIBUTE_DIRECTORY set.
Also
while (findData.cFileName[0] == '.' || findData.cFileName == "..")
The second test will never pass, you cannot do a string compare in this way.
It's time for a new signature.
|
|
|
|
|
It is also redundant since the first test catches that condition also.
|
|
|
|
|
And catches any file or directory whose name starts with '.'.
It's time for a new signature.
|
|
|
|
|
What you have so far looks good enough.
There is an API called SHFileOperation that can take multiple wild cards.
But you cannot use this to find files.
You have to either copy or move or rename or delete the files.
I'm not sure what exactly your application does but if you can copy the files to a another folder or temp folder, this API may be helpful.
|
|
|
|
|
How to move windows titlebar (included buttons: Close & Minimize & Hide) to the left side ?
What I want to do is to move buttons to the DockablePane left side. I've created a derived class of CDockablePane.
Thanks,
|
|
|
|
|
One way could be to handle WM_NCPAINT[^] and WM_NCHITTEST[^] and draw and handle hit testing yourself (possibly using the themed drawing methods like DrawThemeEdge[^] and such for the drawing).
> The problem with computers is that they do what you tell them to do and not what you want them to do. <
> "It doesn't work, fix it" does not qualify as a bug report. <
> Amazing what new features none of the programmers working on the project ever heard of you can learn about when reading what the marketing guys wrote about it. <
|
|
|
|
|
Just overwrite it :
void CYourPane::SetCaptionButtons()
{
CDockablePane::SetCaptionButtons();
for (i = 0; i < m_arrButtons.GetSize(); i++) {
CMFCCaptionButton* pbtn = m_arrButtons[i];
if (pbtn) {
pbtn->m_bLeftAlign = TRUE;
}
}
}
virtual void BeHappy() = 0;
|
|
|
|
|
oo,I've tried your code,but it isn't the left of side, it is the window's left side.
|
|
|
|
|
|
I need better control of multiple windows opened in one MFC document / view.
Ideally I would like to be able to tile / cascade / select these windows in similar fashion as MFC main frame does. Anybody can point me to article / source code for such task?
I am not looking for multiple views connected to same document.
Any constructive help is as always appreciated.
Thank you for reading.
Vaclav
|
|
|
|
|
Are the views in the same frame window? If so, then you can use the MDICascade( ) method like standard MFC.
|
|
|
|
|
As ShanghaiDan said there are methods like CMDIFrameWnd::MDICascade and CMDIFrameWnd::MDITile that can do this for you.
There are also APIs called CascadeWindows and TileWindows that can do the same thing.
|
|
|
|
|
Thank you.
Both anwers are correct, however, I was looking for cascading windows and not views.
I need to use the API to do that.
Works as advertized in MSDN.
Vaclav
|
|
|
|
|
I have the following:
class Object
{
string data();
}myObj, *myObjPtr;
myObjPtr& GetObjPtr();
I would like to do the following:
myObjPtr& pTest = GetObjPtr();
string data1 = pTest->data();
That results in memory access violation. Is there a way to cast the myObjTtr& to myObjPtr ??
|
|
|
|
|
You're referencing a pointer, which is only confusing. Either reference the object, myObj&, or use pointers.
class Object
{
string data();
}myObj, *myObjPtr;
myObjPtr GetObjPtr();
I would like to do the following:
myObjPtr pTest = GetObjPtr();
string data1 = pTest->data();
This would work. With a reference, you need to ensure the object that is orignally referenced (in this case this is a pointer variable) is still in scope; in this case this is done inside your GetObjPtr() function so I can't see what is going wrong.
For your code, you should probably stick to pointers and forget references. Or, depending on the rest of your code, perhaps you could stick to references and forget about pointers.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
Sorry !