private S8Spreadsheet.Cell createCell(int row, int col, VariableType type) { S8Spreadsheet.Cell tmpCell = new S8Spreadsheet.Cell(); tmpCell.CellType = type; tmpCell.Row = row; tmpCell.Col = col; return(tmpCell); }
private List <S8Spreadsheet> LoadSpreadsheet(List <Variable> ssVariable) { List <S8Spreadsheet> NewSS = new List <S8Spreadsheet>(); for (int i = 0; i < ssVariable.Count; i++) { S8Spreadsheet tt = (S8Spreadsheet)ssVariable[i].Value; } for (int i = 0; i < ssVariable.Count; i++) { string lineReaded = null; string ssFilename = xmlBase + ssVariable[i].Name + ".csv"; string path1 = System.Web.Hosting.HostingEnvironment.MapPath(ssFilename); StreamReader ssReader = new StreamReader(path1); S8Spreadsheet tempSheet = new S8Spreadsheet(); S8Spreadsheet.Cell tmpCell = null; tempSheet.ColCount = 5; tempSheet.RowCount = Convert.ToInt16(ssReader.ReadLine()); //ResulttextBox.Text += "1=>"+tempSheet.Cells.Count+" \r\n"; lineReaded = ssReader.ReadLine(); //hospital name tmpCell = createCell(1, 1, VariableType.Text); tmpCell.Value = String.Copy(lineReaded); tempSheet.Cells.Add(tmpCell); // plist lineReaded = ssReader.ReadLine(); //ARRIVAL tmpCell = createCell(2, 1, VariableType.Text); tmpCell.Value = String.Copy(lineReaded); tempSheet.Cells.Add(tmpCell); lineReaded = ssReader.ReadLine(); //TBA, Number string[] parseText = lineReaded.Split(new string[] { ", " }, StringSplitOptions.RemoveEmptyEntries); tmpCell = createCell(3, 1, VariableType.Text); tmpCell.Value = parseText[0]; tempSheet.Cells.Add(tmpCell); tmpCell = createCell(3, 2, VariableType.Text); tmpCell.Value = parseText[1]; tempSheet.Cells.Add(tmpCell); int count = Convert.ToInt16(ssReader.ReadLine()); for (int j = 0; j < count; j++) { int rowIdx = 4 + j; lineReaded = ssReader.ReadLine(); parseText = lineReaded.Split(new string[] { ", " }, StringSplitOptions.RemoveEmptyEntries); tmpCell = createCell(rowIdx, 1, VariableType.Number); tmpCell.Value = parseText[0]; tempSheet.Cells.Add(tmpCell); tmpCell = createCell(rowIdx, 2, VariableType.Number); tmpCell.Value = parseText[1]; tempSheet.Cells.Add(tmpCell); } // nlist lineReaded = ssReader.ReadLine(); //SERVICE tmpCell = createCell(2, 3, VariableType.Text); tmpCell.Value = String.Copy(lineReaded); tempSheet.Cells.Add(tmpCell); lineReaded = ssReader.ReadLine(); //TBA, Number, Time parseText = lineReaded.Split(new string[] { ", " }, StringSplitOptions.RemoveEmptyEntries); tmpCell = createCell(3, 3, VariableType.Text); tmpCell.Value = parseText[0]; tempSheet.Cells.Add(tmpCell); tmpCell = createCell(3, 4, VariableType.Text); tmpCell.Value = parseText[1]; tempSheet.Cells.Add(tmpCell); tmpCell = createCell(3, 5, VariableType.Text); tmpCell.Value = parseText[2]; tempSheet.Cells.Add(tmpCell); count = Convert.ToInt16(ssReader.ReadLine()); //plist for (int j = 0; j < count; j++) { int rowIdx = 4 + j; lineReaded = ssReader.ReadLine(); parseText = lineReaded.Split(new string[] { ", " }, StringSplitOptions.RemoveEmptyEntries); tmpCell = createCell(rowIdx, 3, VariableType.Number); tmpCell.Value = parseText[0]; tempSheet.Cells.Add(tmpCell); tmpCell = createCell(rowIdx, 4, VariableType.Number); tmpCell.Value = parseText[1]; tempSheet.Cells.Add(tmpCell); tmpCell = createCell(rowIdx, 5, VariableType.Number); tmpCell.Value = parseText[2]; tempSheet.Cells.Add(tmpCell); } NewSS.Add(tempSheet); } return(NewSS); }