Find Last Cell with Text

first post: roh0987 wrote: Hello Everybody. How can we get address of last cell with any text ...

Add Calculated Field to Pivot Table, How to use eShowDataAs enum for ExcelPivotTableField

first post: vb21 wrote: Hi, I am creating a pivot table from a range from another sheet in ...

latest post: epplusrox123 wrote: Hi, I had the same two problems and here's two extension methods w...

ShapeRange.LockAspectRatio?

first post: ova2010 wrote: In EPPlus equivalent to the operator Excel: Selection.ShapeRange.Lo...

Is there a way to tell if a cell is part of a frozen pane?

first post: VB_ wrote: Hi, I was wondering if anyone could tell if there is currently a ...

How can I adjust the width of columns by pixel?

first post: KenHuang wrote: Here is my code when I do this: WorkSheet.Column(1).Width = pixel ...

Scroll to the latest cell modified

first post: jsa4000 wrote: Hello and thanks for your awsome work! By the way, I would want ...

latest post: jsa4000 wrote: Thanks for your help! It works like a charm. Regards, Javier

Need to confirm if certain features are available in EPPlus

first post: TejasSutar wrote: Hi readers, I just want to know if EPPlus provides following featu...

latest post: mrxrsd wrote: Hi, EPPlus only handles Excel files. If you want to generate Word...

Cannot add hyperlink to ExcelShape object

first post: KenHuang wrote: It seems currently ExcelShape object does not support hyperlink jus...

Problem with using ROUND in a formula.

first post: ThomasBraun66 wrote: Hi, In one project I'm creating a total value with the following ...

latest post: ThomasBraun66 wrote: **swmal wrote:** > Hi, use comma instead of semicolon. Works like ...

answered by: swmal wrote: Hi, use comma instead of semicolon.

EPPlus error with ajax request

first post: ddepuemd wrote: I cannot seem to get the download to work - I keep getting garbage....

latest post: akronite wrote: You're requesting it via AJAX? Try doing it via a normal form...