Comments (4)
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.
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.
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.
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)
- INSERTROW System.ArgumentOutOfRangeException HOT 1
- Prevent index out of array bounds exception
- Exporting to excel shows date time value as UTC time while using EPPlus
- What is the status of this project? Is it still active? HOT 23
- NET Core doesn't support SignedCms yet.
- Does EPPLUS support Axis Title font format and series color change in scatterchart
- The type initializer for 'Gdip' threw an exception.Unable to load shared library 'libgdiplus' or one of its dependencies HOT 1
- Sumsq issue HOT 1
- Carriage return not retained
- Row_Delete doesn't delete the whole row
- .Net Core 3.0: use of foreach loop causes Excel file to balloon HOT 2
- Formula Calculation in 4.5.3.3 has bug after calculate call the cell value property return #Value HOT 4
- [NullReferenceException] ResetPageOffset HOT 1
- Don't work PrinterSettings with net core 3.1 HOT 1
- excelWorksheet.InsertRow NullReferenceException HOT 1
- Calculate() breaks the resulting value HOT 9
- Exception on loading xlsx having multiple `_xlnm.Print_Area`
- "Start cell Address must be less or equal to End cell address" Exception
- TokenHandler uses static TokenSeparatorHandler which ignores custom ITokenSeparatorProvider HOT 1
- Property Indexed of class ExcelColorXml always returns 0
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from epplus.