如何使用框架4.5在VB.NET中使用EXCEL [英] How to use EXCEL in VB.NET using framework 4.5

问题描述

我在工作室2015中使用VB.net和框架4.5，但我无法选择工作表，请任何人帮忙。



Sofare我的代码看起来像这样，但是选择的woorksheet不起作用？



进口Microsoft.Office.Interop.Excel



昏暗excelApp As _Application = New Application

Dim wb As _Workbook = excelApp.Workbooks.Open（C：\ Client.xlsm;）



Dim ws As Worksheet = wb.Sheets（Log - Jysk Vagt）





excelApp.Visible = True

excelApp.ScreenUpdating = True



我尝试过：



Imports Microsoft.Office.Interop.Excel



Dim excelApp As _Application = New Application

Dim wb As _Workbook = excelApp。 Workbooks.Open（C：\ Client.xlsm;;）



Dim ws As Worksheet = wb.Sheets（Log - Jysk Vagt）





excelApp.Visible = True

excelApp.ScreenUpdating = True

I using VB.net in studio 2015 with framework 4.5 but I cant select a worksheet, please anyone help.

Sofare my code look like this, but the selection of the woorksheet don't work?

Imports Microsoft.Office.Interop.Excel

Dim excelApp As _Application = New Application
Dim wb As _Workbook = excelApp.Workbooks.Open("C:\Client.xlsm";)

Dim ws As Worksheet = wb.Sheets("Log - Jysk Vagt")


excelApp.Visible = True
excelApp.ScreenUpdating = True

What I have tried:

Imports Microsoft.Office.Interop.Excel

Dim excelApp As _Application = New Application
Dim wb As _Workbook = excelApp.Workbooks.Open("C:\Client.xlsm";)

Dim ws As Worksheet = wb.Sheets("Log - Jysk Vagt")


excelApp.Visible = True
excelApp.ScreenUpdating = True

推荐答案

如果我将该行更改为

Dim ws As Worksheet = CType(wb.Sheets("Log - Jysk Vagt"), Worksheet)

它适用于我

这篇关于如何使用框架4.5在VB.NET中使用EXCEL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！