This project has moved and is read-only. For the latest updates, please go here.

 

Assign colors to chart bars with a series ...

first post: pgatto wrote: Hi everyone, I've been working with EPPLUS for a few weeks but I ca...

Access from PHP

first post: felixvandal wrote: Hello there i really really like epplus i like it so much that i ...

latest post: felixvandal wrote: I am asking because i am not able to register the dll to my compute...

.NET Core support?

first post: gaui wrote: I'm curious to know, is there some roadmap to supporting .NET Core?

latest post: swmal wrote: It has not stalled, but we are in the midst of moving from codeplex...

Error throws while loading excel workbook using epplus if excel contains picture and empty row before the content

first post: meygnanam wrote: We are tying to read excel using EPPLUS. In this scenario, if the e...

EPplus, Create Dependent Dropdownlist using C#

first post: abhichaturvedi wrote: I'm working on MVC web app, I want to create new excel sheet with t...

Save generated file but not open it

first post: psilva83 wrote: this was a silly question lol Thanks!

answered by: psilva83 wrote: this was a silly question lol Thanks!

Opening spreadsheets Fail After 100 opens

first post: DrPepper808 wrote: After I open/edit/close about 100 spreadsheets My Class Stalls at ...

Functionalities missing for Chart

first post: saurabhrajguru wrote: Hello, I am creating scatter chart using epplus however i am not ...

Create custom conditionnal formating - C#

first post: Valentin92 wrote: Hi everybody ! I'm using Epplus and I have a question : I know in...

latest post: Valentin92 wrote: Hello, I found a solution which working fine for me. It is specifi...

Scatter Series Chart Custom DataLabel

first post: saurabhrajguru wrote: Hello, I am trying to create a scatter chart with the custom data...

[Sample] Adding Conditional Formatting

first post: SirG69 wrote: Hi, hope this sample will help you to add Conditional Formatting to...

latest post: Valentin92 wrote: Hello, I want to create a custom conditional formatting with an Ic...

Conditional Formatting With Icons

first post: mikeferrer wrote: I need to achieve something like this with Epplus. Can someone ...

latest post: Valentin92 wrote: Hi, I want to do the same thing ([here](http://epplus.codeplex.com...

epplus pie chart colors customization in excels

first post: AshwiniMetasys wrote: Hi, I am using epplus library 4.1 to create excel file using vb...

Out of Memory Exception

first post: Tabish wrote: Started using this library. Was very happy with it Unfortunately ...

latest post: coremanster wrote: I'm using EPPlus with Powershell. So my code will reflect this... ...

Issue Excel found unreadable content

first post: sreddy wrote: Excel found unreadable content in 'sample1.xlsx'. Do you want to re...

latest post: PE wrote: After reading all proposed solutions, I found that using ExcelPacka...

axis reverse order

first post: lulik wrote: I do an export in Excel and draw charts using Epplus: var chart = (...

EPPLUS : Is it possible to get calculated values from macro enabled excel file(.xlsm)??

first post: vineetraikumar wrote: Hi, I am trying to get the calculated value of the particular cel...

latest post: swmal wrote: The formula parser should be able to resolve references to other wo...

Move to GitHub?

first post: gsbell wrote: With CodePlex shutdown, is EPPlus going to be moved to GitHub or el...

latest post: swmal wrote: we have no date, but it will happen before codeplex disappears... w...

ExcelRange/ ExcelRangeBase do really not contain an equals operator?

first post: SeSpoon wrote: if so, should I add one?

AutoFitColumns error: Not a legal OleAut date

first post: jalbertomd15 wrote: I am getting an error, the message is: "Not a legal OleAut date". ...

Different datetime formats in columns

first post: miramares wrote: Hi, In my export I have columns with datetime, string and decimal...

EPPlus 4.1.0 Excel Unreadable content issue

first post: AnandRB wrote: Basically i am building Dynamic Excel using EPPlus 4.1.0. The probl...

InsertRow, Copy worked not correct

first post: evgnib123 wrote: Why is this happening ? There is row pattern B2:F2 Cell B2 = "Tex...

latest post: evgnib123 wrote: downloaded the latest build, problem solved! I apologize...

EPPLUS Pivot Table disable refresh on load

first post: neves82 wrote: I have a very large amount of data in the source data sheet that I ...

EPPlus: group rows in nested way

first post: Yegorych wrote: Hi, Can you please tell whether its possible to have group of rows...

EPPlus: dynamic pivot table using external connection

first post: jeanie77 wrote: I read that EPPlus is supporting pivot tables, but I would need som...

Can I draw freeform with EPPlus?

first post: zumejp wrote: Can I draw freeform with EPPlus? I want to draw freeform like bel...

Get calculated values of the particular cell which has formula to reference the another worksheet

first post: vineetraikumar wrote: Hi, I need to get the calculated value of those cell which has ref...

Not supported vertical text orientation in CellStyles?

first post: ryunakai wrote: I want to set vertical text orientation cell styles. I means like...

latest post: ryunakai wrote: generated styles.xml by Excel <alignment vertical="center" textRota...

How to set GapWidth for bar chart?

first post: Aluniquad wrote: I'm creating histograms with EPPlus (great library, by the way!). I...

latest post: Aluniquad wrote: A well, never mind, after browsing the source of EPPlus I found the...

CodePlex will shutdown: will EPPlus moved to github?

first post: LuciferSam86 wrote: CodePlex will shutdown: will EPPlus moved to github? I know there ...

latest post: swmal wrote: Yes, we will move EPPlus to github due to this. It will happen befo...

How to Add Sheet from One Excel file to another File?

first post: leokaplin wrote: Here is my code in VS2012 SSIS script: Dim GLReconFile As Strin...

How to get value from cell when format is [h]:mm:ss

first post: bob1000 wrote: Hiall good people, Have question if i have column which format is:...

latest post: bob1000 wrote: is this not available in Epplus or anyone any feedback?

Ignore excel error checking or remove green tag on top left of the cell

first post: jasonouellet wrote: Have you add solution to ignore excel error checking or remove gree...

latest post: mrxrsd wrote: I dont think so, u're welcome to fork and submit ur pull request. I...

Will this work on Azure Web Apps? We are getting an error...

first post: raffertyuy wrote: Dear all, We are getting the error below when we deployed to Azure...

Problem with EPPlus - it replaces excel column name contains full stop with hash (#) in DataTable

first post: AkshayRaut wrote: I am using EPPlus library and my excel sheet contains some columns ...

DefaultRowHeight is incorrect

first post: nayuchan wrote: Excel 2013 Book <sheetFormatPr defaultRowHeight="13.5" x14ac:dyDe...

AddPicture and AddShape Error

first post: nayuchan wrote: If DrawingXml already exists, AddPicture and AddShape will fail. Dr...

Source code does not build in VS 2012

first post: jim_software wrote: The build fails at all lines with the => error expected ; pub...

How to read formula cell value where formula is accessing other formula cells?

first post: nzedwin wrote: Hi How to read cell value using EPPlus in the following excel exa...

How to get the conditional formatting applied to the cell?

first post: maurice_hulsman wrote: Hi all, I've been using EPPlus for a project to merge several Exc...

Added sortcondition to filter, but filter is not active

first post: mldz wrote: Hi, I wanted to sort my output using the autofilter in excel. I c...

.NET Core

first post: dannythomas13 wrote: I am currently using this in a new application but have had to targ...

latest post: conniey wrote: **VahidN wrote:** > I've ported this library to .NET Core: > [https...

Server-side Excel library for use with C# and .NET ? Does EPPlus support the features below ?

first post: CiC_Devid wrote: My question would be: Is EPPlus the Excel library I am looking for ...

Format Cell Kilowatts / Hour

first post: samael205 wrote: Hi, I have a cell that contains a value that refers to a Kilowatt...

latest post: samael205 wrote: Resolved with: ``` wsData.Cells[2, (z + 1)].Style.Numberformat.Fo...

Copy Data To New Worksheet

first post: chalupabatman wrote: I have a "Master" worksheet that holds data for all team members. ...

Importing from SpreadsheetML (2003 XML format)

first post: bencurthoys wrote: A nice way of creating spreadsheets would be to start with an XML d...

latest post: SaschaM wrote: Hi, i'am searching for the same thing. Could you share your conver...

EPPlus Formula value resulting in #VALUE!

first post: ashleyabraham wrote: I have an Excel file with a table tblPhoneCode and with two columns...

latest post: ashleyabraham wrote: Opened a new issue work item Weirdly, it works when you don't have...

Format Pivot Table

first post: jendar wrote: I am using the pivot table functionality, which is working out grea...

Slicer and Collapse Row on Pivot Table

first post: jendar wrote: I have been using EPPlus to create a pivot table. So far, things ar...

Copying Drawings

first post: daufderh wrote: I'm looking to copy a Chart (or any Drawing for that matter) from o...

merging xlsx

first post: x20833 wrote: I have a situation where I have multiple xlsx (e..g 5 xlsx and 1 wo...

VB6

first post: hostwap wrote: Hi Is it possible to use epplus to export datagrid in vb6 to exce...

Autoit Language

first post: Virgilio381 wrote: I would use the dll with a written application with Autoit but I ha...

Convert a generated Excel (with OpenXml) to a regular excel format ?

first post: GregoryBisschops wrote: Hi, I have a situation where a customer is rejecting my excel fil...

EPPLUS names note saved

first post: jugurtha wrote: I encountered a surprising problem with the Epplus Library. My conc...

Change Order yAxys with EPPlus

first post: samael205 wrote: I'm doing an excel with epplus that requires generating two graphs ...

latest post: samael205 wrote: Resloved with: ``` chart.YAxis.LabelPosition = OfficeOpenXml.Dra...

Reading cell that calls VBA function returns wrong result

first post: rbish5280 wrote: I have a XLSM file that I am trying to read into a database. One of...

XLSB File Support

first post: bmd174s wrote: I have a client that converted their XLSX files to XLSB for speed, ...

latest post: jmunkberg wrote: This post is fairly old now, wondering if the XLSB Format supported...

Pivot Table Slicers

first post: michaelbradley wrote: Hi Is there functionality in EPPlus to add a slicer(s) to a pivot...

TimeSpan longer than 24 hours

first post: n0e wrote: I am having problem when there is TimeSpan which is longer than 24 ...

File corrupted upon saving

first post: docsaintly wrote: I have a 9 MB Excel file that loads in and is able to read all data...

latest post: docsaintly wrote: After cleaning up the file a bit I found this is related to: http:/...

Filters in Pivot Table

first post: peketo96 wrote: Hi guys, I recently check this project and it's so good. Well, i ha...

latest post: mmstephenson wrote: Assuming you have a List of column names that you want to create fi...

Possible to move to Git?

first post: richardtallent wrote: Hi, I'm curious if the team has considered moving changing from M...

latest post: swmal wrote: EPPlus moving to Github or Bitbucket has been requested multiple ti...

Adding columns to a header

first post: aashish317 wrote: Says I have columns A, B and C, I want to insert three columns betw...

Calculating formulas

first post: baal80 wrote: I am creating a spreadsheet by loading a lot of data from text file...

latest post: PipisCrew wrote: use something like : worksheet2.Cells[row, col].Formula = "SUMIFS(D...

Getting a cellvalue in workbook slowing the performance in result

first post: Hemantguptacest wrote: Hi , dll version : 4.0.5 I am using countifs formula then calcul...

latest post: Hemantguptacest wrote: Thanks for update. I will check and let you know the log details as...

Slow Access to Sheets in large excel packages

first post: MIkeyG0727 wrote: Hi, Fantastic library, cant live without it :) I am creating s...

Excel function PMT does not exist

first post: tryggvig wrote: Hi, Im using the Calculate function on a couple of cells that us...

Open a shared excel file that's in use

first post: tamzak wrote: Hi, I'd like to know if it's possible to open an excel file thats...

latest post: tamzak wrote: Just solved my own question :) If anyone is interested : Read th...

A generic error occurred in GDI+

first post: mahendra72 wrote: I created workflows which generating data in excel files using EPP...

Applying MS Excel Chart Styles to generated Charts

first post: dk2014 wrote: Hi, first of all thank you for this great tool. I need help on ap...

latest post: kevindmonte wrote: **dk2014 wrote:** > Hi, first of all thank you for this great tool....

Access cell by cell name

first post: Helbrax wrote: In excel you can change the name of a cell from the default "A1", "...

latest post: Helbrax wrote: Looks like it's just as simple as ``` package.Workbook.Names.First...

Grouping cells with Subtotals

first post: domeg wrote: Hi, I need to grouping a set of cells including the subtotals. Yo...

Cannot save .xlsm file

first post: testuser13 wrote: Hi I have a file template (.xlsm) what has macro. I would like to...

Column AutoFit with non-standard DPI settings

first post: roverell wrote: When using the ExcelColumn.AutoFit method with non-standard DPI set...

Format Negative Numbers In Parenthesis

first post: sandarminaye wrote: Hello, I am trying to get negative numbers in parenthesis. for e....

Formula Calulate doen't return a value if decimal

first post: andreoslancio wrote: Hello, I'm trying to get the value of some cells where there is a ...

latest post: andreoslancio wrote: Found the issue by myself: FORMULAS MUST NOT CONTAIN SPACES!!!!!! I...

Running EPPlusSamples project for first time

first post: yhpoon wrote: When I try to run the project, the console shows "outputDir does no...

latest post: yhpoon wrote: In order to run Sample 3, 4 and 12 with AdventureWorks sample datab...

very ba doc

first post: stefanomnn wrote: ops... documentation doesn't exist! i prefer to pay something but ...

Generating Excel - missing theme1.xml

first post: Chrzciciel wrote: Hi! When I generate .xlsx file, xl\theme\theme1.xml file is missin...

Excel 2013 or 2016/O365?

first post: klugerama wrote: I've made quite a few customizations to the code - all in charts - ...

Can you load XLTX

first post: mettlus wrote: I have a CSV file and I want to apply a XLTX and save the final tar...

Assembly.LoadFrom doesn't work (4.04 -> 4.1).

first post: Grzesiek23 wrote: Hello, Long time I was loading EPPlus library from the code: Asse...

Trendline Properties

first post: rbelknap wrote: Is there a way to modify the properties of a trend line? For instan...

WEEKNUM <-works in formula vs ISOWEEKNUM <- does not work.

first post: rbelknap wrote: Hi, If I use the code: worksheet.Cells["A" + i].Formula = "=WEEKN...

Size limitations in creating excel sheets

first post: ThorPeto wrote: Hi all I am considering this library for creating excel sheets in...

Formula is not working in Excel 2010 - Error message #¿NOMBRE? showed

first post: leandrol wrote: I insert in the code the next line: .....Formula = String.Format("...

[Merge Request]Adding the possibility to obtain the width and height of an ExcelDrawing

first post: Baccata wrote: Hi guys, I'm using EPPlus to get some information from an Excel sp...

How to hide custom style names in Excel ?

first post: donepudi wrote: Hi, I'm creating programatically more custom styles using Styles....

Formula not working when the formulas are in a table

first post: Vsambhe wrote: Hi, I want to create a copy of a excel file [p.xlsx]. It has two...

latest post: Vsambhe wrote: When the data was in a table, the formula need to be changed in the...

Reading the Used Range

first post: talktodale wrote: After I open the Excel spreadsheet is there a way to determine the ...

latest post: BillMenees wrote: You should also consider Worksheet.Dimension. Its Start and End pr...

Windows form is resized when setting size/location of image/chart/row in excel worksheet

first post: midddle wrote: I'm using epplus to export excel files from a windows forms applica...

latest post: midddle wrote: Found the problem: it seems some libraries are loaded in these situ...

Does EPPlus supports Excel's Goal seek feature?

first post: Nsb_MarkB wrote: Looks like EPPlus supports a lot of Excel features that would be he...

Formula for comparing values from two different worksheets

first post: mmn_stellar wrote: I am creating a workbook that consists of two worksheets. The data...

latest post: vijayagarwal wrote: http://www.talktalkwebmail.org/2016/08/talktalk-webmail-talktalk-ma...

Does not seem to support SSRS Charts

first post: firasjabur wrote: Hi, So I am using .net Microsoft.Reporting.WinForms.LocalReport ...

latest post: vijayagarwal wrote: http://www.talktalkwebmail.org/2016/08/talktalk-webmail-talktalk-ma...

Symbols for the module 'EPPlus.dll' were not loaded. No Worksheets visible in Excel 2013

first post: aktivo wrote: I build web application with this code: ExcelPackage EP = new Excel...

latest post: vijayagarwal wrote: o I am using .net Microsoft.Reporting.WinForms.LocalReport to rende...

Pivot table creation from downloaded excel file does not give expected result

first post: mohnkhan97 wrote: We are allowing user to download the report as an excel format, we ...

latest post: PipisCrew wrote: I dont know, how you cook it^ check my sample at : [external link]...

Problem with row header that has a line feed

first post: faujong wrote: I have XLS file whose column header has a line feed (char(10)) "Op...