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.

On-demand (REST Web API) version:
 Web API (on-demand version)

On-premise offline SDK for Windows:
 60 Day Free Trial (on-premise)

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

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Spreadsheet SDK Home Page

Explore ByteScout Spreadsheet SDK Documentation

Explore Samples

Sign Up for ByteScout Spreadsheet SDK Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

VIDEO

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Spreadsheet SDK Home Page

Explore ByteScout Spreadsheet SDK Documentation

Explore Samples

Sign Up for ByteScout Spreadsheet SDK Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

Tutorials:

prev
next