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
1 answer
How can I get "Grand Total" vals to average rather than sum?
I am getting (gratis) a "Grand Total" column in my PivotTable:
For "TotalQty" and "TotalPrice" this is great, but for "AvgPrice" and "PrcntgOfTotal" not so much.
How can I get these vals to show the average in the first case rather than a sum?
the…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
0
votes
1 answer
Using Epplus to import data from an Excel file to SQL Server database table
I've tried implementing thishttps://www.paragon-inc.com/resources/blogs-posts/easy_excel_interaction_pt6 on an ASP.NET MVC 5 Application.
//SEE CODE BELOW
[HttpPost]
public ActionResult Upload(HttpPostedFileBase file)
{
var…
Reube Mugambi
- 21
- 1
- 5
0
votes
2 answers
EPPlus - Creata a new file, Formula remaining same in all rows when source data is in the datatable
I want to create a copy of a excel file [p.xlsx]. It has two spreadsheets - sheet1 and sheet2. I create another file perror.xlsx by using p.xlsx as a template file.
Sheet1 data is as follows (second column has a formula):
COL1, COl2
MICK1,=A2…
Vijay Sambhe
- 29
- 2
0
votes
0 answers
How to get Excel cells range font color using EPPlus 4.1 and LookupColor method?
It appears LookupColor() always returns black ("FF000000") not the actual font color when called like this:
var color = worksheet.Cells[1,1,1,5].Style.Font.Color.LookupColor();
It could be a bug, but I would love to hear if someone is using this…
Emil
- 2,196
- 2
- 25
- 24
0
votes
1 answer
Why is the Excel formula not formulating?
I'm creating a spreadsheet with EPPlus. I am trying to get a formula to calculate a sum of values with this code:
using (var totalOccurrencesCell = priceComplianceWorksheet.Cells[rowToPopulate, 2])
{
totalOccurrencesCell.Style.Font.Size =…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
0
votes
1 answer
How can I pre-select the fields to be included in a PivotTable?
I've got this EPPlus code to create a PivotTable:
private void AddPivotTable()
{
string colAlphaRowNum = string.Format("A{0}", locationWorksheet.Dimension.End.Row+5);
ExcelAddressBase eab = locationWorksheet.Cells[colAlphaRowNum];
…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
0
votes
1 answer
How can I set what is called "PrintTitleRows" in Excel Interop using EPPlus?
I've got this Excel Interop code:
_xlSheetFillRateByDCByLocation.PageSetup.PrintTitleRows = String.Format("${0}:${0}", BYDCBYLOC_HEADING_ROW);
I want to accomplish the same with EPPlus.
I tried…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
0
votes
1 answer
Files are always Read-only when Using EPPLUS to generate Excel file from Database table
I'm using EPPLUS to generate Excel file from Database table but the file created stay on Read-only mode until the full SSIS process is stopped.
I need to move the file after later in the process and this will always fail with the following message…
Kilren
- 395
- 4
- 12
0
votes
0 answers
Modifying an existing Stacked Column chart with EPPlus
So this is my question, i have an excel report with a nicely formatted stacked column report. Is it possible to find and edit the existing chart as apposed to creating a new one. The number of series points is dynamic ( the values would be on the…
jsteege
- 11
- 4
0
votes
1 answer
Excel time validation for a range using EPPlus
I want to validate a column in Excel using EPPlus for time range like 1:00 PM to 11:00 AM.
Time must be "hh:mm AM/PM" format.
I solved the problem. Here is the code :
var validationEndTime =…
hasnayn
- 356
- 4
- 22
0
votes
0 answers
Add auto fill suggestion programmatically in Excel using EPPlus and C#
I am trying to create an excel with auto fill suggestion for the cells of a specific column.
Let in my generated excel there is a column called "Name". When user write name they will get some suggestion added by me.
So, I want to add auto fill…
hasnayn
- 356
- 4
- 22
0
votes
0 answers
Append object[,] data in Excel using EPPlus
How can I append object[, ] data in Excel using EPPlus?
I'm using the following code but it returns System.Object as the result in Excel.
object[,] rowdate = new object[dt.Rows.Count, Nodes.Split(',').Length * 2 + 4];
ExcelRange _excelRange =…
Jansi Rani
- 1
- 3
0
votes
2 answers
Exception occurs reading spreadsheet after saving ExcelPackage (EPPlus)
I am manipulating data in a .xlsx spreadsheet using EPPlus (4.0.4) and saving the file, immediately afterwards I am loading parts of the data into datatables.
After I call the .Save() method the spreadsheet is saved but then I get a 'External table…
plm
- 13
- 3
0
votes
1 answer
Can EPPLUS read sections of Excel worksheets?
I use the following code to read in an excel file creating a package:
Public _package As ExcelPackage = Nothing
Dim flInfo As New FileInfo(FILENAME)
_package = New ExcelPackage(flInfo) 'load the excel file
This code is great when I want to…
Eddy Jawed
- 457
- 6
- 17
0
votes
1 answer
How do i write this Ranking formula?
I have a worksheet as shown in the attached image. I want to perform ranking for each position cell based on the corresponding Term (FirstTerm, Second, Third, Annual). I have tried but cant figure a way to write the formula. I am using EPPlus
I…
Okolie Solomon
- 486
- 7
- 8