How do I open an Excel spreadsheet with exceljs?

Question

have an ASP.Net website which lets the user write to an excel spreadsheet. The values I wish to write are calculated by a client-side Javascript code. I have had multiple problems to do with Excel because of misunderstandings I've had about servers, clients, and browsers.

I think I may have finally found a solution to my dilemma by writing to Excel using client-side Javascript. I found a library called exceljs which has many of the features I am looking for. However, I reached a snag because I'm not sure how to open an existing Excel spreadsheet. I followed the guide in the documentation on npm, but the approach hasn't worked. For context, the spreadsheet I am talking about is accessible to all users and is stored on the website directly under the main directory.

How should I change the code below ?

JavaScript code:

var Excel = require('exceljs');
var openExcel() {
    var workbook = new Excel.Workbook("../Erics_takeoff_101718.xlsx");
    var worksheet = workbook.getWorksheet('PLAN # 1');
    workbook.views = [
        {
            x: 0, y: 0, width: 100, height: 200,
            firstSheet: 0, activeTab: 1, visibility: 'visible'
        }
    ]

    worksheet.state = 'show';
    return false;
}

Have you tried this: [Exceljs File I/O](https://www.npmjs.com/package/exceljs#file-io) — Marc M., Oct 18 '18 at 18:25
Would I open the spreadsheet by using the code under subsection "Read XLSX" ? — Eric Lopez, Oct 18 '18 at 18:35
Here's a complete example https://stackoverflow.com/a/28862951/1703744 — Marc M., Oct 18 '18 at 18:37
I tried out the example, but I don't see any spreadsheet opening up on the screen. I also set the var filename ="myspreadsheet.xlsx" — Eric Lopez, Oct 18 '18 at 18:47

How do I open an Excel spreadsheet with exceljs?

0 Answers0