Export to Excel using SpreadsheetML v2

AdministratorAdministrator Member, Moderator, Administrator Posts: 2,500
edited 2006-10-19 in Download section
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

  • AdministratorAdministrator Member, Moderator, Administrator Posts: 2,500
    Export to Excel using SpreadsheetML v2
    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.
  • SteveOSteveO Member Posts: 164
    The new functions are:
      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
    This isn't a signature, I type this at the bottom of every message
  • spycraftspycraft Member Posts: 66
    Great tool!! It will be even more useful if it can create pivot table.
Sign In or Register to comment.