SaveAs() is saving my file in IIS Express by default, i would like to save using open dialog box.. how can i do this??

using (XLWorkbook wb = new XLWorkbook()) { wb.Worksheets.Add(dt, "BPA Supplier Report"); wb.SaveAs(@"C:\ME\Projects\Planogram"); }

Id #9477 | Release: None | Updated: Tue at 1:39 PM by Abilash | Created: Tue at 1:39 PM by Abilash

ClosedXML does not support Excel 2013

Hi All, We have created a service using ClosedXML version 0.76. The feature it includes is to upload and download data in excel. The user is allowed to update minimum data, therefore the sheet is...

Id #9476 | Release: None | Updated: Mon at 12:41 PM by geeta_chugh | Created: Mon at 12:34 PM by geeta_chugh

Incorrect formatting of many cells using Worksheet.CopyTo for first worksheet in new workbook

Hello, I ran across an issue that took me several hours to narrow down what was actually happening, since it seemed very random. However, once I simplified my code, I finally found how to re-pro...

Id #9475 | Release: None | Updated: Jan 31 at 7:47 PM by zpert | Created: Jan 31 at 7:47 PM by zpert

Read Excel

I am trying to read excel and convert it to DataTable but getting error in first statement itself var workbook = new XLWorkbook(filePath); or var stream = File.Open(filePath, FileMode.Open,...

Id #9474 | Release: None | Updated: Jan 13 at 6:36 PM by mishraom | Created: Jan 13 at 6:36 PM by mishraom

ASPNETCOMPILER

TFS deployment run to error: ASPNETCOMPILER: Type 'DocumentFormat.OpenXml.OpenXmlElement' is a recursive collection data contract which is not supported. Consider modifying the definition of coll...

Id #9473 | Release: None | Updated: Jan 6 at 6:34 PM by hansdu | Created: Jan 6 at 6:33 PM by hansdu

IXLWorksheet.CopyTo doesn't copy DrawingsPart

I understand that working with DrawingsPart isn't supported, but it would be very useful in my situation to have that part copied when I use CopyTo to duplicate a worksheet. As it stands now, the n...

Id #9472 | Release: None | Updated: Dec 18, 2015 at 6:17 PM by jhood | Created: Dec 18, 2015 at 6:15 PM by jhood

Error when i try release my project using CodeXML

When i try release my project, the error is in spanish and say __Advertencia 1 La referencia principal "ClosedXML" no se pudo resolver porque se generó con la versión de .NET Framework ".NETFr...

Id #9471 | Release: None | Updated: Jan 8 at 10:31 AM by vittoso | Created: Dec 18, 2015 at 4:26 PM by gogomix

Out Of Memory Creating file

I am creating an excel file. I cannot seem to get more than 100,000 rows total per workbook before getting an out memory exception. I have turned tracking off. What do I need to supply to help yo...

Id #9470 | Release: None | Updated: Dec 22, 2015 at 5:08 PM by aknittel | Created: Dec 17, 2015 at 6:15 PM by aknittel

Cell ranges are not supported in the PRODUCT function

Hi. If you run this code, everything will be OK. var book = new XLWorkbook(); var ws = book.AddWorksheet("ws"); ws.Cell("A1").Value = 2; ws.Cell("B1").Value = 3; ws.Cell("C1").FormulaA1 = "PROD...

Id #9469 | Release: None | Updated: Dec 17, 2015 at 1:26 AM by p_s_malkov | Created: Dec 17, 2015 at 1:21 AM by p_s_malkov

ClosedXML open .xlms

Hi, I'm trying to read a .xlsm file and its not opening. I have search a bit and found that probably ClosedXML doesn't read .xlsm files, and this is available here on codeplex ( https://closedxml....

Id #9468 | Release: None | Updated: Dec 14, 2015 at 5:24 PM by pfmartins | Created: Dec 14, 2015 at 5:13 PM by pfmartins