Export to Excel using SpreadsheetML v2

Administrator
Administrator Member, Moderator, Administrator Posts: 2,506
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

  • Administrator
    Administrator Member, Moderator, Administrator Posts: 2,506
    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.
  • SteveO
    SteveO 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
  • spycraft
    spycraft Member Posts: 66
    Great tool!! It will be even more useful if it can create pivot table.

Categories