Module1.vb
Imports System.IO Imports System.Net Imports Newtonsoft.Json.Linq Module Module1 ' (!) If you are getting '(403) Forbidden' error please ensure you have set the correct API_KEY ' The authentication key (API Key). ' Get your own by registering at https://secure.bytescout.com/users/sign_up Const API_KEY As String = "***********************************" ' Source PDF file const SourceFile as String = ".\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" Sub Main() ' Create standard .NET web client instance Dim webClient As WebClient = New WebClient() ' Set API Key webClient.Headers.Add("x-api-key", API_KEY) ' 1. RETRIEVE THE PRESIGNED URL TO UPLOAD THE FILE. ' * If you already have a direct file URL, skip to the step 3. ' Prepare URL for `Get Presigned URL` API call Dim query As string = Uri.EscapeUriString(string.Format( "https://bytescout.io/v1/file/upload/get-presigned-url?contenttype=application/octet-stream&name={0}", Path.GetFileName(SourceFile))) 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 ' Get URL to use for the file upload Dim uploadUrl As string = json("presignedUrl").ToString() ' Get URL of uploaded file to use with later API calls Dim uploadedFileUrl As string = json("url").ToString() ' 2. UPLOAD THE FILE TO CLOUD. webClient.Headers.Add("content-type", "application/octet-stream") webClient.UploadFile(uploadUrl, "PUT", SourceFile) ' You can use UploadData() instead if your file is byte array or Stream ' 3. CONVERT UPLOADED PDF FILE TO XLS ' Prepare URL for `PDF To XLS` API call query = Uri.EscapeUriString(String.Format( "https://bytescout.io/v1/pdf/convert/to/xls?name={0}&password={1}&pages={2}&url={3}", Path.GetFileName(DestinationFile), Password, Pages, uploadedFileUrl)) ' Execute request response = webClient.DownloadString(query) ' Parse JSON response json = JObject.Parse(response) If json("error").ToObject(Of Boolean) = False Then ' Get URL of generated XLS file Dim resultFileUrl As string = json("url").ToString() ' Download XLS file webClient.DownloadFile(resultFileUrl, DestinationFile) Console.WriteLine("Generated XLS file saved as ""{0}"" file.", DestinationFile) Else Console.WriteLine(json("message").ToString()) End If 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 End Module