EPPlus | Create advanced Excel spreadsheets using .NET | Data Visualization library

1. Having an existing Excel XLSX file with a table and data.
2. This table is filtered. E.g. it would have 5 rows without a filter and is currently filtered to only have 3 rows visible.
3. I want to use EPPlus to read that very filtered 10 rows from the XLSX file.

This is how the table could look like when being unfiltered:

And this is how the table could look like when being filtered:

Is it possible to get only those filtered rows via EPPlus in C#?

I've searched through various issues in the EPPlus repository as well as through Google in general and did not find one single similar question/answer.

It seems that this is possible via PIA and Excel Interop, but I want to do it without any Office dependency.

I use the EPPlus plugin to get information from Excel.The following code works perfectly, but how to control it when it gets an error after it reaches the empty Excel cell?

I'm trying to add an image to an excel worksheet with powershell 5. and VSCode.

I get these errors:

C:\CC_SnapViews\EndToEnd_view\path is correct\file.bmp does not exist (but it's there)

Multiple ambiguous overloads found for "AddPicture" and the argument count: "2"

When I search the internet, this error isn't coming up in the search. I was following these examples:

addPicture

addPicture github

This is my code:

When trying to get data from a list (created by an excel spreadsheet) in my HomeController, I run into an issue where the data is generated, but I'm unable to produce it onto a webpage. If I try to generate it using the model from the page directly, I get System.NullReferenceException: 'Object reference not set to an instance of an object.' With out it even loading to the initial page.

My HomeController (Removed some items from the list for demonstration of issue):

I am having an error when trying to delete thousands of rows from an excel file.

I am using EPPlus in C# to do the modifying of the data.

This is the code that I am running to do the deletion:

I am creating a excel document via x++ using OfficeOpenXml Api, but I have no idea how to merge cells (Columns specifically). I have found how to do it with COM, there is a way to do it with the mentioned Api?

If the solution from Merge cells using EPPlus? is used, an Invalid token '.'. compiler error is shown:

I am trying to get an column formatted as a number. I want it with 1000 separator and red prentices. I am using Epplus 5.7.5 and C# .net 4.72 Some reason it just ignores this formatting.

I would like to export a excel file with a inner join datagridview by using EPPLUS.

How should I do for this line? excelWorksheet1.Cells.LoadFromCollection<>(dataGridView4.DataSource as List<>, true);

...

I cannot find a way to style a single excel cell in different styles. For example I need to make only some part of the string bold and leave the rest unbold in one cell. I can only access Cells not characters in EPPlus.

Excel Image

Usually what I do to style the cell is,