I am saving my data in Excel File Format.
I am using CDataBase class and its methods like OpenEx ,ExecuteSQL etc. The program is working fine.
Now I need to change back-ground color of some data base records.
How to do this in MFC ?
I need to make a programm to write in a excel cell a number.
I must use OLE Automation. How i can do it??
Code:
#include "stdafx.h"
#include <stdio.h>
#include <windows.h>
#include <ole2.h>
#include <assert.h>
#include <iostream>
void main(void) {
CLSID clsid;
CLSIDFromProgID(L"Excel.Application", &clsid);
[Code] ....
I know how to change the back color of text in th ListView for all the View, but if I only want to change the back color of one cell i don`t find any way. Is it possible?
View 1 Replies View RelatedHere is what I did,
Code:
oldHook = ::SetWindowsHookEx(WH_CALLWNDPROCRET, CallWndRetProc, NULL, ::GetCurrentThreadId());
MessageBox(...);
UnhookWindowsHookEx(oldHook);
Then within the callback function CallWndRetProc, I tried to change the background color of the dialog,
Code:
PAINTSTRUCT ps;
HDC hdc = BeginPaint(msg->hwnd, &ps);
::SetBkColor(hdc, RGB(255, 0, 0));
EndPaint(msg->hwnd, &ps);
But it doesn't change the background color of the dialog. I wonder what is the right way to do that?
ON_WM_CTLCOLOR(...) works for all the other controls but not the tab control.
Code:
void CEasyWebStoreUploaderDlg::DoDataExchange(CDataExchange* pDX)
{
CDialogEx::DoDataExchange(pDX);
DDX_Control(pDX, IDC_TAB_CTRL, m_tabCtrl);
DDX_Text(pDX, IDC_EDIT_STATUS, m_strServerStatus);
DDX_Text(pDX, IDC_EDIT_UPLOAD_RESULTS, m_strUploadResults);
}
I have a derived CComboBox class, where I tried to change text and background of edit from CComboBox, just like this:
Code:
HBRUSH CMyComboBox::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) {
HBRUSH hbr = CComboBox::OnCtlColor(pDC, pWnd, nCtlColor);
// TODO: Change any attributes of the DC here
//if(CTLCOLOR_EDIT == nCtlColor || CTLCOLOR_MSGBOX == nCtlColor) {
[Code] ......
but is not working if CComboBox has CBS_DROPDOWNLIST style ... is working only for CBS_DROPDOWN style ... why ?
I used onctlcolor() method to set the background color for the controls & Dialog. I run my application, working good but after 15 mins the below error occured,
Application Error:
The Required Resource Was --------> Shown message box
Program Error:
First-chance exception at 0x7c81eb33 in XRay.exe: Microsoft C++ exception: CResourceException @ 0x001274f8.
First-chance exception at 0x7c81eb33 in XRay.exe: Microsoft C++ exception: CResourceException @ 0x001259d0.
First-chance exception at 0x7c81eb33 in XRay.exe: Microsoft C++ exception: CResourceException @ 0x00123ea8.
First-chance exception at 0x7c81eb33 in XRay.exe: Microsoft C++ exception: CResourceException @ 0x00122380.
First-chance exception at 0x7c81eb33 in XRay.exe: Microsoft C++ exception: CResourceException @ 0x00120858.
Warning: Uncaught exception in WindowProc (returning 0).
what is the reason for that? How can i prevent my project from this problem.
I've tried this (without success):
ui->tableView->model()->setData(ui->tableView->model()->index(5, 5, QModelIndex()), QVariant(QColor(Qt::red)), Qt::DecorationRole);
Okay, I have a form and I have a tab control thing. On the second tab, I have a button which is supposed to turn the background green.
So, I have this:
#pragma endregion
private: System::Void greenButton_Click(System::Object^ sender, System::EventArgs^ e) {
this ->BackColor = System::Drawing::Color::Green;
But clearly that just turns the FORMS background green. How can I change the TAB background to green.
I am working on this project where I need to update an edit box every couple of seconds with a status and based on the status I need to change the color of the background to a particular color.I am able to update the edit box with the status but is clueless on how to update background color.I have read some info on line about this but is confused.This edit box is on a tab in a dialog. Also, on this tab is a Groupable List Ctrl.
View 2 Replies View RelatedI'm creating a simple game with my friend that runs in the Terminal/Command Prompt window, but I would like to know how to change the color of the entire window via C++. I'm on a Mac, but my friend is on a Windows, so I need to a solution that is portable, if possible.
I've tried using a printf statement to change the color, but it only changes the background color of the text being printed.
I was trying to change the text and background color to :red blue
Is there a way to do this? is there a certain function? ...
I use turbo c++ 3.0
How to set the background color using the function setbkcolor() in graphics.h
will i need to run the exe file in full screen if i use this function?
Here is my code:
#include <graphics.h>
#include <stdio.h>
#include <conio.h>
int main() {
int gdriver = DETECT, gmode, errorcode,i;
initgraph(&gdriver, &gmode, "c:cgi");
errorcode = graphresult();
[Code] ....
i created a windows service that will run another program. but the program i want to run has a gui and i don't want the gui to be visible, i just want the program to run in the background.
But i have to do it without editing the gui program
here's my code:
Code:
TCHAR* path = L"C:Myfile est.exe";
STARTUPINFO info = {0};
PROCESS_INFORMATION processInfo;
ZeroMemory( &info, sizeof(info) );
info.cb = sizeof(info);
[code]....
i tested this code with notepad and it runs notepad in the background without displaying the window but when i try run my program it doesn't work. i don't know why its works for one program and not the other..
No I definitely used Visual Studio Command Prompt
c:Program FilesMicrosoft Visual Studio 9.0VC
un_process_from_service>make.bat
private String[] GetExcelSheetNames(string excelFile) {
OleDbConnection objConn = null;
SqlConnection objSqlConn = null;
System.Data.DataTable dt = null;
try {
[code].....
Now I can fatch all the excel sheet belongs to the Excel File.But How can I check "If and Only If the sheets are havin Underscore in their name(eg. student_data,teachers_data) then only the data of the sheets will populate in tha data base"
Is it possible to create an app that can be saved on my desktop that can be used with an excel file that is saved on my desktop? I have opened VS 2010 and I have created a form design that has a button for every sheet name in my excel file. All of the sheet names are hidden with the exception of one. When a button is pressed on the c# form, I would like for that sheet to be shown in excel. Then once the updates have been made to that sheet in excel, I want a button to be at the top of the excel worksheet that will hide that worksheet again and return to the form c# form...can that be done?
View 2 Replies View RelatedI'm trying to minimize an Excel window using c++. but it doesn't work.
Code:
//Save the PID
HWND hWnd = FindWindowA(NULL, (LPCSTR)pXlApp);
GetWindowThreadProcessId(hWnd, &proccesID);
// Make it visible
[Code].....
I checked the HWND is not null, but is not visible....
Code: bool visible=IsWindowVisible(hWnd);
and visible=false, but the window is Visible (I see the Excel file)
Using Excel Automation in Visual Studio 2010 C++, how do I define a name? As a user of Excel, you can enter a name that then can be used in formulas to refer to a range of cells. The range changes as the user inserts columns or rows. My program has worked with various versions of Excel dating back to the early 2000's.
I have a bunch of classes derived from COleDispatchDriver: CXLApplication, CXLRange, CXLWorkbook, CXLWorkbooks, and CXLWorksheet that have many functions, but I have no documentation... How to define a named range using functions of these classes (probably CXLRange)?
I wish to read an excel file which contains the table shown at the picture below.
I don't really know how to code the direct storage of the values in the appropriate array.
For example I wish to store the countries in an array of a string type.
could I have some piece of code which illustrates it (I mean the reading of an excel file and the direct storage of his value in an array).
I just got a job programming a windows application. One of the requirements is reading and writing values from an excel spreadsheet. Looking online, it appears that C++ isn't the best (one of the worst?) languages for reading and writing values from excel files. Now the language I'm most familiar with is C++ and I've been looking at C#, and it appears to be much easier to read excel files.
View 8 Replies View RelatedI am trying to make this code working and to remake it to work also for RGB to HSB? This code is for C and I need to make it working in Visual Studio C++ .
Code:
// mask1.cpp : Defines the entry point for the console application.
//
#include "stdafx.h"
#include <stdio.h>
#include <math.h>
typedef struct RGB_t { unsigned char red, green, blue; } RGB;
typedef struct HSB_t { float hue, saturation, brightness; } HSB;
[code]....
Error I got is error C3861: 'fmaxf': identifier not found
What file or namespace should I include. Do I need to add some library into linker?
I need VB code to remove any rows in excell that contain ONLY CAPS.
View 4 Replies View RelatedTrying to define some global colors so I can use the one instance though-out my application. Here is my color code:
<Color x:Key="GlobalTextColor">#E0E0E0</Color>
But this color doesn't display in the list when I start to type {StaticResource ...}
This is the code where I'm trying to reference the color, see Stroke="{StaticResource GlobalTextColor}". GlobalTextColor doesn't actually come up in the list so won't work.
<Style x:Key="InputButton" TargetType="Button">
<Setter Property="Background" Value="#FF141414" />
<Setter Property="HorizontalAlignment" Value="Left" />
[Code].....
We have a C++ 5.0 app that does something like this:
Creates the excel dispatch, exports the data, etc...
...
then calls these functions:
xlsApp.SetDisplayAlerts(TRUE);
xlsApp.SetVisible(TRUE);
xlsApp.SetUserControl(TRUE);
This has always worked to display the excel spreadsheet in the foreground, most recently on Windows Server 2003.
Now, testing on Windows Server 2008, the excel spreadsheet is created, but in the background. How to force it to the foreground?