public List<Question> LoadFromXls()
{
List<Question> questions = new List<Question>();
Workbook workbook = new Workbook();
workbook.LoadFromFile(fileName);
var worksheet = workbook.Worksheets[0];
int rowIDX = 1;
int cellIDX = 1;
while (rowIDX != worksheet.Rows.Length && !worksheet.Rows[rowIDX].Cells[cellIDX].Value.Equals(""))
{
Question question = new Question();
question.Value = worksheet.Rows[rowIDX].Cells[cellIDX].Value;
rowIDX++;
for (int i = 1; i <= 4; i++)
{
question.Add(new Answer(worksheet.Rows[rowIDX].Cells[cellIDX].Value,
worksheet.Rows[rowIDX].Cells[cellIDX + 1].Value.Equals("+")));
rowIDX++;
}
questions.Add(question);
}
return questions;
}
private void новыйВопросToolStripMenuItem_Click(object sender, EventArgs e)
{
if (treeView_Subjects.SelectedNode != null)
{
var SelectedNode = treeView_Subjects.SelectedNode;
if (SelectedNode.Tag is Question) {
SelectedNode = SelectedNode.Parent;
}
Question question = new Question("Новый вопрос");
question.Add(new Answer());
question.Add(new Answer());
question.Add(new Answer());
question.Add(new Answer());
TreeNode qNode = new TreeNode();
qNode.Text = question.Value;
qNode.Tag = question;
SelectedNode.Nodes.Add(qNode);
treeView_Subjects.SelectedNode = qNode;
forSaveQuestion = true;
tsbSaveCurrent.Enabled = true;
}
}
