2.2.4.12.20 Datasheet::SetCell

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.


TRUE for success; otherwise FALSE.


TRUE for success; otherwise FALSE.


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;
}

Remark

See Also

Datasheet::Cell,Datasheet::TCell,Worksheet::GetCell

Header to Include

origin.h