public override void WriteTo(XlsWriter writer, int param = 0)
{
//writer.SetBorder(BorderTop, BorderLeft, BorderRight, BorderBottom);
var oldStyle = writer.MergeStyle(Style);
try
{
// writer.ShrinkToFit = ShrinkToFit;
writer.AddCell(ColSpan, RowSpan);
writer.SetValue(GetValue());
if (Width != null)
{
writer.SetColumnWidth((int)Width);
}
/*
* if (Style.AutoWidth ?? false /*AutoSize♥1♥)
* {
* if (ColSpan > 0 && RowSpan > 0)
* writer.AutoSizeColumn(true);
* else
* writer.AutoSizeColumn();
* }
*/
}
finally
{
writer.Style = oldStyle;
}
}
public override void WriteTo(XlsWriter writer, int param = 0)
{
// using (var rowWriter = writer.AddRowArea())
var oldStyle = writer.MergeStyle(Style);
try
{
foreach (var item in Items)
{
if (item.GetRows() == 0)
{
continue;
}
// using (var colWriter = rowWriter.AddColArea())
using (var rowWriter = writer.AddRowArea())
{
item.WriteTo(rowWriter, param);
}
}
}
finally
{
writer.Style = oldStyle;
}
}
public async Task <ActionResult <ExportResultViewModel> > ExportReferential(ExportOptionsViewModel options)
{
IList <ExchangeDataRow> models = new List <ExchangeDataRow>();
var exportResult = new ExportResultViewModel();
if (options.IncludeFamily)
{
await ExportFamilies(models, options, exportResult);
}
if (options.IncludeCategory)
{
await ExportCategories(models, options, exportResult);
}
using var memo = new MemoryStream();
switch (options.FileType)
{
case ".xlsx":
{
using var xlsxWriter = new XlsWriter <ExchangeDataRow>(options, models, memo);
xlsxWriter.Write();
exportResult.FileMimeType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
break;
}
case ".csv":
{
using var stmWriter = new StreamWriter(memo);
using var csvWriter = new CsvWriter <ExchangeDataRow>(options, models, stmWriter);
exportResult.FileMimeType = "text/csv";
csvWriter.Write();
stmWriter.Close();
break;
}
case ".xml":
{
using var stmWriter = new StreamWriter(memo);
using var xmlWriter = new XmlWriter <ExchangeDataRow>(options, models, stmWriter);
exportResult.FileMimeType = "application/xml";
xmlWriter.Write();
stmWriter.Close();
break;
}
}
exportResult.FileContent = memo.ToArray();
return(Ok(exportResult));
}
public override void WriteTo(XlsWriter writer, int param = 0)
{
var oldStyle = writer.MergeStyle(Style);
try
{
// writer.SetBorder(BorderTop, BorderLeft, BorderRight, BorderBottom);
writer.AddCell(ColSpan, RowSpan);
writer.SetValue(Value);
if (Width != null)
{
writer.SetColumnWidth((int)Width);
}
}
finally
{
writer.Style = oldStyle;
}
}
