C#

decimal d = 28.9876M;
int[] bits = Decimal.GetBits(d);
int pow = (bits[3] >> 16) & 0xFF;

Kwagga wrote:

objRange = objSheet.get_Range("A2", System.Reflection.Missing.Value);

Kwagga wrote:

objRange = objSheet.get_Range("B2", System.Reflection.Missing.Value);

int iR, iC;
iR = 1;//Worksheet RowIndex
iC = 1;//Worksheet ColumnIndex


foreach (ReadFile nomread in res)
{
        //in this you will work direct with worksheet.
        objSheet.Cells[iR, iC] = nomread.CLIENTSURNAME;
        objSheet.Cells[iR, iC+1] = nomread.CLIENTFORENAMES;

        iC = 1; //So your next column will start from 1 which will be A
        iR++; //increment row index by 1 as well.

}

Kwagga wrote:

It doesn't write all the records though. Only writes the last record. I get the jist of it

int iR, iC;
iR = 1;//Worksheet RowIndex
iC = 0;//Worksheet ColumnIndex

for (int i = 0; i <= Globals.Vars.arVbNums.Count - 1; i++)
    {
        iC++;
        //THE FOLLOWING IF STATEMENT USES % MOD OPERATOR
        // BE CAREFUL WHEN EDITING THE CODE.
        if (i % 30 == 0 && i != 0)
        {
            iR++;
            iC = 1;
        }
        oSheet.Cells[iR, iC] = Globals.Vars.arVbNums[i];

    }