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