Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- for (int j = 0; j < elementtypenames.Count; j++)
- {
- ETN = double.Parse(elementtypenames[j]);
- count = 0;
- sList.Sort();
- for (int i = 0; i < sList.Count; i++)
- {
- count = count + 1;
- try
- {
- KeynoteNumExcel = double.Parse(sList[i]);
- if(ETN < KeynoteNumExcel)
- {
- Excel.Range line = xlWorkSheet.Rows[i];
- //Planen er, at den skal finde i's placering i listen,
- //og tilføje j lige efter. Problemet er, at den første placerer sig fint, men den næste gør ikke
- //Jeg skal have den til at nulstille på en eller anden måde. Tænker jeg?
- line.Insert();
- xlWorkSheet.Cells[i, 1] = ETN;
- workbook.Save();
- sList.Add(ETN.ToString());
- break;
- }
- else if (double.Parse(ETN.ToString().Substring(0, 3)) < double.Parse(KeynoteNumExcel.ToString().Substring(0, 3)))
- {
- if (KeynoteNumExcel.ToString().Length != 6 && ETN != KeynoteNumExcel && double.Parse(ETN.ToString().Substring(0, 3)) != double.Parse(KeynoteNumExcel.ToString().Substring(0, 3)))
- {
- double listindex = sList.IndexOf(KeynoteNumExcel.ToString());
- Excel.Range line = xlWorkSheet.Rows[i];
- line.Insert();
- xlWorkSheet.Cells[i, 1] = ETN;
- workbook.Save();
- sList.Add(ETN.ToString());
- break;
- }
- else if (KeynoteNumExcel.ToString().Length == 6 && ETN < KeynoteNumExcel)
- {
- double listindex = sList.IndexOf(KeynoteNumExcel.ToString());
- Excel.Range line = xlWorkSheet.Rows[i];
- line.Insert();
- xlWorkSheet.Cells[i, 1] = ETN;
- workbook.Save();
- sList.Add(ETN.ToString());
- break;
- }
- }
- }
- catch { }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement