-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathshowexcel.php
85 lines (80 loc) · 2.05 KB
/
showexcel.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
<?php
$host = 'localhost';
$username = 'root';
$password = 'root';
$con = mysql_connect($host, $username, $password);
mysql_select_db('oa');
$sql = 'set names utf8';
mysql_query($sql);
$sql = "select * from work where id='5'";
$query = mysql_query($sql);
$row = mysql_fetch_array($query);
if ($row) {
$exceldata = json_encode(unserialize($row['content']));
}
mysql_close($con);
?>
<?php
/*表格配置存入数组然后放入数据库中*/
$config = array(
/*true设置字符串，否则获取的值为1*/
'rowHeaders' => 'true',
'colHeaders' => 'true',
'startRows' => 5,
'startCols' => 5,
'rowHeaders' => 'true',
'colHeaders' => 'true',
'minSpareRows' => 1,
'contextMenu' => 'true',
'colWidths' => 110
);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
<script src="handsontable/dist/handsontable.full.js"></script>
<script src="./public/js/jquery.min.js"></script>
<script src="public/handsontable/handsontable.full.js"></script>
<link rel="stylesheet" media="screen" href="public/handsontable/handsontable.full.css">
</head>
<body>
<div style="margin-bottom: 50px">
<button id="save">保存</button>
<form action="export.php" method="post">
<input type="hidden" name="id" value="5">
<input type="submit" value="导出excel">
</form>
</div>
<div id="example"></div>
<script>
function sendData() {
return <?php echo $exceldata ?>;
}
var container = document.getElementById('example');
var ht = new Handsontable(container, {
data: sendData(),
//读取配置数组
<?php
foreach ($config as $key=>$value){
echo $key.':'.$value.',';
}
?>
});
$('#save').click(function () {
var data = ht.getData();
$.ajax({
type: 'POST',
url: 'save.php',
data: {
data: data,
},
success: function (msg) {
alert(msg);
}
})
})
</script>
</body>
</html>