Office has detected a problem with this file. To help protect your computer this file cannot be opened.

Hi,

If you got this below error on your code,

Office has detected a problem with this file. To help protect your computer this file cannot be opened.

Here you can find the solution to avoid such errors.


Just add this below line when you are initializing excel application.

if you set it to msoFileValidationSkip before the Open statement, it should bypass the file protection check.

excelApp.FileValidation = MsoFileValidationMode.msoFileValidationSkip;

How to get the value from HTML control to code behind?

Here you can find the value from HTML control to code behind using ASP.net

if you still want to get or set values to HTML controls without runat="server" then you can use Request.Form collection to get the value. You can use public property and embedded code blocks to set the value from server. Refer the code below,



ASPX
<input id="txt1" name="txt1" type="text" value="Set in Client Side" />

<input id="txt2" name="txt2" type="text" value="<% =ServerValue %>" />


CodeBehind

public string ServerValue = String.Empty;

protected void btnSave_Click(object sender, EventArgs e)

    {
        string ClientValue = Request.Form["txt1"];
        ServerValue = "Set in Server";
    }
}

Please like .....