Hello,
I have an application what is opening an excel file and I can write some date into cells, but I don`t know how to set some borders to that cells in what I put that data?
A tip be useful :).
Here is a part of the code:
char szApp[] = "EXCEL";
char szTopic[] = "C:\\Test.xls";
char szCmd1[] = "[APP.MINIMIZE()]";
char szItem1[256] ; char szDesc1[256] ;
char szItem2[256] ; char szDesc2[256] ;
char szItem3[256] ; char szData3[256] ;
char szCmd2[] = "[SELECT(\"R3C1\")][FONT.PROPERTIES(,\"Bold\")][SAVE()][QUIT()]";
DWORD idInst=0;
UINT iReturn;
iReturn = DdeInitialize(&idInst, (PFNCALLBACK)DdeCallback, APPCLASS_STANDARD | APPCMD_CLIENTONLY, 0 );
if (iReturn!=DMLERR_NO_ERROR){
AfxMessageBox("DDE Initialization Failed");
return;}
HINSTANCE hRet = ShellExecute(0, "open", szTopic, "", "", SW_SHOWNORMAL);
if ((int)hRet < 33)
{
AfxMessageBox("Unable to Start DDE Server");
Sleep(1500); DdeUninitialize(idInst);
return;
}
HSZ hszApp, hszTopic;
HCONV hConv;
hszApp = DdeCreateStringHandle(idInst, szApp, 0);
hszTopic = DdeCreateStringHandle(idInst, szTopic, 0);
hConv = DdeConnect(idInst, hszApp, hszTopic, NULL);
DdeFreeStringHandle(idInst, hszApp);
DdeFreeStringHandle(idInst, hszTopic);
if (hConv == NULL)
{
AfxMessageBox("DDE Connection Failed");
Sleep(1500); DdeUninitialize(idInst);
return;
}
DDEExecute(idInst, hConv, szCmd1);
DDERequest(idInst, hConv, szItem1, szDesc1);
DDERequest(idInst, hConv, szItem2, szDesc2);
int count_items = list.GetItemCount();
for (int i=0; i<count_items; i++)
for (int j=0; j<15; j++)
{
CString tmp_item;
tmp_item = list.GetItemText(i,j);
CString tmp_sz;
tmp_sz.Format("R%dC%d",i+7,j+1);
strcpy(szItem3,tmp_sz);
strcpy(szData3,tmp_item);
DDEPoke(idInst, hConv, szItem3, szData3);
}
DDEExecute(idInst, hConv, szCmd2);
DdeDisconnect(hConv);
DdeUninitialize(idInst);