ByteScout Cloud API Server - PDF To Excel API - VB.NET - Convert PDF To XLS From URL Asynchronously - ByteScout

ByteScout Cloud API Server – PDF To Excel API – VB.NET – Convert PDF To XLS From URL Asynchronously

  • Home
  • /
  • Articles
  • /
  • ByteScout Cloud API Server – PDF To Excel API – VB.NET – Convert PDF To XLS From URL Asynchronously

How to convert PDF to XLS from URL asynchronously for PDF to excel API in VB.NET with ByteScout Cloud API Server

How to convert PDF to XLS from URL asynchronously in VB.NET with easy ByteScout code samples to make PDF to excel API. Step-by-step tutorial

The sample source codes on this page will show you how to create PDF to excel API in VB.NET. ByteScout Cloud API Server helps with PDF to excel API in VB.NET. ByteScout Cloud API Server is the ready to use Web API Server that can be deployed in less than 30 minutes into your own in-house server or into private cloud server. Can store data on in-house local server based storage or in Amazon AWS S3 bucket. Processing data solely on the server using buil-in ByteScout powered engine, no cloud services are used to process your data!.

VB.NET code snippet like this for ByteScout Cloud API Server works best when you need to quickly implement PDF to excel API in your VB.NET application. Open your VB.NET project and simply copy & paste the code and then run your app! This basic programming language sample code for VB.NET will do the whole work for you in implementing PDF to excel API in your app.

ByteScout Cloud API Server – free trial version is available on our website. Also, there are other code samples to help you with your VB.NET application included into trial version.

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

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

Module1.vb
      
Imports System.IO Imports System.Net Imports System.Threading Imports Newtonsoft.Json.Linq ' Please NOTE: In this sample we're assuming Cloud Api Server is hosted at "https://localhost". ' If it's not then please replace this with with your hosting url. ' Cloud API asynchronous "PDF To XLS" job example. ' Allows to avoid timeout errors when processing huge or scanned PDF documents. Module Module1 ' Direct URL of source PDF file. Const SourceFileUrl As String = "https://bytescout-com.s3.amazonaws.com/files/demo-files/cloud-api/pdf-to-excel/sample.pdf" ' Comma-separated list of page indices (or ranges) to process. Leave empty for all pages. Example: '0,2-5,7-'. Const Pages As String = "" ' PDF document password. Leave empty for unprotected documents. Const Password As String = "" ' Destination XLS file name Const DestinationFile As String = ".\result.xls" ' (!) Make asynchronous job Const Async As Boolean = True Sub Main() ' Create standard .NET web client instance Dim webClient As WebClient = New WebClient() ' Prepare URL for `PDF To XLS` API call Dim query As String = Uri.EscapeUriString(String.Format( "https://localhost/pdf/convert/to/xls?name={0}&password={1}&pages={2}&url={3}&async={4}", Path.GetFileName(DestinationFile), Password, Pages, SourceFileUrl, Async)) Try ' Execute request Dim response As String = webClient.DownloadString(query) ' Parse JSON response Dim json As JObject = JObject.Parse(response) If json("error").ToObject(Of Boolean) = False Then ' Asynchronous job ID Dim jobId As String = json("jobId").ToString() ' URL of generated XLS file that will available after the job completion Dim resultFileUrl As String = json("url").ToString() ' Check the job status in a loop. ' If you don't want to pause the main thread you can rework the code ' to use a separate thread for the status checking and completion. Do Dim status As String = CheckJobStatus(jobId) ' Possible statuses: "working", "failed", "aborted", "success". ' Display timestamp and status (for demo purposes) Console.WriteLine(DateTime.Now.ToLongTimeString() + ": " + status) If status = "success" Then ' Download XLS file webClient.DownloadFile(resultFileUrl, DestinationFile) Console.WriteLine("Generated XLS file saved as ""{0}"" file.", DestinationFile) Exit Do ElseIf status = "working" Then ' Pause for a few seconds Thread.Sleep(3000) Else Console.WriteLine(status) Exit Do End If Loop Else Console.WriteLine(json("message").ToString()) End If Catch ex As WebException Console.WriteLine(ex.ToString()) End Try webClient.Dispose() Console.WriteLine() Console.WriteLine("Press any key...") Console.ReadKey() End Sub Function CheckJobStatus(jobId As String) As String Using webClient As WebClient = New WebClient() Dim url As String = "https://localhost/job/check?jobid=" + jobId Dim response As String = webClient.DownloadString(url) Dim json As JObject = JObject.Parse(response) return Convert.ToString(json("status")) End Using End Function End Module

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Cloud API Server Home Page

Explore ByteScout Cloud API Server Documentation

Explore Samples

Sign Up for ByteScout Cloud API Server Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

packages.config
      
<?xml version="1.0" encoding="utf-8"?> <packages> <package id="Newtonsoft.Json" version="10.0.3" targetFramework="net40" /> </packages>

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Cloud API Server Home Page

Explore ByteScout Cloud API Server Documentation

Explore Samples

Sign Up for ByteScout Cloud API Server 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 Cloud API Server Home Page

Explore ByteScout Cloud API Server Documentation

Explore Samples

Sign Up for ByteScout Cloud API Server Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

Tutorials:

prev
next