/// <summary> /// dump SectionData to comma delimited. /// </summary> /// <param name="sw">exporting file stream</param> /// <param name="psView">the PanelScheduleView instance is exporting.</param> /// <param name="sectionType">which section is exporting, it can be Header, Body, Summary or Footer.</param> private void DumpSectionData(StreamWriter sw, PanelScheduleView psView, SectionType sectionType) { int nRows_Section = 0; int nCols_Section = 0; getNumberOfRowsAndColumns(m_psView.Document, m_psView, sectionType, ref nRows_Section, ref nCols_Section); for (int ii = 0; ii < nRows_Section; ++ii) { StringBuilder oneRow = new StringBuilder(); for (int jj = 0; jj < nCols_Section; ++jj) { try { oneRow.AppendFormat("{0},", m_psView.GetCellText(sectionType, ii, jj)); } catch (Exception) { // do nothing. } } sw.WriteLine(oneRow.ToString()); } }
/// <summary> /// dump SectionData to the 'tr' nodes in HTML. /// </summary> /// <param name="panelScheduleDataNode">a 'table' node in HTML.</param> /// <param name="doc">HTML page</param> /// <param name="psView">the PanelScheduleView instance is exporting.</param> /// <param name="sectionType">which section is exporting, it can be Header, Body, Summary or Footer.</param> private void DumpSectionData(XmlNode panelScheduleDataNode, XmlDocument doc, PanelScheduleView psView, SectionType sectionType) { int nRows_Section = 0; int nCols_Section = 0; getNumberOfRowsAndColumns(m_psView.Document, m_psView, sectionType, ref nRows_Section, ref nCols_Section); for (int ii = 0; ii < nRows_Section; ++ii) { // add a <tr> node for each row XmlElement trNode = doc.CreateElement("tr"); panelScheduleDataNode.AppendChild(trNode); for (int jj = 0; jj < nCols_Section; ++jj) { // add <td> node for each cell XmlElement tdNode = doc.CreateElement("td"); try { tdNode.InnerText = m_psView.GetCellText(sectionType, ii, jj); } catch (Exception) { // do nothing. } trNode.AppendChild(tdNode); } } }
//private FamilyInstance _panel = null; public XLSXTranslator(PanelScheduleView psView, Document _doc) { //m_psView = psView; ElementId psId = psView.Id; m_psView = _doc.GetElement(psId) as PanelScheduleView; }
private void DumpSectionData(PanelScheduleView psView, SectionType sectionType) { _nRows_Section = 0; _nRows_Section = 0; getNumberOfRowsAndColumns(m_psView.Document, m_psView, sectionType, ref _nRows_Section, ref _nCols_Section); //get rows/cols for schedule section. //Header Section //Body Section //Summary //Footer //Existing functionality for (int ii = 0; ii < _nRows_Section; ++ii) { for (int jj = 0; jj < _nCols_Section; ++jj) { try { cc = jj; //set excel column equal to schedule column string s = m_psView.GetCellText(sectionType, ii, jj); int value = 0; Excel.Range range = MySheet.Cells[rr, cc] as Excel.Range; range.HorizontalAlignment = Excel.XlHAlign.xlHAlignLeft; //Align cells left. // Format cells for VA if (Regex.Match(s, @"[0-9] VA").Success) //Regex to match "## VA" cells { s = s.Remove(s.Length - 3); int.TryParse(s, out value); range.NumberFormat = "0 VA"; MySheet.Cells[rr, cc] = value; } else if (Regex.Match(s, @"[0-9] A").Success) //Regex to match "## A" cells { s = s.Remove(s.Length - 2); int.TryParse(s, out value); range.NumberFormat = "0 A"; MySheet.Cells[rr, cc] = value; } else { MySheet.Cells[rr, cc] = s; } } catch (Exception) { // do nothing. } } rr++; //increment excel row } }
/// <summary> /// Implement this method as an external command for Revit. /// </summary> /// <param name="commandData">An object that is passed to the external application /// which contains data related to the command, /// such as the application object and active view.</param> /// <param name="message">A message that can be set by the external application /// which will be displayed if a failure or cancellation is returned by /// the external command.</param> /// <param name="elements">A set of elements to which the external application /// can add elements that are to be highlighted in case of failure or cancellation.</param> /// <returns>Return the status of the external command. /// A result of Succeeded means that the API external method functioned as expected. /// Cancelled can be used to signify that the user cancelled the external operation /// at some point. Failure should be returned if the application is unable to proceed with /// the operation.</returns> public virtual Autodesk.Revit.UI.Result Execute(ExternalCommandData commandData , ref string message, Autodesk.Revit.DB.ElementSet elements) { Autodesk.Revit.DB.Document doc = commandData.Application.ActiveUIDocument.Document; // get all PanelScheduleView instances in the Revit document. FilteredElementCollector fec = new FilteredElementCollector(doc); ElementClassFilter PanelScheduleViewsAreWanted = new ElementClassFilter(typeof(PanelScheduleView)); fec.WherePasses(PanelScheduleViewsAreWanted); List <Element> psViews = fec.ToElements() as List <Element>; bool noPanelScheduleInstance = true; foreach (Element element in psViews) { PanelScheduleView psView = element as PanelScheduleView; if (psView.IsPanelScheduleTemplate()) { // ignore the PanelScheduleView instance which is a template. continue; } else { noPanelScheduleInstance = false; } // choose what format export to, it can be CSV or HTML. TaskDialog alternativeDlg = new TaskDialog("Choose Format to export"); alternativeDlg.MainContent = "Click OK to export in .CSV format, Cancel to export in HTML format."; alternativeDlg.CommonButtons = TaskDialogCommonButtons.Ok | TaskDialogCommonButtons.Cancel; alternativeDlg.AllowCancellation = true; TaskDialogResult exportToCSV = alternativeDlg.Show(); Translator translator = TaskDialogResult.Cancel == exportToCSV ? new HTMLTranslator(psView) : new CSVTranslator(psView) as Translator; string exported = translator.Export(); // open the file if export successfully. if (!string.IsNullOrEmpty(exported)) { System.Diagnostics.Process.Start(exported); } } if (noPanelScheduleInstance) { TaskDialog messageDlg = new TaskDialog("Warnning Message"); messageDlg.MainIcon = TaskDialogIcon.TaskDialogIconWarning; messageDlg.MainContent = "No panel schedule view is in the current document."; messageDlg.Show(); return(Result.Cancelled); } return(Result.Succeeded); }
/// <summary> /// An utility method to get the number of rows and columns of the section which is exporting. /// </summary> /// <param name="doc">Revit document.</param> /// <param name="psView">the exporting panel schedule view</param> /// <param name="sectionType">the exporting section of the panel schedule.</param> /// <param name="nRows">the number of rows.</param> /// <param name="nCols">the number of columns.</param> protected void getNumberOfRowsAndColumns(Autodesk.Revit.DB.Document doc, PanelScheduleView psView, SectionType sectionType, ref int nRows, ref int nCols) { Transaction openSectionData = new Transaction(doc, "openSectionData"); openSectionData.Start(); TableSectionData sectionData = psView.GetSectionData(sectionType); nRows = sectionData.NumberOfRows; nCols = sectionData.NumberOfColumns; openSectionData.RollBack(); }
/// <summary> /// Implement this method as an external command for Revit. /// </summary> /// <param name="commandData">An object that is passed to the external application /// which contains data related to the command, /// such as the application object and active view.</param> /// <param name="message">A message that can be set by the external application /// which will be displayed if a failure or cancellation is returned by /// the external command.</param> /// <param name="elements">A set of elements to which the external application /// can add elements that are to be highlighted in case of failure or cancellation.</param> /// <returns>Return the status of the external command. /// A result of Succeeded means that the API external method functioned as expected. /// Cancelled can be used to signify that the user cancelled the external operation /// at some point. Failure should be returned if the application is unable to proceed with /// the operation.</returns> public virtual Autodesk.Revit.UI.Result Execute(ExternalCommandData commandData , ref string message, Autodesk.Revit.DB.ElementSet elements) { Autodesk.Revit.DB.Document doc = commandData.Application.ActiveUIDocument.Document; // get one sheet view to place panel schedule. ViewSheet sheet = doc.ActiveView as ViewSheet; if (null == sheet) { message = "please go to a sheet view."; return(Result.Failed); } // get all PanelScheduleView instances in the Revit document. FilteredElementCollector fec = new FilteredElementCollector(doc); ElementClassFilter PanelScheduleViewsAreWanted = new ElementClassFilter(typeof(PanelScheduleView)); fec.WherePasses(PanelScheduleViewsAreWanted); List <Element> psViews = fec.ToElements() as List <Element>; Transaction placePanelScheduleOnSheet = new Transaction(doc, "placePanelScheduleOnSheet"); placePanelScheduleOnSheet.Start(); XYZ nextOrigin = new XYZ(0.0, 0.0, 0.0); foreach (Element element in psViews) { PanelScheduleView psView = element as PanelScheduleView; if (psView.IsPanelScheduleTemplate()) { // ignore the PanelScheduleView instance which is a template. continue; } PanelScheduleSheetInstance onSheet = PanelScheduleSheetInstance.Create(doc, psView.Id, sheet); onSheet.Origin = nextOrigin; BoundingBoxXYZ bbox = onSheet.get_BoundingBox(doc.ActiveView); double width = bbox.Max.X - bbox.Min.X; nextOrigin = new XYZ(onSheet.Origin.X + width, onSheet.Origin.Y, onSheet.Origin.Z); } placePanelScheduleOnSheet.Commit(); return(Result.Succeeded); }
private void Form1_Load(object sender, EventArgs e) { progressBar1.Visible = false; textBox1.Text = PanelScheduleExport._exportDirectory; FilteredElementCollector fec = new FilteredElementCollector(_doc).OfClass(typeof(PanelScheduleView)); foreach (Element elem in fec) { PanelScheduleView psView = elem as PanelScheduleView; if (psView.IsPanelScheduleTemplate()) { continue; } else { checkedListBox1.Items.Add(psView, false); } } checkedListBox1.DisplayMember = "Name"; }
/// <summary> /// Implement this method as an external command for Revit. /// </summary> /// <param name="commandData">An object that is passed to the external application /// which contains data related to the command, /// such as the application object and active view.</param> /// <param name="message">A message that can be set by the external application /// which will be displayed if a failure or cancellation is returned by /// the external command.</param> /// <param name="elements">A set of elements to which the external application /// can add elements that are to be highlighted in case of failure or cancellation.</param> /// <returns>Return the status of the external command. /// A result of Succeeded means that the API external method functioned as expected. /// Cancelled can be used to signify that the user cancelled the external operation /// at some point. Failure should be returned if the application is unable to proceed with /// the operation.</returns> public virtual Autodesk.Revit.UI.Result Execute(ExternalCommandData commandData , ref string message, Autodesk.Revit.DB.ElementSet elements) { Autodesk.Revit.DB.Document doc = commandData.Application.ActiveUIDocument.Document; Reference selected = commandData.Application.ActiveUIDocument.Selection.PickObject(ObjectType.Element); Transaction newInstanceView = new Transaction(doc, "Create instance view for an electrical panel."); newInstanceView.Start(); PanelScheduleView instanceView = PanelScheduleView.CreateInstanceView(doc, doc.GetElement(selected).Id); if (null == instanceView) { newInstanceView.RollBack(); message = "Please select one electrical panel."; return(Result.Failed); } else { newInstanceView.Commit(); return(Result.Succeeded); } }
/// <summary> /// create a CSVTranslator instance for a PanelScheduleView instance. /// </summary> /// <param name="psView">the exporting panel schedule view instance.</param> public CSVTranslator(PanelScheduleView psView) { m_psView = psView; }