Giter VIP home page Giter VIP logo

Comments (4)

sheikhziadahmed avatar sheikhziadahmed commented on May 14, 2024

I am having similar problem with it. When there is no data, it just gives generic names to columns. Such as Column1, Column2 etc. Is there a work around?

from epplus.

sheikhziadahmed avatar sheikhziadahmed commented on May 14, 2024

For now I am using this approach:

                    var i = 1;
                    ExcelWorksheet worksheet = null;
                    worksheet = package.Workbook.Worksheets.Add(worksheetsName);
                    worksheet.Cells.LoadFromDataTable(dt, true, OfficeOpenXml.Table.TableStyles.Medium13);
                    if (dt.Rows.Count == 0) {
                        foreach (DataColumn Column in dt.Columns)
                        {
                            worksheet.Cells[1, i].Value = Column.ColumnName;
                            i++;
                        }
                    }

Not the perfect way, but should work fine in this case.

from epplus.

gdau avatar gdau commented on May 14, 2024

My workaround was similar (except I add an empty row to the data rather than modify the output sheet) - I did it this way because I didn't want to interfere with any kind of header formatting (not sure if your way would or not).

                connection.Open();

                var command = connection.CreateCommand();
                command.CommandText = definition.Query;

                var reader = command.ExecuteReader();
                var data = new DataTable();

                data.Load(reader);

                // Workaround: create dummy row if datatable is empty otherwise the produced sheet
                // contains no column headers.
                if (data.Rows.Count == 0)
                {
                    var emptyData = new DataTable();

                    foreach (DataColumn column in data.Columns)
                    {
                        emptyData.Columns.Add(new DataColumn(column.ColumnName));
                        emptyData.Rows.Add(emptyData.NewRow());
                    }

                    return emptyData;
                }

                return data;

from epplus.

RKDMax avatar RKDMax commented on May 14, 2024

I used the workaround as well -- but I simplified it to append an empty row to the existing datatable instead of instantiating and returning a new one:

if (data.Rows.Count == 0)
{
    data.Rows.Add(data.NewRow());
}

from epplus.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.