Create excel file with c#

Question

I have a problem: I have to generate a class in C# to create an Excel file, but I’m not getting it.

Someone can help me?

The idea is to generate an Excel file with a menu and a line with values.

Answer 1

The best tool I know to do what you need is the Epplus. There are several answers from me on the site regarding.

I’ll make a small tutorial for you on how to use.

The minimum

using (var excelPackage = new ExcelPackage())
{
    excelPackage.Workbook.Properties.Author = "Jaderson Pessoa";
    excelPackage.Workbook.Properties.Title = "Meu Excel";

    // Aqui você coloca a lógica que precisa escrever nas planilhas.

    string path = @"C:\teste.xlsx";
    File.WriteAllBytes(path, excelPackage.GetAsByteArray());
}

Adding a spreadsheet and writing to it

using (var excelPackage = new ExcelPackage())
{
    excelPackage.Workbook.Properties.Author = "Jaderson Pessoa";
    excelPackage.Workbook.Properties.Title = "Meu Excel";

    // Aqui simplesmente adiciono a planilha inicial
    var sheet = excelPackage.Workbook.Worksheets.Add("Planilha 1");
    sheet.Name = "Planilha 1";

    // Títulos
    var i = 1;
    var titulos = new String[] { "Título Um", "Título Dois", "Título Três" };
    foreach (var titulo in titulos)
    {
        sheet.Cells[1, i++].Value = titulo;
    }

    // Valores
    i = 1;
    var valores = new String[] { "1", "2", "3" };
    foreach (var valor in valores)
    {
        // Aqui escrevo a segunda linha do arquivo com alguns valores.
        sheet.Cells[2, i++].Value = valor;
    }

    string path = @"C:\teste.xlsx";
    File.WriteAllBytes(path, excelPackage.GetAsByteArray());
}

I think this is a good start for your Class C#.

Answer 2

I believe that to have a control at this level of an excel without buying a third lib you can use the Interop of the. net framework itself.

https://msdn.microsoft.com/pt-BR/library/dd264733.aspx

And here is a complete guide on how to create excel spreadsheets using Interop

https://msdn.microsoft.com/pt-br/library/ms173186(v=vs.80). aspx

Try to follow the content of these links and supplement your question with questions about the implementation itself, so much so I can complement the answer to help you as other people can also help you better.