Błąd interopu w programie WPF excel.'Window 'jest niejednoznacznym odniesieniem między' System.Windows.Window 'a' Microsoft.Office.Interop.Excel.Window '
Napisałem mały program do reade danych z pliku Excela w WPF. Ale otrzymuję ten błąd:„Okno” to niejednoznaczne odniesienie między „System.Windows.Window” i Microsoft.Office.Interop.Excel.Window ”.
Dlaczego tak się dzieje? Mój kod jest podany poniżej:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using Microsoft.Office.Interop.Excel;
namespace FileReader
{
/// <summary>
/// Interaction logic for MainWindow.xaml
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
}
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook xlWb;
Microsoft.Office.Interop.Excel.Worksheet xlWsheet;
private void excel_Click(object sender, RoutedEventArgs e)
{
try
{
xlWb = xlApp.Workbooks.Open("C:\\Config.xlsm", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
xlWsheet = (Worksheet)xlWb.Sheets["Startup"];
Range xlRange = xlWsheet.UsedRange;
for (int rownum = 0; rownum <= 31; rownum++)
{
xlRange = xlWsheet.Cells[rownum + 2, 24];
d32[rownum] = xlRange.Value.ToString().Substring(2);
}
}
catch (Exception e)
{
MessageBox.Show("File not found: C:\\Config.xlsm","File not found",MessageBoxButton.OK,MessageBoxImage.Warning);
}
}
}