/// <summary> /// 複数の<see cref="AdvCommandXLWorkSheet"/>を保持するクラスのコンストラクタです。 /// </summary> /// <param name="xlWorkSheets">基となる<see cref="IXLWorksheets"/>です。</param> public AdvCommandXLWorkSheets(IXLWorksheets xlWorkSheets) { this.advCommandXLWorkSheets = new List <AdvCommandXLWorkSheet>(); foreach (IXLWorksheet xlWorkSheet in xlWorkSheets) { this.advCommandXLWorkSheets.Add(new AdvCommandXLWorkSheet(xlWorkSheet)); } }
public static IXLWorksheet GetSheet(IXLWorksheets worksheets, string sheetName) { if (worksheets == null) { return(null); } foreach (IXLWorksheet sheet in worksheets) { if (sheet.Name == sheetName) { return(sheet); } } return(null); }
/// <summary> /// Default values and controls are loaded on page. /// </summary> /// <param name="sender">Object Sender is a parameter called Sender that contains a reference to the control/object that raised the event.</param> /// <param name="e">EventArgs is a parameter called e that contains the event data</param> protected void Page_Load(object sender, EventArgs e) { try { string rowJsonText = Server.UrlDecode(Request.Form[Constants.HTTP_CONTENT]); string jsonText = rowJsonText.Replace(Constants.PIPE_SEPARATOR, Constants.NEWLINE); if (!string.IsNullOrWhiteSpace(jsonText)) { using (XLWorkbook workBook = new XLWorkbook()) { IXLWorksheets workSheets = workBook.Worksheets; IXLWorksheet workSheet = workSheets.Add(Constants.SHEET_NAME); string[] excelHeaders = Constants.EXCEL_HEADERS.Split(Constants.CHAR_SEMICOLON); AddColumnHeaders(workSheet, excelHeaders); AddDataToExcel(jsonText, workSheet); Response.Clear(); Response.Buffer = true; Response.Charset = string.Empty; Response.ContentType = Constants.CONTENT_TYPE; Response.AddHeader(Constants.EXCEL_HEADER_NAME, string.Format(CultureInfo.InvariantCulture, Constants.EXCEL_HEADER_VALUE, Constants.EXCEL_FILENAME, string.Format(CultureInfo.InvariantCulture, string.Concat(Constants.ZERO_PLACEHOLDER, Constants.EXPORT_TO_EXCEL_FILENAME_DATEFORMAT, Constants.CLOSING_BRACKET), Convert.ToDateTime(DateTime.Now, CultureInfo.InvariantCulture)))); using (MemoryStream memoryStream = new MemoryStream()) { workBook.SaveAs(memoryStream); memoryStream.WriteTo(Response.OutputStream); } } } else { // Do logging } } catch (Exception) { // Do logging } finally { Response.Flush(); Response.End(); } }
private static Dictionary <string, List <Tuple <string, string, string> > > GenerateWorkloadDic(IXLWorksheets xlLists) { var mapWorkLoad = new Dictionary <string, List <Tuple <string, string, string> > >(); foreach (var worksheet in xlLists) { string emplName = worksheet.Cell("A4").Value.ToString();//Имя преподавателя if (!mapWorkLoad.ContainsKey(emplName) && !String.IsNullOrEmpty(emplName)) { var listTup = new List <Tuple <string, string, string> >(); for (int i = 13; i < 150; i++) { var cell = worksheet.Cell("B" + i); if (!cell.Style.Font.Bold && !String.IsNullOrEmpty(cell.Value.ToString())) { var syllabus = worksheet.Cell("B" + i).Value.ToString(); //Учебный план var disc = worksheet.Cell("E" + i).Value.ToString(); //Дисциплина var sem = worksheet.Cell("F" + i).Value.ToString(); //Семестр var tup = Tuple.Create(syllabus, disc, sem); listTup.Add(tup); } } mapWorkLoad[emplName] = listTup; } } return(mapWorkLoad); }
public void writeSolution(string[] data, IXLWorksheets ws, string sheetName) { var originalSolution = ws.Worksheet(sheetName); importData(data, originalSolution); }