本文整理汇总了C#中Shape.get_Cells方法的典型用法代码示例。如果您正苦于以下问题：C# Shape.get_Cells方法的具体用法？C# Shape.get_Cells怎么用？C# Shape.get_Cells使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Shape的用法示例。
在下文中一共展示了Shape.get_Cells方法的7个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: RenameRow
private static void RenameRow(Shape shape, string oldRowName, string newRowName, string newRowLabel)
{
if (shape.get_CellExists(oldRowName, (short)VisExistsFlags.visExistsAnywhere) != 0) {
string tmp = shape.get_Cells(oldRowName).Formula;
short row = shape.get_CellsRowIndex(oldRowName);
shape.DeleteRow((short)VisSectionIndices.visSectionProp, row);
Common.SetCellFormula(shape, newRowName, tmp);
SetRowLabel(shape, newRowName, newRowLabel);
}
}示例2: SetRowLabel
private static void SetRowLabel(Shape shape, string rowName, string label)
{
if (shape.get_CellExists(rowName, (short)VisExistsFlags.visExistsAnywhere) != 0) {
Cell c = shape.get_Cells(rowName);
Cell cSRC = shape.get_CellsSRC((short)VisSectionIndices.visSectionProp, c.Row, (short)VisCellIndices.visCustPropsLabel);
cSRC.FormulaU = Common.StringToFormulaForString(label);
}
}示例3: SetCellFormula
internal static void SetCellFormula(Shape shape, string cellName, string value)
{
string rowName = cellName;
string sectionName = "";
if (cellName.Contains(".")) {
string[] tmp = cellName.Split('.');
System.Diagnostics.Debug.Assert(tmp.Length == 2);
sectionName = tmp[0];
rowName = tmp[1];
}
if (shape.get_CellExists(cellName, (short)VisExistsFlags.visExistsAnywhere) == 0) {
// we should only be adding rows to the Prop or User sections
System.Diagnostics.Debug.Assert(sectionName.ToUpper().Equals("PROP") || sectionName.ToUpper().Equals("USER"));
if (sectionName.ToUpper().Equals("USER")) {
if (shape.get_SectionExists((short)VisSectionIndices.visSectionUser, (short)VisExistsFlags.visExistsAnywhere) == 0)
shape.AddSection((short)VisSectionIndices.visSectionUser);
shape.AddNamedRow((short)VisSectionIndices.visSectionUser, rowName, (short)VisRowTags.visTagDefault);
}
else {
if (shape.get_SectionExists((short)VisSectionIndices.visSectionProp, (short)VisExistsFlags.visExistsAnywhere) == 0)
shape.AddSection((short)VisSectionIndices.visSectionProp);
shape.AddNamedRow((short)VisSectionIndices.visSectionProp, rowName, (short)VisRowTags.visTagDefault);
}
}
shape.get_Cells(cellName).Formula = value;
}示例4: GetCellFormula
internal static string GetCellFormula(Shape shape, string cellName)
{
if (shape.get_CellExists(cellName, (short)VisExistsFlags.visExistsAnywhere) != 0) {
Cell cell = shape.get_Cells(cellName);
return cell.Formula;
}
else
return "";
}示例5: GetProperty
private string GetProperty(Shape shape, string section, string property, string attribute)
{
string cellLocation = string.Empty;
if ((section == string.Empty) && (property == string.Empty))
cellLocation = string.Format("{0}", attribute);
else
cellLocation = string.Format("{0}.{1}.{2}", section, property, attribute);
Cell cell;
try
{
cell = shape.get_Cells(cellLocation);
}
catch (COMException)
{
return null;
}
return FormulaToString(cell.Formula);
}示例6: GetShapeType
public static String GetShapeType(Shape shape)
{
return FromString(shape.get_Cells("user.type").FormulaU);
}示例7: GetShapeCell
public static String GetShapeCell(Shape shape, String cellName)
{
return FromString(shape.get_Cells(cellName).FormulaU);
}