It does so much more than that! Without exaggeration, I can say that I will remember the day I discovered this fantastic tool as one of the highlights of my thirty-five year career in IT. If this library did nothing more than relieve me of the complexity of working with Style Sheets, it would be a tremendous help. There are differences, of course, but they quickly become habit. The learning curve was light the SpreadsheetLight library closely mimics the Excel interface. Three days later, the 1,600+ batch of reports generates in less than an hour. In search of a better way, I happened upon SpreadsheetLight. The reports are fairly complicated, what with being heavy on charts and formatting, so it was no surprise that when the draft report was complete, we were looking at a 100+ hour run time, which was far outside acceptable boundaries.

Running unattended as an overnight scheduled job, this is obviously not a useful or acceptable behavior. This process is fraught with danger: any user-facing pop-up dialog from Excel will stall the process, and they tend to happen randomly during lengthy runs. We typically do this by automating Excel via a c# console app. I had a development requirement to generate 1,600+ Excel reports within a one day period. Or see if anything in the shop catches your fancy. Or donate a small token of your appreciation. The spreadsheet software library is free, but I charge for support. Basically it means you’re allowed to use the source code in commercial projects. The C# source code is provided under the MIT License (see within downloadable zip file). With the documentation (in the XML file), you can also generate MSDN-like documentation for your own use. Source code (in C#) of the SpreadsheetLight library (complete with relevant comments for nasty code sections).

Class, function and property documentation (in an XML file).

The pre-compiled SpreadsheetLight class library DLL.

You might also want to check the release notes. Bug fixed versions will be released promptly via NuGet, but stable releases with source code will still only be available here. This is possibly the most developer-friendly spreadsheet library ever.

Create chm file in visual studio 2019