Display Excel Data in HTML using REST API in Node.js

DisplayExcelToHTML_NodeJs.md

Learn how to display Excel data in HTML using a REST API in Node.js: https://blog.groupdocs.cloud/2021/12/03/display-excel-data-in-html-using-rest-api-in-node-js/

The following topics are covered in this article:

1. Excel to HTML Viewer REST API and Node.js SDK
2. Display Excel Data in HTML using REST API in Node.js
3. Display Excel Data in HTML with Watermark in Node.js

DisplayExcelToHTML_NodeJs_Configurations.js

// Please get your Client ID and Secret from the dashboard and add in the code as shown below:
global.clientId = "112f0f38-9dae-42d5-b4fc-cc84ae644972";
global.clientSecret = "16ad3fe0bdc39c910f57d2fd48a5d618";
global.myStorage = "";

const configuration = new groupdocs_viewer_cloud.Configuration(clientId, clientSecret);
configuration.apiBaseUrl = "https://api.groupdocs.cloud";

DisplayExcelToHTML_NodeJs_Download.js

// This code example demonstartes how to download HTML page from the Cloud
// Initialize api
var fileApi = groupdocs_viewer_cloud.FileApi.fromConfig(configuration);

// Create file download request
let request = new groupdocs_viewer_cloud.DownloadFileRequest("/viewer/sample_xlsx/sample_page_1.html", myStorage);

// Download file
let response = await fileApi.downloadFile(request);

// Save image file in working directory
fs.writeFile("C:\\Files\\viewer\\sample_xlsx\\sample_page_1.html", response, "binary", function (err) { });

DisplayExcelToHTML_NodeJs_Upload.js

// This code example demonstartes how to upload XLSX file to the Cloud
// Construct FileApi
let fileApi = groupdocs_viewer_cloud.FileApi.fromConfig(configuration);
let resourcesFolder = 'C:\\Files\\viewer\\sample.xlsx';

// Read files one by one
fs.readFile(resourcesFolder, (err, fileStream) => {
  // Create upload file request
  let request = new groupdocs_viewer_cloud.UploadFileRequest("sample.xlsx", fileStream, myStorage);
  // Upload file
  fileApi.uploadFile(request);
});

DisplayExcelToHTML_NodeJs_XLSXToHTML.js

// This code example demonstartes how to render Excel in HTML page
// Api initialization
let viewApi = groupdocs_viewer_cloud.ViewApi.fromKeys(clientId, clientSecret);

// Input file
let fileInfo = new groupdocs_viewer_cloud.FileInfo();
fileInfo.filePath = "sample.xlsx";

// Define view options
let viewOptions = new groupdocs_viewer_cloud.ViewOptions();
viewOptions.fileInfo = fileInfo;
viewOptions.viewFormat = groupdocs_viewer_cloud.ViewOptions.ViewFormatEnum.HTML;

// Define render options
viewOptions.renderOptions = new groupdocs_viewer_cloud.HtmlOptions();

// Define Spreadsheet rendering options
viewOptions.renderOptions.spreadsheetOptions = new groupdocs_viewer_cloud.SpreadsheetOptions();
viewOptions.renderOptions.spreadsheetOptions.paginateSheets = false;
viewOptions.renderOptions.spreadsheetOptions.textOverflowMode = groupdocs_viewer_cloud.SpreadsheetOptions.TextOverflowModeEnum.HideText;
viewOptions.renderOptions.spreadsheetOptions.renderGridLines = true;
viewOptions.renderOptions.spreadsheetOptions.renderHiddenColumns = true;
viewOptions.renderOptions.spreadsheetOptions.renderHiddenRows = true;

// Create view request
let request = new groupdocs_viewer_cloud.CreateViewRequest(viewOptions);
// Create view
let response = await viewApi.createView(request);

// Display rendered HTML pages path
for (let page = 0; page < response.pages.length; page++) {
  console.log("Document rendered: " + response.pages[page].path);
}

DisplayExcelToHTML_NodeJs_XLSXToHTMLWithWatermark.js

// This code example demonstartes how to render Excel in HTML page with Watermark
// Api initialization
let viewApi = groupdocs_viewer_cloud.ViewApi.fromKeys(clientId, clientSecret);

// Input file
let fileInfo = new groupdocs_viewer_cloud.FileInfo();
fileInfo.filePath = "sample.xlsx";

// Define view options
let viewOptions = new groupdocs_viewer_cloud.ViewOptions();
viewOptions.fileInfo = fileInfo;
viewOptions.viewFormat = groupdocs_viewer_cloud.ViewOptions.ViewFormatEnum.HTML;

// Add Watermark
viewOptions.watermark = new groupdocs_viewer_cloud.Watermark();
viewOptions.watermark.size = 100;
viewOptions.watermark.text = "This is a sample watermark!";

// Create view request
let request = new groupdocs_viewer_cloud.CreateViewRequest(viewOptions);
// Create view
let response = await viewApi.createView(request);

// Display rendered HTML pages path
for (let page = 0; page < response.pages.length; page++) {
  console.log("Document rendered: " + response.pages[page].path);
}