Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Meet and Greet (http://www.go4expert.com/community/meet-and-greet/)
-   -   Issue with program to automate excel (http://www.go4expert.com/community/issue-program-automate-excel-t28978/)

haroonrulz 30Aug2012 12:48

Issue with program to automate excel
 
Dear C++ Gurus/Experts,

I am writing a program to automate excel.My program is working well when I use integer (Write/Read) in excel.My program also works well when I use string.But the issue appears when I use array of strings.I am getting the issue as below
"error C2664: 'SysAllocString' : cannot convert parameter 1 from 'char *' to 'const OLECHAR *' ". Please Help.

Program:
Code:

//working good with strings

 for(int i=1; i<=15; i++) {
      for(int j=1; j<=15; j++) {
        // Create entry value for (i,j)
                  BSTR b;
                  VARIANT parm1;
                  b = SysAllocString(L"Haroon"); // this line working good
                  parm1.vt = VT_BSTR;
                  parm1.bstrVal = b;
        // Add to safearray...
        long indices[] = {i,j};
                SafeArrayPutElement(arr.parray, indices, &parm1);
      }
  }

//Having problems with Array of strings

//Array of strings

char *hrs[]={"noor","riz","vignesh"};

 for(int i=1; i<=15; i++) {
      for(int j=1; j<=15; j++) {
        // Create entry value for (i,j)
                  BSTR b;
                  VARIANT parm1;
                  b = SysAllocString(hrs[0]); // issue in this line
                  parm1.vt = VT_BSTR;
                  parm1.bstrVal = b;
        // Add to safearray...
        long indices[] = {i,j};
                SafeArrayPutElement(arr.parray, indices, &parm1);
      }
  }



All times are GMT +5.5. The time now is 14:03.