ByteScout Spreadsheet SDK – JavaScript – Create Spreadsheet

Home
/
Articles
/
ByteScout Spreadsheet SDK – JavaScript – Create Spreadsheet

printable version:
ByteScout-Spreadsheet-SDK-JavaScript-Create-Spreadsheet.pdf

How to create spreadsheet in JavaScript and ByteScout Spreadsheet SDK

How to create spreadsheet in JavaScript

We made thousands of pre-made source code pieces for easy implementation in your own programming projects. What is ByteScout Spreadsheet SDK? It is 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 help you to create spreadsheet in your JavaScript application.

Fast application programming interfaces of ByteScout Spreadsheet SDK for JavaScript plus the instruction and the code below will help you quickly learn how to create spreadsheet. In order to implement the functionality, you should copy and paste this code for JavaScript below into your code editor with your app, compile and run your application. Enjoy writing a code with ready-to-use sample JavaScript codes.

ByteScout free trial version is available for download from our website. It includes all these programming tutorials along with source code samples.

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

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

HelloWorld.js

      var document = WScript.CreateObject('Bytescout.Spreadsheet.Spreadsheet');

// Add new worksheet
var worksheet = document.Workbook.Worksheets.Add("HelloWorld");

// get cell value
var cell = worksheet.Item(0,0); // you can also use worksheet.Cell("A1") as well

// set cell value
cell.Value = "Hello, World!";

// delete output file if exists already
var fso = WScript.CreateObject('Scripting.FileSystemObject');
if (fso.FileExists('Output.xls')) { fso.DeleteFile('Output.xls'); }
fso = null;

// save document
document.SaveAs ('Output.xls');

// close Spreadsheet
document = null