The sample source code below will teach you how to read document properties in VB.NET. ByteScout Spreadsheet SDK is the library (SDK) that is capable of writing, reading, modifying and calculating Excel and CSV spreadsheets. Most popular formulas can be calculated and reculculated with Excel installed. You may import or export data to and from CSV, XML, JSON as well as to and from databases, arrays. It can read document properties in VB.NET.
You will save a lot of time on writing and testing code as you may just take the VB.NET code from ByteScout Spreadsheet SDK for read document properties below and use it in your application. In your VB.NET project or application you may simply copy & paste the code and then run your app! Enjoy writing a code with ready-to-use sample VB.NET codes.
Our website provides trial version of ByteScout Spreadsheet SDK for free. It also includes documentation and source code samples.
Imports System Imports System.Collections.Generic Imports System.Text Imports Bytescout.Spreadsheet Module Module1 Sub Main() ' read spreadsheet Dim document As Spreadsheet = New Spreadsheet() document.LoadFromFile("Input.xls") Console.WriteLine("Reading XLS properties") ' Get some properties Console.WriteLine("Author: " + document.Workbook.Properties.Author) Console.WriteLine("Comments: " + document.Workbook.Properties.Comments) Console.WriteLine("Subject: " + document.Workbook.Properties.Subject) Console.ReadKey() document.Close() End Sub End Module