Tuesday 10 June 2014

Read Excel Using Javascript ActiveXObject

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<script type="text/javascript">
function Read() {
var excel = new ActiveXObject("Excel.Application");
var excel_file = excel.Workbooks.Open("D:\\Myexcel.xlsx");
var excel_sheet = excel_file.Worksheets("Sheet1");
var irows = excel.ActiveSheet.UsedRange.Rows.Count;
var jCol = excel.ActiveSheet.UsedRange.Columns.Count;
var data;
for (var intRow = 0; intRow < irows; intRow++) {
for (var intCol = 0; intCol < jCol; intCol++) {
data = excel_sheet.Cells(1, 2).Value; //Working fine
// data = excel_sheet.Cells(intRow, intCol).Value; -Getting Error
alert(data);
}
}
}
</script>
</head>
<body>
<input type="button" onclick="Read();" value="Click to read 1" name="btnClick1">
</body>
</html>