/// <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);
}
