Exporting HTML table to Excel in aspx page with arabic conte

I wrote code using Ajax/C# that will append data with jQuery to HTML table ,this is the table headers:

table id='tblUsers' class='table table-striped table-condensed table-hover table-bordered table-responsive' >
<tr>
<th>Customer IDth>
<th>Customer Nameth>
<th>File #th>
<th>Territoryth>
<th>Start Dateth>
<th>Goods Descth>
<th>Custom Declarationth>
<th>Quantityth>
<th>Weightth>
<th>Volumetric Weightth>
<th>Mortage Amountth>
<th>Invoice#th>
<th>Invoice Amountth>
tr>
table>

and this is the Ajax Call:

$.ajax({
url: "WebService.asmx/showResult",
type: "post",
data: JSON.stringify({
"dateFrom": $('#txtDateFrom').val(),
"dateTo": $('#txtDateTo').val(),
"ddlType": $("#ddlType").children("option").filter(":selected").val(),
"ddlTer": $("#ddlTer").children("option").filter(":selected").val(),
"ddlFilter": $("#filter").children("option").filter(":selected").val()
}), // parameters
beforeSend: function () {
$('#loader').html('');
},
contentType: "application/json; charset=utf-8",
success: function (result) {
$('#loader').html('');
document.getElementById('filter').style.display = 'inherit';
document.getElementById('logo').style.display = 'none';
document.getElementById('exp').style.display = 'inherit';
//To delete the whole tr except the first one.
$("#tblUsers").find("tr:gt(0)").remove();
$('#tblUsers').append(JSON.stringify(result));
if ($("#ddlType").val() != 0) {
document.getElementById('filter').style.display = 'none';
}
},
error: function () {
alert('error');
}
});

The WebMethod:

var sp = db.divideTypes(dateFrom, dateTo, ddlFilter).ToList();
foreach (var u in sp)
{
result += "";
result += "" + u.custid + "";
result += "" + u.custname + "";
result += "" + u.depno + "";
result += "" + u.Terr + "";
result += "" + u.deidate + "";
result += "" + u.gooddesc+ "";
result += "" + u.custdec + "";
result += "" + u.pkg + "";
result += "" + u.wt + "";
result += "" + u.vwt + "";
result += "" + u.lcamt+ "";
result += "" + u.invno + "";
result += "" + u.invamt + "";
result += "";
result += "";
}

i tried to read articles over the web to export excel table as excel file but using JQuery, http://wsnippets.com/export-html-table-data-excel-sheet-using-jquery/

Heading

and there's a lot of articles like this all of them failed because i want to render Arabic letters so the letters looks strange.

i notice that there's an article in stackOverflow:http://stackoverflow.com/questions/17988417/export-data-table-with-arabic-data-to-excel

that talk about a situation similar to mine, but really i don't know how to implement it.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Fares Ayyad10y ago
Ekrem Tapan
i add the html and body tag but still doesn't work
Ekrem Tapan10y ago
try to like that below.
result+="<html>"
result+="<body>"
foreach(varuinsp)
{
result+="<tr>";
result+="<td>"+u.custid+"</td>";
result+="<td>"+u.custname+"</td>";
result+="<td>"+u.depno+"</td>";
result+="<td>"+u.Terr+"</td>";
result+="<td>"+u.deidate+"</td>";
result+="<td>"+u.gooddesc+"</td>";
result+="<td>"+u.custdec+"</td>";
result+="<td>"+u.pkg+"</td>";
result+="<td>"+u.wt+"</td>";
result+="<td>"+u.vwt+"</td>";
result+="<td>"+u.lcamt+"</td>";
result+="<td>"+u.invno+"</td>";
result+="<td>"+u.invamt+"</td>";
result+="<td></td>";
result+="</tr>";
}
result+="</body>"
result+="</html>"
Fares Ayyad10y ago
My issue is with Arabic letters, doesn't appear correctly.
I you noticed the second column which is the customer name in Arabic.
Bikesh Srivastava10y ago
you are doing good,
there are many method to do this.
but what error you are getting.??