void RandomQuestion()
{
Random r = new Random();
for (int i = 0; i < question.Length; i++)
{
int r1 = r.Next(0, question.Length);
MyExcelCollection m = question[i]; question[i] = question[r1]; question[r1] = m;
}
}
public void readExcel()
{
int count = 1;
string raws = "A" + count;
myRange = mySheet.get_Range(raws);
Array.Resize(ref question, 1);
while (Convert.ToString(myRange.Value) != null)
{
label1.Text = Convert.ToString(question.Length);//載入題數
raws = "A" + count;
myRange = mySheet.get_Range(raws);
//string q = Convert.ToString(myRange.Value);由於50%會變成0.5 故改用myRange.Text
string q = myRange.Text;
raws = "B" + count;
myRange = mySheet.get_Range(raws);
//string a = Convert.ToString(myRange.Value);
string a = myRange.Text;
raws = "C" + count;
myRange = mySheet.get_Range(raws);
//string b = Convert.ToString(myRange.Value);
string b = myRange.Text;
raws = "D" + count;
myRange = mySheet.get_Range(raws);
//string c = Convert.ToString(myRange.Value);
string c = myRange.Text;
raws = "E" + count;
myRange = mySheet.get_Range(raws);
//string d = Convert.ToString(myRange.Value);
string d = myRange.Text;
raws = "F" + count;
myRange = mySheet.get_Range(raws);
//string ans = Convert.ToString(myRange.Value);
string ans = myRange.Text;
question[count - 1] = new MyExcelCollection(q, a, b, c, d, ans);
Array.Resize(ref question, question.Length + 1);
raws = "A" + ++count;
myRange = mySheet.get_Range(raws);
//label5.Text = Convert.ToString(count - 1);
}
Array.Resize(ref question, question.Length - 1);
System.Runtime.InteropServices.Marshal.ReleaseComObject(myExcel);
myBook = null;
mySheet = null;
myRange = null;
myExcel = null;
GC.Collect();
}
private void Initialize()
{
//把選項存入array
selections[0] = radioButton1;
selections[1] = radioButton2;
selections[2] = radioButton3;
selections[3] = radioButton4;
timeCount = TIME; //預設15分鐘
time = new Timer();
time.Interval = 1000;
time.Tick += new EventHandler(time_Tick);
radioButton1.CheckedChanged += new EventHandler(userAnswer_CheckedChanged);
radioButton2.CheckedChanged += new EventHandler(userAnswer_CheckedChanged);
radioButton3.CheckedChanged += new EventHandler(userAnswer_CheckedChanged);
radioButton4.CheckedChanged += new EventHandler(userAnswer_CheckedChanged);
rdbFontSmall.CheckedChanged += new EventHandler(SetFontSize);
rdbFontMid.CheckedChanged += new EventHandler(SetFontSize);
rdbFontBig.CheckedChanged += new EventHandler(SetFontSize);
enhanceQuestion[0] = new MyExcelCollection();
}
