Please help me with this task. There is an MS SQl database, you need to create reconciliation acts for certain contracts so that they are uploaded to an Excel workbook on different sheets, I used the CarlosAg.ExcelXmlWriter.dll library, but I can’t upload several contracts for different sheets at once, tell me an alternative or what any method.

  • Thank you, figured out using npoi - Gena_2007

4 answers 4

Tools for generating documents:

  1. Open XML SDK 2.0 for Microsoft Office .
  2. Aspose.Cells for .NET .
  3. excellibrary

I do not advise to generate automation of the Office package preinstalled in the ОС via Office.Interop ( example ), if only because hosting will not allow it. First of all, due to security and stability concerns. On the client machine, the use of this method also entails a number of complications. It is possible only for non-serious or temporary tasks. You can familiarize yourself with серверной автоматизацией Office here: Consideration for server-side Automation of Office .

It is necessary to use autonomous, independent of the pre-installed Office tools, the examples described above.

    Hello!

    Great project npoi . In the project a large number of examples for every taste. Different sheets can create accurately.

      Work with Com Excel Server

      The chapter presents the author's own practical work on the output of information from applications written in Visual Studio 2003/2005/2008 in C # in Excel. All codes are debugged and repeatedly used.

        Still look towards ClosedXML - this is a convenient wrapper over the OpenXML format (only for * .xlsx files).