public static void InitRobot()
{
robotApp = new RobotApplication();
nodeServer = robotApp.Project.Structure.Nodes;
barServer = robotApp.Project.Structure.Bars;
caseServer = robotApp.Project.Structure.Cases;
labelServer = robotApp.Project.Structure.Labels;
PrefrencesServer = robotApp.Project.Preferences;
barForceServer = robotApp.Project.Structure.Results.Bars.Forces;
}
}//setCurrentDataBase
//Store the selected section to the Robot Application
public void storeSectionLabelFromDB(string database, IRobotLabelType labelType, string section)
{
//Access LabelServer
IRobotLabelServer labelServer = getLabelServer();
//Get Section DataBase
setCurrentDatabase(IRobotDatabaseType.I_DT_SECTIONS, database);
//Create a Label
IRobotLabel label = labelServer.Create(labelType, section);
IRobotBarSectionData sectionData = (RobotBarSectionData)label.Data;
sectionData.LoadFromDBase(section);
labelServer.Store(label);
}
}//getSectionDatabase
public IRobotNamesArray loadProfileDatabase(string database, string type)
{
//Access the IRobotLabelServer
IRobotLabelServer labelServer = getLabelServer();
//Change the current section database
string sDBName = database;
IRobotSectionDatabase sectionDBase = getSectionDatabase(sDBName);
IRobotNamesArray profiles = (RobotNamesArray)sectionDBase.GetAll();
RobotNamesArray filtered = new RobotNamesArray();
int filterSize = 1;
for (int i = 1; i < profiles.Count; i++)
{
//Defines the size of the Array
//Console.WriteLine(profiles.Get(i));
if (profiles.Get(i).StartsWith(type))
{
filterSize++;
}
}
//Console.WriteLine(filterSize);
filtered.SetSize(filterSize);
//Labeling the filter
int pos = 1;
for (int i = 1; i < profiles.Count; i++)
{
if (profiles.Get(i).StartsWith(type))
{
filtered.Set(pos, profiles.Get(i));
pos++;
}
}
return(filtered);
}//loadProfileDatabase
private void button1_Click(object sender, EventArgs e)
{
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(@"EXCELPATH...\excelFile.xlsx", 0, false);
Excel.Sheets xlSheets = xlWorkbook.Worksheets;
string currentSheet = "Sheet1";
Excel.Worksheet xlWorksheet = (Excel.Worksheet)xlSheets.get_Item(currentSheet);
IRobotApplication robotApp = new RobotApplication();
IRobotLabelServer lab_serv = robotApp.Project.Structure.Labels;
progressBar1.Value = 0;
progressBar1.Maximum = 151;
progressBar1.Minimum = 0;
progressBar1.Step = 1;
for (int i = 1; i < 152; i++)
{
string secName = xlWorksheet.Cells[i + 1, 1].Value.ToString();
double secAx = double.Parse(xlWorksheet.Cells[i + 1, 2].Value.ToString());
double secIx = double.Parse(xlWorksheet.Cells[i + 1, 3].Value.ToString());
double secIy = double.Parse(xlWorksheet.Cells[i + 1, 4].Value.ToString());
double secIz = double.Parse(xlWorksheet.Cells[i + 1, 5].Value.ToString());
double secVy = double.Parse(xlWorksheet.Cells[i + 1, 6].Value.ToString());
double secVpy = double.Parse(xlWorksheet.Cells[i + 1, 7].Value.ToString());
double secVz = double.Parse(xlWorksheet.Cells[i + 1, 8].Value.ToString());
double secVpz = double.Parse(xlWorksheet.Cells[i + 1, 9].Value.ToString());
IRobotLabel sec = lab_serv.Create(IRobotLabelType.I_LT_BAR_SECTION, secName);
IRobotBarSectionData data = sec.Data;
data.Type = IRobotBarSectionType.I_BST_STANDARD;
data.ShapeType = IRobotBarSectionShapeType.I_BSST_UNKNOWN;
data.SetValue(IRobotBarSectionDataValue.I_BSDV_AX, secAx);
data.SetValue(IRobotBarSectionDataValue.I_BSDV_IX, secIx);
data.SetValue(IRobotBarSectionDataValue.I_BSDV_IY, secIy);
data.SetValue(IRobotBarSectionDataValue.I_BSDV_IZ, secIz);
data.SetValue(IRobotBarSectionDataValue.I_BSDV_VY, secVy);
data.SetValue(IRobotBarSectionDataValue.I_BSDV_VPY, secVpy);
data.SetValue(IRobotBarSectionDataValue.I_BSDV_VZ, secVz);
data.SetValue(IRobotBarSectionDataValue.I_BSDV_VPZ, secVpz);
lab_serv.Store(sec);
IRobotBar bar = (IRobotBar)robotApp.Project.Structure.Bars.Get(i);
bar.SetLabel(IRobotLabelType.I_LT_BAR_SECTION, secName);
progressBar1.PerformStep();
}
Marshal.FinalReleaseComObject(xlWorksheet);
Marshal.FinalReleaseComObject(xlSheets);
xlWorkbook.Close(false);
Marshal.FinalReleaseComObject(xlWorkbook);
xlApp.Quit();
Marshal.FinalReleaseComObject(xlApp);
MessageBox.Show("All the profiles have been applied!", "Work done !", MessageBoxButtons.OK);
}
