public Result Execute(ExternalCommandData commandData, ref string message, ElementSet elements)
{
//Excel名称及路径
string fullName = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory) + @"\test\PlumbingCalc.xlsx";
//string filePath = @"C:\Users\Administrator\Desktop\test\" + fileName + ".xlsx";
//Sheet1名称
string sheet1Name = "给排水工程量";
//第一个单元格
int startCol = 2;
int startRow = 2;
//实例化更新器
Updater.PipeParameterUpdater ppu = new Updater.PipeParameterUpdater(commandData.Application.ActiveAddInId, fullName, sheet1Name);
//更新器ID
UpdaterId updaterId = ppu.GetUpdaterId();
if (UpdaterRegistry.IsUpdaterRegistered(updaterId))
{
if (UpdaterRegistry.IsUpdaterEnabled(updaterId))
{
UpdaterRegistry.DisableUpdater(updaterId);
}
else
{
Tool.ExcelTool excelTool = new Tool.ExcelTool();
excelTool.UpdataInOpenWorkBook(commandData.Application.ActiveUIDocument.Document, fullName, sheet1Name, startRow, startCol);
UpdaterRegistry.EnableUpdater(updaterId);
}
}
else
{
message = "未能启动更新器,请联系XXX";
return(Result.Failed);
}
return(Result.Succeeded);
}
public Result Execute(ExternalCommandData commandData, ref string message, ElementSet elements)
{
Document doc = commandData.Application.ActiveUIDocument.Document;
////获取路径
//string fullName = null;
//if (fullName == null)
//{
// FolderBrowserDialog fbd = new FolderBrowserDialog();
// if (fbd.ShowDialog() == DialogResult.OK)
// {
// fullName = fbd.SelectedPath + "\\blumbingCalc.xlsx";
// }
//}
string fullName = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory) + @"\test\PlumbingCalc.xlsx";
if (fullName != null)
{
List <ArrayList> exportInformation = new List <ArrayList>();
//获取项目中所有管道和管道附件
FilteredElementCollector plumbingCollector = new FilteredElementCollector(doc);
ElementIsElementTypeFilter filter1 = new ElementIsElementTypeFilter(true);
List <ElementFilter> filterSet = new List <ElementFilter>();
filterSet.Add(new ElementCategoryFilter(BuiltInCategory.OST_PipeCurves));
filterSet.Add(new ElementCategoryFilter(BuiltInCategory.OST_PipeAccessory));
LogicalOrFilter orFilter = new LogicalOrFilter(filterSet);
plumbingCollector.WherePasses(new LogicalAndFilter(filter1, orFilter)).ToElements();
//获得用于创建Excel的数据
foreach (Element elem in plumbingCollector)
{
switch ((BuiltInCategory)elem.Category.Id.IntegerValue)
{
case BuiltInCategory.OST_PipeCurves:
Pipe p = elem as Pipe;
//识别所有有缩写的管道
if (p.get_Parameter(BuiltInParameter.RBS_DUCT_PIPE_SYSTEM_ABBREVIATION_PARAM).AsString() != "")
{
exportInformation.Add(new PipeCalculation(doc, p).PipeCalcInformation());
}
break;
case BuiltInCategory.OST_PipeAccessory:
FamilyInstance pa = elem as FamilyInstance;
//识别阀门
if (pa.get_Parameter(BuiltInParameter.ELEM_FAMILY_PARAM).AsValueString().Contains("阀") && pa.get_Parameter(BuiltInParameter.RBS_DUCT_PIPE_SYSTEM_ABBREVIATION_PARAM).AsString() != "")
{
exportInformation.Add(new PipeCalculation(doc, pa).PipeCalcInformation());
}
break;
}
}
////Excel名称及路径
//string fileName = "pipeCalc";
//string filePath = @"C:\Users\Administrator\Desktop\test\" + fileName + ".xlsx";
//Sheet1名称
string sheetName = "给排水工程量";
//判断是否打开了Excel文件
var excelTool = new Tool.ExcelTool();
if (excelTool.ExcelVarsion != "" && excelTool.isExcelRunning)
{
//捕获程序
var excelApp = Marshal.GetActiveObject("Excel.Application") as ExcelCom.Application;
//记录状态
bool workBookIsOpen = false;
bool hasWorkSheet = false;
//识别工作簿
for (int i = 0; i < excelApp.Workbooks.Count; i++)
{
var workBook = excelApp.Workbooks[i + 1] as ExcelCom.Workbook;
if (workBook != null && workBook.FullName == fullName)
{
workBookIsOpen = true;
//识别工作表
for (int j = 0; j < excelApp.Worksheets.Count; j++)
{
var workSheet = excelApp.Worksheets[j + 1] as ExcelCom.Worksheet;
if (workSheet != null && workSheet.Name == sheetName)
{
hasWorkSheet = true;
////获得最后一列
//int row = workSheet.Cells.SpecialCells(ExcelCom.XlCellType.xlCellTypeLastCell).Row;
////添加数据
//workSheet.Range["A" + (row + 1).ToString()].Value = "test";
//刷新数据
//表1
excelTool.UpdataInOpenWorkBook(doc, fullName, sheetName, 2, 2);
//汇总表
excelTool.UpdataPivotTable(fullName, sheetName, 2, 2);
break;
}
}
//当工作簿中无工作表
if (!hasWorkSheet)
{
//to do
}
}
}
//识别失败
if (!workBookIsOpen)
{
//创建Excel
if (File.Exists(fullName))
{
File.Delete(fullName);
}
creatExcelFile(fullName, sheetName, 2, 2, exportInformation);
}
}
else
{
//创建Excel
if (File.Exists(fullName))
{
File.Delete(fullName);
}
creatExcelFile(fullName, sheetName, 2, 2, exportInformation);
}
}
return(Result.Succeeded);
}
public Result Execute(ExternalCommandData commandData, ref string message, ElementSet elements)
{
//Excel名称及路径
//string fileName = "pipeCalc";
//string filePath = @"C:\Users\Administrator\Desktop\test\" + fileName + ".xlsx";
string fullName = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory) + @"\test\PlumbingCalc.xlsx";
//Sheet1名称
string sheet1Name = "给排水工程量";
//第一个单元格
int startCol = 2;
int startRow = 2;
//获得按钮组
UIApplication uiapp = commandData.Application;
foreach (var ribbonPanel in uiapp.GetRibbonPanels("Test"))
{
if (ribbonPanel.Name == "Excel Tool")
{
foreach (var item in ribbonPanel.GetItems())
{
var rbg = item as RadioButtonGroup;
if (rbg != null && rbg.Name == "Link_test")
{
//实例化更新器
Updater.PipeParameterUpdater ppu = new Updater.PipeParameterUpdater(commandData.Application.ActiveAddInId, fullName, sheet1Name);
//更新器ID
UpdaterId updaterId = ppu.GetUpdaterId();
if (UpdaterRegistry.IsUpdaterRegistered(updaterId))
{
if (UpdaterRegistry.IsUpdaterEnabled(updaterId))
{
UpdaterRegistry.DisableUpdater(updaterId);
//切换按钮
foreach (ToggleButton tog in rbg.GetItems())
{
if (tog.Name == "link_disable")
{
rbg.Current = tog;
}
}
}
else
{
Tool.ExcelTool excelTool = new Tool.ExcelTool();
excelTool.UpdataInOpenWorkBook(commandData.Application.ActiveUIDocument.Document, fullName, sheet1Name, startRow, startCol);
UpdaterRegistry.EnableUpdater(updaterId);
}
}
else
{
message = "未能启动更新器,请联系XXX";
return(Result.Failed);
}
break;
}
}
break;
}
}
return(Result.Succeeded);
}