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:  60 Day Free Trial (on-premise) or  Web API (on-demand version)

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) or  Web API (on-demand version)

VIDEO

ON-PREMISE VERSION INFORMATION

Get 60 Day Free Trial or Visit ByteScout Spreadsheet SDK Home Page

Explore ByteScout Spreadsheet SDK Documentation

Get ByteScout Spreadsheet SDK Free Training

WEB API

Get Your Free API Key

Explore Web API Documentation

Tutorials:

prev
next