C# 读取一个word或者execl文件并将内容展示在richtext中
使用C#可以使用Microsoft.Office.Interop.Word和Microsoft.Office.Interop.Excel库来读取Word和Excel文件,并将文件内容展示在RichTextBox控件中。以下是一个示例代码:
using System;
using System.Windows.Forms;
using Microsoft.Office.Interop.Word;
using Microsoft.Office.Interop.Excel;
namespace FileViewer
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void btnOpen_Click(object sender, EventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Word文件 (*.docx)|*.docx|Excel文件 (*.xlsx)|*.xlsx";
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
string filePath = openFileDialog.FileName;
string extension = System.IO.Path.GetExtension(filePath);
if (extension == ".docx")
{
// 读取Word文件
Microsoft.Office.Interop.Word.Application wordApp = new Microsoft.Office.Interop.Word.Application();
Document doc = wordApp.Documents.Open(filePath);
string content = doc.Content.Text;
doc.Close();
wordApp.Quit();
richTextBox1.Text = content;
}
else if (extension == ".xlsx")
{
// 读取Excel文件
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
Workbook workbook = excelApp.Workbooks.Open(filePath);
Worksheet worksheet = workbook.ActiveSheet;
Range range = worksheet.UsedRange;
string content = "";
for (int row = 1; row <= range.Rows.Count; row++)
{
for (int col = 1; col <= range.Columns.Count; col++)
{
content += range.Cells[row, col].Value.ToString() + "\t";
}
content += Environment.NewLine;
}
workbook.Close();
excelApp.Quit();
richTextBox1.Text = content;
}
}
}
}
}
在上述代码中,我们使用了OpenFileDialog来选择要读取的文件,并根据文件的扩展名来判断是Word文件还是Excel文件。然后,使用相应的库来打开和读取文件内容。将读取到的文件内容赋值给RichTextBox控件的Text属性,即可展示在界面上。
请注意,运行此代码需要在项目中添加对Microsoft.Office.Interop.Word和Microsoft.Office.Interop.Excel库的引用。可以通过NuGet包管理器来安装这两个库
原文地址: https://www.cveoy.top/t/topic/inBa 著作权归作者所有。请勿转载和采集!