Excel, add sheets to a Workbook using .net

[DM83]

The “add” “sheets” method is generating error 1172 on Excel 2010.

Is there a way to resolve this?

[Bob_Schor]

If you have the Report Generation Toolkit (included with Base LabVIEW starting with LabVIEW 2014), the Excel Add Worksheet function just works.  Here's an example and the WorkBook it produces:

Bob Schor

[DM83]

Thanks for looking at my issue,

I already have working programs using ActiveX and I agree that I could also use the report Generation Toolkit.

However, I want to see what a .net version of the code would look like for comparison.

So what I am really looking for is a way to make the .net method work.

[Alexander_Sobolev]

Can you save vi for lv2011?

[Intens]

---

@DM83 wrote:

The “add” “sheets” method is generating error 1172 on Excel 2010.

Is there a way to resolve this?

---

What does using .NET mean?

Where is the .NET code that you are referring?

[DM83]

Here is LabVIEW 2011 version and code snippet.

[DM83]

I am not writing .net code, I understood ActiveX or .net to be frameworks and in this context an interface between LabVIEW and Excel.

I am currently using ActiveX to programmatically open excel and write data directly into the spreadsheet.

Here is a working ActiveX version for comparison.

[Intens]

---

@DM83 wrote:

I am not writing .net code, I understood ActiveX or .net to be frameworks and in this context an interface between LabVIEW and Excel.

---

Again, where is your "understanding" coming from???  From what source are you getting your information?

[Bob_Schor]

From Wikipedia (regarding ActiveX):

Despite Microsoft's previous efforts to make ActiveX cross-platform, most ActiveX controls will not work on all platforms, so using ActiveX controls to implement essential functionality of a web page restricts its usefulness. Countries like South Korea have started to remove this technology from their public websites in order to make their web site accessible to more platforms.[12]

Microsoft dropped ActiveX support from the Windows Store edition of Internet Explorer 10 in Windows 8. In 2015, Microsoft Edge, the replacement for Internet Explorer, dropped ActiveX support, marking the end of the technology in Microsoft's web browser development.[13]

Bob Schor

[Darin.K · Accepted solution]

You need to supply Type.Missing to the optional parameters in the Add Sheets method.  Drop a Property Node and browse to select class Type in mscorlib, then choose the Missing property (static).  Wire this property to the unwired optional inputs.