Convert PDF to Excel using REST API in Node.js

Convert_PDF_file_to_Excel_format_in_NodeJs_Download.js

// construct FileApi to download converted file
var fileApi = groupdocs_conversion_cloud.FileApi.fromConfig(config);
// create donwload file request
let request = new groupdocs_conversion_cloud.DownloadFileRequest("nodejs-testing/sample-file.xlsx", myStorage);
// download file and response type Stream
fileApi.downloadFile(request)
    .then(function (response) {
        // save file in your system directory
        fs.writeFile("H:\\groupdocs-cloud-data\\sample-file.xlsx", response, "binary", function (err) { });
        console.log("Expected response type is Stream: " + response.length);
    })
    .catch(function (error) {
        console.log("Error: " + error.message);
    });

Convert_PDF_to_Excel_in_NodeJs.js

// How to convert PDF file to Excel format using Node.js

const convert = async () => {
  const convertApi = groupdocs_conversion_cloud.ConvertApi.fromKeys(clientId, clientSecret);

  const settings = new groupdocs_conversion_cloud.ConvertSettings();
  settings.storageName = myStorage;
  settings.filePath = "nodejs-testing/sample-file.pdf";
  settings.format = "xlsx";
  settings.outputPath = "nodejs-testing/sample-file.xlsx";

  try {
    // Create convert document request
    const request = new groupdocs_conversion_cloud.ConvertDocumentRequest(settings);
    await convertApi.convertDocument(request);
  }
  catch (err) {
    throw err;
  }
}

convert()
.then(() => {
  console.log("Successfully converted PDF to XLSX file format.");
})
.catch((err) => {
  console.log("Error occurred while converting the PDF file:", err);
})

Convert_PDF_to_Excel_in_NodeJs.md

You can convert PDF to Excel file programmatically on the cloud. In this article, you will learn how to convert PDF to Excel format in Node.js using REST API.

The following topics are covered in this article:

1. PDF to Excel Conversion REST API and Node.js SDK
2. Convert PDF to XLSX format using REST API in Node.js
3. Convert PDF to Excel Sheet Online using Advanced Options in Node.js

Read the complete article on how to convert PDF to Excel using REST API in Node.js: https://blog.groupdocs.cloud/2022/09/03/convert-pdf-to-excel-using-rest-api-in-node.js/

Convert_PDF_to_Excel_using_Advanced_Options_in_NodeJs.js

// How to convert PDF file to Excel file using Advanced Options in Node.js

const convert = async () => {
  const convertApi = groupdocs_conversion_cloud.ConvertApi.fromKeys(clientId, clientSecret);

  const settings = new groupdocs_conversion_cloud.ConvertSettings();
  settings.storageName = myStorage;
  settings.filePath = "nodejs-testing/sample-file.pdf";
  settings.format = "xlsx";

  var convertOptions = new groupdocs_conversion_cloud.XlsxConvertOptions();
  convertOptions.fromPage = 1;
  convertOptions.pagesCount = 2;
  convertOptions.password = "password";
  convertOptions.usePdf = false;

  settings.convertOptions = convertOptions;
  settings.outputPath = "nodejs-testing/sample-file.xlsx";

  try {
    // Create convert document request
    const request = new groupdocs_conversion_cloud.ConvertDocumentRequest(settings);
    await convertApi.convertDocument(request);
  }
  catch (err) {
    throw err;
  }
}

convert()
.then(() => {
  console.log("Successfully converted PDF File to XLSX file using advanced options.");
})
.catch((err) => {
  console.log("Error occurred while converting the PDF file:", err);
})

Convert_PDF_to_XLSX_file_NodeJs_Upload.js

// open file in IOStream from your system drive.
var resourcesFolder = 'H:\\groupdocs-cloud-data\\sample-file.pdf';
// read file
fs.readFile(resourcesFolder, (err, fileStream) => {
  // construct FileApi
  var fileApi = groupdocs_conversion_cloud.FileApi.fromConfig(config);
  // create upload file request
  var request = new groupdocs_conversion_cloud.UploadFileRequest("sample-file.pdf", fileStream, myStorage);
  // upload file
  fileApi.uploadFile(request)
    .then(function (response) {
      console.log("Expected response type is FilesUploadResult: " + response.uploaded.length);
    })
    .catch(function (error) {
      console.log("Error: " + error.message);
    });
});

Utils_to_Convert_PDF_to_Excel_in_NodeJs.js

# Import Node.js SDK in your node application from http://api.groupdocs.cloud
global.groupdocs_conversion_cloud = require("groupdocs-conversion-cloud");
global.fs = require("fs");

// get clientId and clientSecret from https://dashboard.groupdocs.cloud (free registration is required).
global.clientId = "xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx";
global.clientSecret = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx";
global.myStorage = "test-internal-storage";
const config = new groupdocs_conversion_cloud.Configuration(clientId, clientSecret);
config.apiBaseUrl = "https://api.groupdocs.cloud";