How to update/formatting existing excel (like template) file?

Please guide me for How to update/formatting existing excel (like template) file? I have tried below code but it's give error. // FilePath - c drive temp folder string tempFile = FilePath +...

Id #9491 | Release: None | Updated: Mon at 11:16 AM by amitjoshiTTI | Created: Mon at 11:15 AM by amitjoshiTTI

System out of memory(Hide row)

How to hide a row from 1000 to 1048576 it will show some error message like System out of memory

Id #9490 | Release: None | Updated: Apr 22 at 6:14 AM by Alavudeen_soft | Created: Apr 22 at 6:14 AM by Alavudeen_soft

'', hexadecimal value 0x1A, is an invalid character.

When trying to write a datatable in .net to an Excel file with someout put from a third party I get an error message as per the subject line. '', hexadecimal value 0x1A, is an invalid character...

Id #9489 | Release: None | Updated: Apr 20 at 2:17 PM by SimonPrice33 | Created: Apr 20 at 2:17 PM by SimonPrice33

Umlauts in hyperlinks to files have wrong encoding

Trying to add hyperlinks pointing to a file on a network share containing umlauts in the path (e.g. "X:\Pläne\list.xlsx") - yes, I know what should be done to people creating these folders ;) I ...

Id #9488 | Release: None | Updated: Apr 13 at 4:04 PM by Flominator | Created: Apr 13 at 3:58 PM by Flominator

Multiple save() causes cell formating to break

Scenario: Open excel file from file and add DateTime to A1. Call Save() for 50 times. Open file in Excel. I see double instead of datetime. Each call to Save() adds next entry to <x:numFmts>, <...

Id #9487 | Release: None | Updated: Mar 31 at 12:41 PM by blackzork | Created: Mar 31 at 12:41 PM by blackzork

Setting DataType for entire column leads to huge memory consumption

Hi guys, Just have found a weird bug: Create a workbook and a worksheet in it. Set data type for entire column to Text. This operation adds around 350Mb (on my x64 machine) to the process memor...

Id #9486 | Release: None | Updated: Mar 25 at 2:54 PM by a_llex | Created: Mar 25 at 2:54 PM by a_llex

error saving file with databars

Hello, Trying to add conditional formatting to a Range - AddConditionalFormat().Databar(XLColor.Green); And then SaveAs. In a range there are number values. In Excel I can add conditional format...

Id #9485 | Release: None | Updated: Mar 24 at 4:36 PM by fae1987 | Created: Mar 24 at 4:36 PM by fae1987

cant use closedXML

hi, i cant use ClosedXml. I'm using Visual Studio 2015 4.6 .NET framework i only created a new Windows Forms Application project with visual studio 2015. i added reference ClosedXML.dll. i a...

Id #9484 | Release: None | Updated: Mar 24 at 11:55 AM by Pitterling | Created: Mar 22 at 12:17 PM by GermanRodriguez

Multiple SaveAs calls causes InvalidCastException

Version 0.76.0, Test case: XLWorkbook w = new XLWorkbook(); IXLWorksheet ret = w.Worksheets.Add("test"); w.SaveAs("test.xlsx"); ret.Cell("A1").Value = "test"; ...

Id #9483 | Release: None | Updated: Mar 21 at 2:21 PM by blackzork | Created: Mar 21 at 2:21 PM by blackzork

Datatype "DateTime" not set for emtpy cells

Hello, I am setting the datatype for a range of cells to "DateTime": rangeTable.DataRange.Column(colNumber).SetDataType(XLCellValues.DateTime); where rangeTable is an IXLTable and colNumber an i...

Id #9482 | Release: None | Updated: Mar 19 at 2:17 PM by matthex | Created: Mar 19 at 2:17 PM by matthex