Spire.XLS 支持在Excel中插入文本框,并在文本框中添加文本及图片,对内容进行格式化操作等。同理,对于Excel工作表中已有的文本框内容,也可以通过Spire.XLS读取出来,包括读取文本、读取图片。
测试文档如下:

C#
//创建Workbook类的对象,并加载测试文档
Workbook workbook = new Workbook();
workbook.LoadFromFile("sample.xlsx");
//获取指定工作表
Worksheet sheet = workbook.Worksheets["Sheet1"];
//遍历工作表中文本框
for( int i = sheet.TextBoxes.Count-1; i >= 0; i--)
{
    XlsTextBoxShape shape = sheet.TextBoxes[i] as XlsTextBoxShape;
    //提取文本框中的文本
    string s = shape.Text;
    StringBuilder sb = new StringBuilder();
    sb.AppendLine(s);
    File.WriteAllText("提取文本.txt", sb.ToString());
    
    //提取文本框中的图片
    Image image = shape.Fill.Picture;
    image.Save("提取图片.png", ImageFormat.Png);
}VB.NET
'创建Workbook类的对象,并加载测试文档 Dim workbook As New Workbook() workbook.LoadFromFile("sample.xlsx") '获取指定工作表
Dim sheet As Worksheet = workbook.Worksheets("Sheet1")
'遍历工作表中文本框 For i As Integer = sheet.TextBoxes.Count - 1 To 0 Step -1 Dim shape As XlsTextBoxShape = TryCast(sheet.TextBoxes(i),XlsTextBoxShape) '提取文本框中的文本
	Dim s As String = shape.Text
	Dim sb As New StringBuilder()
	sb.AppendLine(s)
	File.WriteAllText("提取文本.txt", sb.ToString())
	'提取文本框中的图片 Dim image As Image = shape.Fill.Picture image.Save("提取图片.png",ImageFormat.Png) Next读取结果:

 



 
					



