'How to return value from a cell on an Excel spreadsheet in JavaScript
I've been trying to figure out a way to access an Excel Spreadsheet in JavaScript and return the values stored within the cells based on the row/column they're located in. So far, I've tried this function:
function ReadData(cell, row) {
var excel = new ActiveXObject("Excel.Application");
var excel_file = excel.Workbooks.Open("Sudoku Puzzle.xls");
var excel_sheet = excel.Worksheets("Sheet1");
var data = excel_sheet.Cells(cell, row).Value;
return data
}
But I get an Uncaught TypeError that states that ActiveXObject is not Defined. I know that the ActiveXObject isn't compatible in modern browsers, which was why I was wondering if there was an overall different method I could use.
Thanks.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
