Topic: Excel .Net Options for AutoCAD

[Keith Brown]

Instead of posting in an old thread I thought I would start a new one.


Reading the thread located at http://www.theswamp.org/index.php?topic=39543.msg469273#msg469273 I saw the suggestion to use ClosedXML for integration with AutoCAD instead of com at the very bottom of the post.  One of the advantages to using it is that it does not require that Excel be located on the machine. (not everyone has excel)  Another free alternative that is very similar but works with Excel 2013 (ClosedXML doesnt support 2013 according to the website) is SpreadSheetLite. http://www.spreadsheetlite.com.  I have used this in the past and it works great.


There are alot of paid options out there (SpreadSheetGear comes to mind) but these solutions are free and will probably do 99 percent of what people need coming out of AutoCAD.

[MexicanCustard]

I'm using ClosedXml with Excel 2013 and it seems to be working just fine.  I've been using ClosedXml to create and read excel sheets for a couple of years now and it's never let me down.

[exmachina]

Another library. Supports .xls, .xlsx, .docx :
https://npoi.codeplex.com/

[Andrey Bushman]

I create a Table XML 2003 usualy. If I need to add the OLE objects into the document, I use the late binding: I open my Table XML document as Workbook and add the necessary OLE objects. Then I do "Save as" XLS (because Table XML can't to contain the OLE objects). Thank you for the links, I will read their.

P.S. When I need to create a report, I use Stimulsoft. It can to export result into XLS and XLSX too.

[exmachina]

P.S. When I need to create a report, I use Stimulsoft. It can to export result into XLS and XLSX too.

Unless you need some special function, for win forms, I recommend you this:
http://www.fast-report.com/es/

It is much cheaper, even if you buy the source code.

[Andrey Bushman]

I remember Fast Reports .NET. I used Stimulsoft when .NET version of Fast Reports wasn't born still. Fast Reports .NET was very weak. Stimulsoft is more powerful. I have a license for Stimulsoft.

[CADbloke]

This could be interesting: https://github.com/OfficeDev/Open-XML-SDK