Sample code

Find out how to make your life easier with SpreadsheetLight (often with a handful of lines of code). Obviously I can’t show you everything that SpreadsheetLight is capable of. If you can’t find any sample code here to do what you want, and you’re on a tight schedule, just contact me and I’ll show you how to accomplish your specific requirement.

You can read and modify existing Excel spreadsheets, even though SpreadsheetLight is optimised for creating brand new spreadsheets. In any case, your server will probably register nary a blip in performance and memory use. Micro-optimisation, down that path thou shalt not go.

Download it now, or check out the speed/memory benchmark code if you’re not ready yet.

Possibly the shallowest learning curve ever. Because you’re worth it.

Tip: You might find the SLConvert class to be helpful in doing miscellaneous conversions, such as getting cell references from a row/column index, as well as converting centimetres to inches (Excel by default follows the imperial system instead of using the metric system. Unlike most civilised countries *cough* :)

Tip: You can find out basic worksheet statistics with SLWorksheetStatistics. For example, the number of rows/columns/cells used. Use the GetWorksheetStatistics() of the SLDocument class.

You’ve got style