mfc, Problem in filling COleSafeArray with COleDatatime values

1. Problem in filling COleSafeArray with COleDatatime values

hi,
I use COleSafeArrays to pass data to Excel. It works well for
int,float,CString. But I could not pass date-time with it. Is there any
limitation? I use something like this code in brief:

    COleDateTime tt;
    tt=COleDateTime::GetCurrentTime();
    COleVariant vv=tt;

    long index[2];
    index[0] = iRow;
    index[1] = iCol;
    MySafeArray->PutElement(index, vv.date);
(MySafeArray is of type VT_DATE)

thanks,
  Behzad

2. Problem with COLESafeArray

3. COleSafeArray problem with regional settings

We use COleSafeArray to send data to an excel spreadsheet, for one of
our products (using Visual C++ 5.0, Excel97, Excel2000).

The data includes data of various types (date, time, number), so the
safe array has been set up as VT_VARIANT.

A problem has occured with the use of this product in Germany, the
numbers are not displayed correctly.  They have Windows Regional
Setting (WRS) as "German", which has:-
	a. Date seperator as '.'
	b. decimal seperator as ',' (decimal comma instead of decimal point).

The numbers come out wrongly, as they seem to be interpreted as
'date'.

If we remove the COleSafeArray use, and write data directly to the
spreadsheet,
the numbers are converted correctly (e.g '2.4' set as '2,4').

The way we have fixed this problem, is to check each number, before
putting it to the safe array, and replacing the decimal point with the
WRS equivilant (',' in this case).

Is there any other way of getting over this problem?

Cheers

Bill Dallas

4. Problem with COLESafeArray

5. Fill blank spaces with values in a Word Document

I have certain values in a data reader that I want to fill one by one
in a Word Document. The Word Document contains blank spaces in some
places where these values need to get filled. How to detect the blank
space and fill the appropriate value there?

I have seen a code sample using "Find and Replace" Method, but it is
very slow on documents of large size. I want any fast and easy to use
method.

6. DataSet.Fill() When Column Value is Space - CSharp/C#

7. filling values in a web page using C#

Hi i am developing an IE plugin which will auomatically provide
username and password to web pages on click of a button. I was trying
to develop a dummy button to test and am trying to use
HTMLInputElementClass. the code compiles well but gives a un time
exception in the browser. the code goes like :

private void bttnEnterUserName_Click(object sender, EventArgs e)
        {
            HTMLDocumentClass doc = new HTMLDocumentClass();
            doc = (HTMLDocumentClass) this.Explorer.Document;
            HTMLInputElementClass ele = new HTMLInputElementClass();

            if (doc.url.ToString() ==
"https://www.google.com/accounts/ServiceLogin?service=mail&passive=true&rm=false&continue=http%3A%2F%2Fmail.google.com%2Fmail%2F%3Fui%3Dhtml%26zy%3Dl<mpl=cm_blanco<mplcache=2")
            {

                foreach (HTMLInputElementClass element in
doc.getElementsByTagName("input"))
                {
                    ele = (HTMLInputElementClass)
element.getAttribute("Email", 0);
                    element.value = "prayag.narula";
                }
            }
 
        }


what am i doing wrong. Wat other aproach can i use???

8. Fill collection with closest values, tricky logic - CSharp/C#