filling an excel sheet with data asp.net mvc

Question

I am writing a routine to create and fill an Excel sheet in ASP.NET MVC. The object that I want to transfer to the sheet is a List, where T is a structure.

Do you know of any piece of code that does this?

The constructor that do this is:

using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
… 
 public byte[] ExcelContent;

 public ExportExcel(List<OrdViewModel> ol)
        {
            MemoryStream memstream = new MemoryStream();

            SpreadsheetDocument XlsxDoc = SpreadsheetDocument.Create(memstream, SpreadsheetDocumentType.Workbook);

            WorkbookPart workbookpart = XlsxDoc.AddWorkbookPart();
            workbookpart.Workbook = new Workbook();

            // Add a WorksheetPart to the WorkbookPart.  
            WorksheetPart worksheetPart = workbookpart.AddNewPart<WorksheetPart>();
            worksheetPart.Worksheet = new Worksheet(new SheetData());

            // Add Sheets to the Workbook.  
            Sheets sheets = XlsxDoc.WorkbookPart.Workbook.
                AppendChild<Sheets>(new Sheets());

            Sheet sheet = new Sheet()
            {
                Id = XlsxDoc.WorkbookPart.GetIdOfPart(worksheetPart),
                SheetId = 1,
                Name = "Sheet1"
            };
            sheets.Append(sheet);

            // code here…

            XlsxDoc.Close();

            ExcelContent = memstream.ToArray();
}

What are you asking, exactly? Does this code not work for you? Does it throw an error? Does it not give you the desired output? — Casey Crookston
– Casey Crookston, Commented Jan 17, 2020 at 17:07
This code was taken from a site. Where I say // code here… is where I want to insert the code to fill the excel document. In this moment, I have no code where is the above tag... — JDias
– JDias, Commented Jan 17, 2020 at 17:35
So write it yourself? Stack Overflow isn't here to do that for you, we're here to assist with problems with code you've written. — Ian Kemp - SO dead by AI greed
– Ian Kemp - SO dead by AI greed, Commented Jan 17, 2020 at 20:50
Problem solved (almost…) in the question stackoverflow.com/questions/59825738/… — JDias
– JDias, Commented Jan 20, 2020 at 14:50

Roman.Pavelko · Accepted Answer · 2020-01-17 18:48:34Z

1

You can use my SwiftExcel library. It was designed to maximize performance and minimize memory usage when writing to Excel:

public ExportExcel(List<OrdViewModel> ol)
{
    using (var ew = new ExcelWriter("C:\\temp\\test.xlsx"))
    {
        for (var row = 1; row <= ol.Count; row++)
        {
            var item = ol[row-1];
            ew.Write(item.YourProperty1, 1, row);
            ew.Write(item.YourProperty2, 2, row);
            ew.Write(item.YourProperty3, 3, row);
            ew.Write(item.YourProperty4, 4, row);
        }
    }
}

edited Jan 17, 2020 at 18:48

answered Jan 17, 2020 at 18:39

Roman.Pavelko

1,6952 gold badges19 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

filling an excel sheet with data asp.net mvc

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related