Inserting the MEDIAN and QUARTILE functions

Inserting more statistical functions.

Id #9431 | Release: None | Updated: Today at 8:02 PM by morraf | Created: Today at 2:04 PM by morca

Cannot use with .Net 4

Hi, I've been trying to use ClosedXML with .NET4, I've installed the proper installation (tried a few versions), downloaded the DocumentFormat.OpenXml.dll file for 4 (And for 3.5), and also tried ...

Id #9430 | Release: None | Updated: Apr 21 at 7:47 PM by Pitterling | Created: Apr 21 at 10:54 AM by liadbitton

Excel workbook corrupt after saving

I have an xlsx workbook that is used as a template. Through a ridiculous amount of coding, I have built a library using OpenXML that almost preserves all formatting of the original file after upda...

Id #9429 | Release: None | Updated: Apr 14 at 2:02 PM by BSparkes | Created: Apr 14 at 2:02 PM by BSparkes

Unreadable content in Excel file after deleting sheets

I have a template .xlsx file which I open with ClosedXML, populate with necessary info, and depending on the user options, delete some irrelevant sheets (mostly the empty ones). Then I save the fil...

Id #9428 | Release: None | Updated: Apr 13 at 11:34 AM by igitur | Created: Apr 13 at 11:27 AM by igitur

Pivot table tabular form closedxml

I am creating a Pivot Table, and I want to put the resulting table in a tabular form to show the row labels instead of the legend "row labels" and so with the columns. I have tried with (IXLPivot...

Id #9427 | Release: None | Updated: Mar 19 at 3:14 PM by alemanoso | Created: Mar 19 at 3:14 PM by alemanoso

Improve performance

Hi There is room for performance improvements in ClosedXML. To create a performance base line I updated the sandbox example in the branch

Id #9425 | Release: None | Updated: Mar 12 at 5:32 PM by MDeLeon | Created: Feb 26 at 7:14 PM by AlbinSunnanbo

get column name from index

To get the name of a column based on it's index, I added the following function to XlWorksheet. This will return "A3" for columnindex=1 and rowindex=3 -> the columnindex is 1-based public static...

Id #9424 | Release: None | Updated: Feb 25 at 11:44 AM by d4e666 | Created: Feb 25 at 11:44 AM by d4e666

Export empty DataTable ignores DataColumn Caption

In the current implementation, when exporting a DataTable to excel via InsertTable method, if a DataColumn.Caption is not null or whitespace then the DataColumn.Caption string is taken into account...

Id #9423 | Release: None | Updated: Feb 25 at 11:36 AM by nannez | Created: Feb 25 at 9:01 AM by vittoso

While Writing to Excel file its throwing an error "'.', hexadecimal value 0x00, is an invalid character."

Hi All, While Writing to Excel File using the ClosedXML facing an issue. Above is the error mentioned into caption which I am getting. Have attached the Excel File which I am trying to Write by...

Id #9421 | Release: None | Updated: Apr 14 at 4:06 PM by Kragen2uk | Created: Feb 12 at 8:15 AM by samirmsoni

When trying to retrieve value of a formula, ClosedXML throws 'Identifier Expected' Exception

I am using ClosedXML 0.76.0 to build my application, which handles Excel files. At one moment, I populate an Excel file with formulas. So far, so good. The user then gets this file and fills in...

Id #9419 | Release: None | Updated: Feb 2 at 2:16 PM by neuron_upheaval | Created: Feb 2 at 12:05 PM by neuron_upheaval