Create xls file gibrish

Question

I am trying to return xls file in hebrew but it returns me gibrish letters and writes that the file extension isn't the file real content.

Please help me.

public void ExportAddBalanceExcel(int CompanyID)
{
    string writer = "";
    writer += "<table><tr><td>UserName</td><td> PrivateName</td><td>LastName</td><td>Balance</td></tr>";

    List<CompanyEmployee> employees = Company.LoadByID(CompanyID).LoadAllEmployees();

    foreach (BLL.CompanyEmployee e in employees)
    {
        writer += "<tr>";
        writer += "<td>" + e.EmployeeUserName+ "</td>";
        writer += "<td>" + e.EmployeeFirstName+ "</td>";
        writer += "<td>" + e.EmployeeLastName  + "</td>";
        writer += "</tr>";
    }
    writer += "</table>";
    string currentData = DateTime.Now.Day + "_" + DateTime.Now.Month + "_" + DateTime.Now.Year;

    Response.ContentType = "application/vnd.ms-excel";
    Response.AppendHeader("Content-Disposition", "attachment; filename=AddBalanceToEmployees_" + currentData + ".xls");
    Response.ContentEncoding = System.Text.Encoding.GetEncoding("windows-1255");
    Response.Write(writer);
    Response.Flush();
    Response.End();            
}

Then you're using it wrong. UTF8 supports the full range of Unicode characters. — SLaks, Nov 30 '14 at 16:21
oh pleas do me a favor i used it very good Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8"); — Limor, Nov 30 '14 at 16:23
Do you *have* to create a .XLS file? Or would creating a .XLSX file be acceptable? .XLSX is simple, there's a ton of excellent libraries for creating it. — mason, Nov 30 '14 at 16:41

score 0 · Answer 1 · answered Nov 30 '14 at 16:44

How would this be opened in Excel? You seem to be generating some HTML-like syntax that you're telling the client is an Excel file.

To write to Excel, you could use COM Interop (though this is not recommended for use server-side), or if XLSX is sufficent you could look at the OpenXML SDK (a simple example here). If you require XLS you might want to check out some 3rd party libraries.

Create xls file gibrish

1 Answers1