把選擇excel檔案改變成固定檔案

javascript jquery angular xlsx html

crab992010 2019-05-15 15:06:43 ‧ 2800 瀏覽

分享至

請教各位大神，以下是我的把excel的內容輸出到html的function的部分，最下面是input跟button，目前的方式是利用input的方式選擇excel檔案，然後button送出後顯示檔案內容，想問有沒有辦法把"選擇檔案"的方式，改變成路徑，讓一開啟網頁就已經完成原本的"選擇檔案再送出"這樣的動作?

function myController($scope){
			$scope.uploadExcel = function(){
				var myFile = document.getElementById('file');
				var input = myFile;
				var reader = new FileReader();
				reader.onload = function(){
					var fileData = reader.result;
					var workbook = XLSX.read(fileData, {type: 'binary'});
					workbook.SheetNames.forEach(function(sheetName){
						var rowObject = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);
						excelJsonObj = rowObject;
					});
					for(var  i = 0; i < excelJsonObj.length; i++){
						var data = excelJsonObj[i];
						$('#mySelect').append("<option value='"+data.Column1+"'>"+data.Column1.substring(19));
					}		
				};		
				reader.readAsBinaryString(input.files[0]);
			};
		}
        
        
<form enctype="multipart/form-data">
				<input type="file" id="file">
				<button type="submit" value='submit' ng-click="uploadExcel()"> Reflash </button>
			</form>

看更多先前的討論...收起先前的討論...

dragonH iT邦超人 5 級 ‧ 2019-05-15 15:21:09 檢舉

那你的檔案路徑哪裡來?

crab992010 iT邦新手 5 級 ‧ 2019-05-15 15:33:15 檢舉

目前是input去選擇檔案，假設是C:\Users\ting\Desktop\test.xlsx這個檔案，選擇後按button後顯示內容，
想要改成一開啟網頁就已經顯示test.xlsx的內容的方法

crab992010 iT邦新手 5 級 ‧ 2019-05-15 15:34:37 檢舉

<!DOCTYPE html>
<html ng-app='myApp'>
<head>
<meta charset="utf-8">
<title>Reading Excel</title>
<meta name="viewport" content="width=device-width, initial-scale=10">

<script type="text/javascript" src="bs/jquery-3.3.1.min.js"></script>
<script type="text/javascript" src="bs/angular.min.js"></script>
<script type="text/javascript" src="bs/xlsx.full.min.js"></script>
<script type="text/javascript">
//get Subject & Preview in excel
var app = angular.module('myApp', []);
app.controller('MyController', ['$scope', myController]);
var excelJsonObj = [];

function myController($scope){
$scope.uploadExcel = function(){
var myFile = document.getElementById('file');
var input = myFile;
var reader = new FileReader();
reader.onload = function(){
var fileData = reader.result;
var workbook = XLSX.read(fileData, {type: 'binary'});
workbook.SheetNames.forEach(function(sheetName){
var rowObject = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);
excelJsonObj = rowObject;
});
for(var i = 0; i < excelJsonObj.length; i++){
var data = excelJsonObj[i];
$('#mySelect').append("<option value='"+data.Column1+"'>"+data.Column1.substring(19));
}
};
reader.readAsBinaryString(input.files[0]);
};
}
function ChangeText(s)
{
for (var j = 0; j < excelJsonObj.length; j++){
var data2 = excelJsonObj[j];
if( data2.Column1 == s){
document.getElementById("p1").innerHTML=data2.Column2;
}
}
}
</script>
</head>
<p>[Certificated Patch]</p>
<body ng-controller='MyController'>
<div>
<form enctype="multipart/form-data">
<input type="file" id="file">
<button type="submit" value='submit' ng-click="uploadExcel()"> Reflash </button>
</form>
</div>

<select id="mySelect" onclick="ChangeText(this.options[this.options.selectedIndex].value)">
</select>
<hr>
<span id="p1">Select which one you want!</p>
</body>
</html>

這是目前的

&lt;!DOCTYPE html&gt;
&lt;html ng-app='myApp'&gt;
    &lt;head&gt;
        &lt;meta charset=&quot;utf-8&quot;&gt;
        &lt;title&gt;Reading Excel&lt;/title&gt;
		&lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=10&quot;&gt;
		
		&lt;script type=&quot;text/javascript&quot; src=&quot;bs/jquery-3.3.1.min.js&quot;&gt;&lt;/script&gt;
		&lt;script type=&quot;text/javascript&quot; src=&quot;bs/angular.min.js&quot;&gt;&lt;/script&gt;
		&lt;script type=&quot;text/javascript&quot; src=&quot;bs/xlsx.full.min.js&quot;&gt;&lt;/script&gt;
		&lt;script type=&quot;text/javascript&quot;&gt;
		//get Subject &amp; Preview in excel
		var app = angular.module('myApp', []);
		app.controller('MyController', ['$scope', myController]);
		var excelJsonObj = [];

這是目前的

修改

froce iT邦大師 1 級 ‧ 2019-05-15 15:45:41 檢舉

應該是不行，違反瀏覽器的安全性。

dragonH iT邦超人 5 級 ‧ 2019-05-15 16:05:02 檢舉

我記得不行唷

https://stackoverflow.com/questions/1696877/how-to-set-a-value-to-a-file-input-in-html

https://stackoverflow.com/questions/23279227/set-file-path-for-input-type-file

你連真正的路徑好像都拿不到

只會拿到

C:\fakepath\test.xlsx

登入發表討論