Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Read and write operation in Excel using javascript in ShareP

Home
Forums

Read and write operation in Excel using javascript in ShareP

Tapan Mallick

Tapan Mallick

8yAsked Nov 28, 2017, 6:37 AM2.2k

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 .

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Rajkiran Swain8y ago
Accepted answer
5. var ForReading = 1, ForWriting = 2, ForAppending = 8;
6. var TristateUseDefault = -2, TristateTrue = -1, TristateFalse = 0;
7. var fso = new ActiveXObject(“Scripting.FileSystemObject”);
8. // Open the files for input and output
9. //CHANGE THESE LOCATIONS TO ENSURE THAT :
10. // a) testfile1.txt exists and
11. // b) testfile2.txt can be created and is writable
12. var filename1 = “D:\\database\\mytest\\testfile1.txt”;
13. var filename2 = “D:\\database\\mytest\\testfile2.txt”;
14. var f1 = fso.OpenTextFile(filename1, ForReading, true);
15. // Open the file for input.
16. f2 = fso.OpenTextFile(filename2, ForWriting);
17. f2.WriteLine(“The following have been copied from input file :-“);
18. // Read from the file and display the results.
19. while (!f1.AtEndOfStream)
20. {
21. var r = f1.ReadLine(); //This line will read the data to the input file
22. document.write (r + “”); //This line will display the data on the screen
23. f2.WriteLine(r); //This line will write the data to the output file
24. }
25. f1.Close();
26. f2.Close();