EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx).
EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx).
Questions tagged [epplus-4]
189 questions
0
votes
0 answers
Read 1st Column of Excel Workbook Into Array
Use OpenFileDialogwith EPPlus. I get a compile error of:
The name 'sheet' does not exist in the current context
Now, the obvious issue is how do I associate the selected Excel file with my EPPPlus & 2 what do I do to remove the error above?
using…
Big Pimpin
- 427
- 9
- 23
0
votes
0 answers
GetByteAsArray() takes long time
I'm trying to generate excel (.xlsx) file and store it using EPPLUS for some huge records (around 20k rows and 1.5k columns).
When I use EPPLUS 3.0.0.2 I can not create excel file due to OutOfMemory issue, and now I'm using EPPLUS 4.0.2 and I can…
RaJesh RiJo
- 4,302
- 4
- 25
- 46
0
votes
1 answer
Chart X-Axis date and time
I create an Excel document using EPPlus and C#. In a content worksheet I have several Rows containing a datetime and a value. Then I use the following code to create a chart:
var wsPressure = pck.Workbook.Worksheets.Add( "Pressure" );
var…
Sascha
- 10,231
- 4
- 41
- 65
-1
votes
2 answers
Protect Excel With Allow Sort and Allow Auto Filter C#
I'm using EPPLUS.dll for doing my excel works
I tried to protect the worksheet using AllowSort and AllowAutoFilter Properties but it's not working.
worksheet.Protection.AllowSort = true;
worksheet.Protection.AllowAutoFilter =…
Arad Aryan
- 1
- 4
-1
votes
1 answer
Send Excel file data with formatting as email body
I want to send excel data with formatting in an email body. I want to use C# as the language and will use Epplus library to read excel data.
I just want to automate that code and make an application. I have knowledge of how to send an email and…
Sasuke Uchiha
- 91
- 1
- 10
-1
votes
1 answer
Why am I getting, "Cannot implicitly convert type 'void' to 'object'" with this code (EPPlus)?
I was using this code to populate a cell in a spreadsheet using EPPlus:
using (var footerMonth1Cell = prodUsageWorksheet.Cells[columnFooterRow, MONTH1_COL])
{
footerMonth1Cell.Value = monthsTruncatedYears[0];
footerMonth1Cell.Style.Font.Size…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
-1
votes
1 answer
Why are the text labels not being added to these cells (EPPlus)?
I have a row of column headers that I'm setting up like so:
private static readonly int COLUMN_HEADER_ROW = 6;
private static readonly int COLUMN_COUNT = 15;
private static readonly int COLUMN_HEADER_ROW_HEIGHT = 48;
private static readonly int…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
-1
votes
1 answer
Why is my bitmap appearing off-centered (one cell too far right and down)?
I have this EPPlus code to place a bitmap on an Excel spreadsheet at column 5/E, row 1:
using (var package = new ExcelPackage(file))
{
. . .
AddImage(locationWorksheet, 1, 5, imgPath);
. . .
}
private void AddImage(ExcelWorksheet…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
-3
votes
2 answers
Generate unique name for multiple worksheets in a for loop
I am using for loop to generate some worksheets, and I want to give each one a unique name. All I get is Sheet1, Sheet2, Sheet3, and so on.
Below is my code:
var package = new ExcelPackage();
for (var i = 0; i < ds.Tables.Count; i++)
{
var ws…
J. Raj
- 55
- 7