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