我要评论大家好，今天接着写我们的通用方法总结分享。
下面是今天要分享的通用方法：
（1）通过输入信息，返回合并的单元格内容。这个方法比较好用，适合在有合并的单元格时候使用。
/// <summary>
/// 返回合并单元格的左上角内容
/// </summary>
/// <returns></returns>
public string mergecellcontents(microsoft.office.interop.excel.range ismeerge, microsoft.office.interop.excel.worksheet wsheet, int rows,int cell)
{
string content = "";
if (ismeerge.mergecells == true)
{
if (ismeerge.mergearea.row == rows && ismeerge.mergearea.column == cell)
{
content = ismeerge.text;
}
else
{
content = ((microsoft.office.interop.excel.range)wsheet.cells[ismeerge.mergearea.row, ismeerge.mergearea.column]).text;
}
}
return content;
}
（2）这个通用方法为获取sheet页中的所有图片，将图片和单元格的行index值存放在一个字典中。
/// <summary>
/// 获取每个sheet页，所有行和图片的集合
/// </summary>
/// <param name="worksheet"></param>
/// <returns></returns>
public dictionary<int, aspose.cells.drawing.picture> eachsheetimage(aspose.cells.worksheet worksheet)
{
dictionary<int, aspose.cells.drawing.picture> eachlist = new dictionary<int, aspose.cells.drawing.picture>();
aspose.cells.license l = new aspose.cells.license();
l.setlicense(system.windows.forms.application.startuppath + @"\aspose.license.lic");//破解许可证
aspose.cells.workbook workbook = new aspose.cells.workbook(uitextbox1.text);//读取表格
aspose.cells.drawing.picturecollection picture = worksheet.pictures;//读取图片
for(int i=0;i< picture.count;i++)
{
int x = picture[i].lowerrightrow;
eachlist.add(x, picture[i]);
}
return eachlist;
}
（3）这个通用方法为ug二次开发，获取选中尺寸线类型，这只是一部分类型，其他类型下集再讲。
string getmeasure(part workpart, int type, int subtype, tag selecttag)//获取尺寸线类型
{
string measure = " ";
string uni = "mm";
if (type == 26 && subtype == 5) //线性尺寸类型
{
nxopen.annotations.dimension dimension1 = (nxopen.annotations.dimension)nxobjectmanager.get(selecttag);
nxopen.annotations.lineardimensionbuilder lineardimensionbuilder1;
lineardimensionbuilder1 = workpart.dimensions.createlineardimensionbuilder(dimension1);
if (lineardimensionbuilder1.style.unitsstyle.dimensionlinearunits == nxopen.annotations.dimensionunit.inches)
{
uni = "un";
}
string[] measures = lineardimensionbuilder1.style.dimensionstyle.getoverriddendimensiontext();
measure = measures[0] + "$" + uni;
}
if (type == 26 && subtype == 1) //线性尺寸类型
{
nxopen.annotations.dimension dimension1 = (nxopen.annotations.dimension)nxobjectmanager.get(selecttag);
nxopen.annotations.lineardimensionbuilder lineardimensionbuilder1;
lineardimensionbuilder1 = workpart.dimensions.createlineardimensionbuilder(dimension1);
if (lineardimensionbuilder1.style.unitsstyle.dimensionlinearunits == nxopen.annotations.dimensionunit.inches)
{
uni = "un";
}
string[] measures = lineardimensionbuilder1.style.dimensionstyle.getoverriddendimensiontext();
measure = measures[0] + "$" + uni;
}
if (type == 26 && subtype == 3) //线性尺寸类型
{
nxopen.annotations.dimension dimension1 = (nxopen.annotations.dimension)nxobjectmanager.get(selecttag);
nxopen.annotations.lineardimensionbuilder lineardimensionbuilder1;
lineardimensionbuilder1 = workpart.dimensions.createlineardimensionbuilder(dimension1);
if (lineardimensionbuilder1.style.unitsstyle.dimensionlinearunits == nxopen.annotations.dimensionunit.inches)
{
uni = "un";
}
string[] measures = lineardimensionbuilder1.style.dimensionstyle.getoverriddendimensiontext();
measure = measures[0] + "$" + uni;
}
}
今天要介绍的就是这些，我们下篇文章再见。
发表评论