ByteScout Spreadsheet SDK - VB.NET - Read XML Spreadsheet (SpreadsheetML format) - ByteScout

ByteScout Spreadsheet SDK – VB.NET – Read XML Spreadsheet (SpreadsheetML format)

  • Home
  • /
  • Articles
  • /
  • ByteScout Spreadsheet SDK – VB.NET – Read XML Spreadsheet (SpreadsheetML format)

How to read XML spreadsheet (spreadsheetml format) in VB.NET and ByteScout Spreadsheet SDK

How to read XML spreadsheet (spreadsheetml format) in VB.NET

The sample source codes on this page shows how to read XML spreadsheet (spreadsheetml format) in VB.NET. ByteScout Spreadsheet SDK: the SDK to create, read, modify and calculate spreadsheets. Formula calculations are supported, import and export to and from JSON, CSV, XML, databases, arrays. It can read XML spreadsheet (spreadsheetml format) in VB.NET.

Fast application programming interfaces of ByteScout Spreadsheet SDK for VB.NET plus the instruction and the code below will help you quickly learn how to read XML spreadsheet (spreadsheetml format). Just copy and paste the code into your VB.NET application’s code and follow the instruction. Enjoy writing a code with ready-to-use sample codes in VB.NET.

Trial version of ByteScout Spreadsheet SDK can be downloaded for free from our website. It also includes source code samples for VB.NET and other programming languages.

Try ByteScout Spreadsheet SDK today: Get 60 Day Free Trial or sign up for Web API

Program.vb
      
Imports Bytescout.Spreadsheet Module Program Sub Main() Try ' Convert SpreadhseetML (xml spreadsheet) to XLSX format Using spreadsheet As New Spreadsheet spreadsheet.RegistrationName = "demo" spreadsheet.RegistrationKey = "demo" ' Load input file spreadsheet.LoadFromFile("sample.xml") ' Generate XLSX format spreadsheet.SaveAsXLSX("sample.xlsx") End Using ' Read spreadsheet and display data to console Using spreadsheet As New Spreadsheet spreadsheet.RegistrationName = "demo" spreadsheet.RegistrationKey = "demo" ' Load input file spreadsheet.LoadFromFile("sample.xlsx") ' Reference Worksheet Dim Worksheet As Worksheet = spreadsheet.Worksheet(0) Console.WriteLine("=====================================================") Console.WriteLine("================ Spreadsheet data ===================") Console.WriteLine("=====================================================") ' Read And output cells to console. For row = Worksheet.UsedRangeRowMin To Worksheet.UsedRangeRowMax For column = Worksheet.UsedRangeColumnMin To Worksheet.UsedRangeColumnMax Console.Write("{0}" + vbTab, Worksheet.Cell(row, column).ValueAsString) Next Console.WriteLine() Next End Using Catch ex As Exception Console.WriteLine(("ERROR:" + ex.Message)) End Try Console.WriteLine("Press any key to exit...") Console.ReadLine() End Sub End Module

Try ByteScout Spreadsheet SDK today: 60 Day Free Trial (on-premise version) or sign up for Web API (on demand version)

VIDEO

ON-PREMISE VERSION

Get 60 Day Free Trial or Visit ByteScout Spreadsheet SDK page

Explore ByteScout Spreadsheet SDK documentation

WEB API

Sign Up for free Web API key

Explore Web API Documentation

Tutorials:

prev
next