Export to Excel using SpreadsheetML
Demonstrates how to create Excel Spreadsheets without the need for automation.
Instead you create an XML file using Spreadsheet ML, this means that you do not need Excel installed on the PC that creates the file.
http://www.mibuso.com/dlinfo.asp?FileID=762
Discuss this download here.
Comments
Demonstrates how to create Excel Spreadsheets without the need for automation.
Instead you create an XML file using Spreadsheet ML, this means that you do not need Excel installed on the PC that creates the file.
Version 2:
I have added a few new functions, and updated the demo code to show the use of the new functions.
http://www.mibuso.com/dlinfo.asp?FileID=762
Discuss this download here.
AddFillStyle - Allows to specify a style that will fill the background of a cell, you can choose the colour and pattern MergeStyles - Allows you to merge 2 previously created Styles together to create a new combined style. Eg. You can combine BoldStyle and FillStyle to create a new style that has both Bold and Fill