Convert to VSTO - (EXCEL)

Hot Topic

TextBlock Height exception
SourceSafe setup fails, exits in an unusual way
ArgumentNullException Value cannot be null...
Binding hierarchical data to TreeView with two ItemSources
Ruby Plug-In ?
Unable to create Word template project
CR XI vs CR for VS.Net
How can I bind a single ListBox to multiple Lists?
Managing deletion of bookmark controls
Vertical Titles on Pie Charts

Visual Studio

Anybody managed to find a workaround for the "Black Window" bug in the Nov CTP?
report rdl file portability
foreach or yield on a 'stream' instead of an IList?
Bitmap<->BitmapImage conversion
Want to access "New Mail" editor fields of outlook in vb.net
Custom help filters
strange error using serverdocument
runtime field position
how to group shapes
Silly answer [:D]

Convert to VSTO - (EXCEL)

Hi all,

Can I create a new workbook/worksheet at run time just like the code below using VSTO components.

Thanks.

sample code:

________________________________________

Imports Microsoft.Office

Imports Microsoft.Office.Core

Sub()

Dim xlApp As New Excel.Application

Dim excelBook As Excel.Workbook = xlApp.Workbooks.Add

Dim xlSheet As Excel.Worksheet = CType(excelBook.Worksheets(1), Excel.Worksheet)

......

......

......

xlApp .visible=true

end sub

Answer this question

Convert to VSTO - (EXCEL)

  • DoRsal

    You need to import

    Imports Microsoft.Office.Tools.Excel

    Imports Microsoft.Office.Interop.Excel



  • amm.firas

    do u have a sample code

    to instantiate the classes of a workbook/worksheet like the code above.

    Thanks

  • Stein

    Hi,

    I'm sorry to say that this scenario currently is not supported. Microsoft.Office.Tools.Excel.Worksheet is a wrapper class that VSTO creates to support coding behind the document. Excel knows nothing about it, so adding a new worksheet at runtime would not result in a new wrapper class instance being created. Also, even if Excel did create a new wrapper instance, it is a completely different object so that cast would not work.

    It would be technically possible for you to do this work yourself and enable the scenario, but I would discourage you from doing it because you would be relying on undocumented methods which are likely to change in the future (and would therefore break your solution going forward).

    Sincerely,

    Geoff Darst

    Microsoft VSTO Team
  • Convert to VSTO - (EXCEL)
Answer this question