Read and write operation in Excel using javascript in ShareP

Question

How to do read and write operation in Excel using javascript in SharePoint . I just want to read data from Excel sheet and that sheet located inside a library in SharePoint . I jsut wanted to read and write operation without opening a excel sheet . Any idea please suggest . Note : I am using SharePoint online .

Rajkiran Swain · Answer

var ForReading = 1  ForWriting = 2  ForAppending = 8 ; var TristateUseDefault = -2  TristateTrue = -1  TristateFalse = 0 ; var fso = new ActiveXObject(“Scripting.FileSystemObject”); // Open the files for input and output //CHANGE THESE LOCATIONS TO ENSURE THAT : // a) testfile 1 .txt exists and // b) testfile 2 .txt can be created and is writable var filename 1 = “D:\database\mytest\testfile 1 .txt”; var filename 2 = “D:\database\mytest\testfile 2 .txt”; var f 1 = fso.OpenTextFile(filename 1  ForReading true); // Open the file for input. f 2 = fso.OpenTextFile(filename 2  ForWriting); f 2 .WriteLine(“The following have been copied from input file :-“); // Read from the file and display the results. while (!f 1 .AtEndOfStream) { var r = f 1 .ReadLine(); //This line will read the data to the input file document.write (r + “ ”); //This line will display the data on the screen f 2 .WriteLine(r); //This line will write the data to the output file } f 1 .Close(); f 2 .Close();