Datasheet::SetCell

SetCell

1 Description
2 Syntax
3 Parameters
4 Return
5 Examples
6 Remark
7 See Also
8 header to Include

Description

Set the numeric value of a cell in the worksheet

Set the string value of a cell in the worksheet

Put a copy of the XML tree into a cell

Put an Image at the given cell (nRow, nCol) in the worksheet

Syntax

BOOL SetCell( int nRow, int nCol, double value )

BOOL SetCell( int nRow, int nCol, LPCSTR lpcszText, BOOL bConsiderNumeric = true )

BOOL SetCell( int nRow, int nCol, LPCSTR lpcszName, const TreeNode & tr )

BOOL SetCell( int nRow, int nCol, Image & img, DWORD dwAttachInfo = 0 )

Parameters

nRow: [input] Row number with zero offset
nCol: [input] Column number with zero offset
value: [input] Value to set at the location (nRow, nCol)

nRow: [input] Row number with zero offset
nCol: [input] Column number with zero offset
lpcszText: [input] String to set location (nRow, nCol)
bConsiderNumeric: [input] when true, check lpcszText and set as numeric including "--" to become numeric missing value

nRow: [input] Row number with zero offset
nCol: [input] Column number with zero offset
lpcszName: [input] A name must be given to be associated with the XML tree, as the data is actually stored in the Column info area
tr: [input] Tree to be copied, a deep copy is performed

nRow: [input] Row number with zero offset
nCol: [input] Column number with zero offset
img: [input] Image to to put into the cell
dwAttachInfo: [input] Define attach parameters, can be one or more of the following; EMBEDGRAPH_KEEP_ASPECT_RATIO = 0x00000010, // Keep Aspect Ratio; EMBEDGRAPH_IN_LABELS = 0x00000020, // Embeds the graph in Label; EMBEDGRAPH_DO_UNDO = 0x00000040, /// Allows undo of the attachment

Return

TRUE for success; otherwise FALSE.

Examples

EX1

//Set the numeric value of a cell in the worksheet.
int Datasheet_SetCell_Ex1()
{
    WorksheetPage wp = Project.WorksheetPages(0);
    if(!wp)
        return -1;
    
    Worksheet wks(wp.GetName());
    double value = 1000.05;
    int iResult;
    iResult = (int)wks.SetCell(0, 0, value);
    double cellValue = wks.Cell(0, 0);
    printf("Value at (0,0) location is %f\n", cellValue);
    return iResult;
}

EX2

//Set the string value of a cell in the worksheet 
int Datasheet_SetCell_Ex2()
{
    WorksheetPage wp = Project.WorksheetPages(0);
    if(!wp)
        return -1;
    
    Worksheet wks(wp.GetName());
    string strText = "Monday";
    int iResult;
    string cellText;

    iResult = (int)wks.SetCell(0, 0, strText);
    wks.GetCell(0, 0, cellText);
    printf("Value at (0,0) location is %s\n", cellText);
    return iResult;
}

EX3

//put a copy of the XML tree into a cell 
int Datasheet_SetCell_Ex3()
{
    Tree tr1;
    TreeNode tr = tr1.AddNode("Test");
    tr.AA.strVal = "Some text";
    tr.BB.dVals = 0.1234;

    Worksheet wks = Project.ActiveLayer();
    int nR = 1;
    int nC = 1;
    string strName = "Pear Tree";

    return (int)wks.SetCell(nR, nC, strName, tr1.Test);
}

EX4

//Put an Image at the given cell (nRow, nCol) in the worksheet. 
#include <image_utils.h>
//#include <..\OriginLab\image_utils.c>
void Datasheet_SetCell_Ex4()
{
    Worksheet wks = Project.ActiveLayer();
    if(!wks)
        return;
    
    FILEINFO fi;
    int nErr;
    string strFilename = "c:\\test.bmp";
    pBITMAPHANDLE pLbmp = image_import(strFilename, &fi, &nErr);
    if(NULL == pLbmp)
    {
        printf("error loading %s, err = %d, abort!\n", strFilename, nErr);
        return;
    }
    
    Image img;
    img.SetLBmp(pLbmp, false);
    wks.SetCell(0, 0, img);
}

Ex5

//Set the numeric value of a cell in the matrix.
void Datasheet_SetCell_Ex5()
{
        MatrixLayer ml = Project.ActiveLayer();
        if ( !ml )
        {
                printf("Can not access active matrixsheet");
                return;
        }
        ml.SetCell(0, 0, 3333); //set the active matrixobject's first cell value;
        return;
}