如何将数据从HTML页面写入位于服务器上的现有csv文件 [英] How to write data from HTML page into existing csv file located on server

问题描述

我想将数据写入CSV文件，该文件从HTML页面保存在服务器上。



我在IIS服务器上使用它。

需要用于ActiveX的alternet，以便我也可以在其他浏览器上使用它。



谢谢



我尝试了什么：



函数saveToCSV（文件名）{

var fso = new ActiveXObject（Scripting .FileSystemObject）;

var file = fso.CreateTextFile（filename，true）;



var rows = document.querySelectorAll（table tr）;



var datatowrite =;



for（var i = 0; i < rows.length; i ++）{

var row = []，cols = rows [i] .querySelectorAll（td，th）;



datatowrite = datatowrite + cols [1] .innerText +，+ document.getElementById（'txtque'+ cols [1] .innerText）.value +，+ document.getElementById（'txtans'+ cols [1] .innerText）.value +\ n;

}

datatowrite = datatowrite.slice（0，-1）;



file.writeline（Sr。 No.，Question，Answer \ n+ datatowrite）;

file.Close（）;

alert（'Data saved。'）;

}

解决方案

您需要一个服务器端应用程序来写入服务器.PHP是我选择的语言。由于您使用的是IIS，如果没有安装PHP，你可能需要使用ASP。



PHP与javaScript没有太大区别。在这里学习： PHP教程 [ ^ ]他们也有一个ASP教程。



这绝对物有所值 - 它为网页的可能性增加了很多。结果

I want to write data into CSV file which is saved on server from HTML page.

I am using it on IIS server.
needed alternet for ActiveX so that i can use it on other browsers too.

Thanks

What I have tried:

function saveToCSV(filename) {
var fso = new ActiveXObject("Scripting.FileSystemObject");
var file = fso.CreateTextFile(filename, true);

var rows = document.querySelectorAll("table tr");

var datatowrite = "";

for (var i = 0; i < rows.length; i++) {
var row = [], cols = rows[i].querySelectorAll("td, th");

datatowrite = datatowrite + cols[1].innerText + "," + document.getElementById('txtque' + cols[1].innerText).value + "," + document.getElementById('txtans' + cols[1].innerText).value + "\n";
}
datatowrite = datatowrite.slice(0, -1);

file.writeline("Sr. No.,Question,Answer\n" + datatowrite);
file.Close();
alert('Data saved.');
}

解决方案

You need a server-side application to write to the server. PHP is my language of choice for this. Since you're using IIS, you may need to use ASP if PHP is not installed.

PHP is not too different than javaScript. Learn it here: PHP Tutorial[^] They have an ASP Tutorial, as well.

It's definitely worth the effort - it adds so much to the possibilities available with webpages.

这篇关于如何将数据从HTML页面写入位于服务器上的现有csv文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！