Category - Excel
Results 1 - 5 of 99
06 Sep 2019 06 Sep 2019 0 Comments  7766 Views
Here Mudassar Ahmed Khan has explained with an example, how to download (save) VARBINARY data as File from SQL Server database table in ASP.Net using C# and VB.Net.

Files such as Images, PDF, Word or Excel Documents, Audio and Video files will be saved as VARBINARY data in SQL Server database table and later the VARBINARY data will be converted back to the file and downloaded in ASP.Net using C# and VB.Net.
06 Sep 2019 06 Sep 2019 0 Comments  4547 Views
Here Mudassar Ahmed Khan has explained with an example, how to download (save) VARBINARY data from SQL Server database table using Entity Framework in ASP.Net MVC Razor.

Files will be uploaded and then will be saved (inserted) to database table as VARBINARY data. The file in VARBINARY data format will be retrieved and displayed in HTML Grid (Table) consisting of a Link for downloading the VARBINARY data as file from database.
24 Jun 2019 24 Jun 2019 0 Comments  1823 Views
Here Mudassar Ahmed Khan has explained with an example, how to get list of Sheet (WorkSheet) names of Excel file in ASP.Net using C# and VB.Net.

The Excel file will be first uploaded and copied to a Folder (Directory) on Server and then it will be read and opened using OLEDB and the Sheet (WorkSheet) Names of the Excel file will be fetched.
16 May 2019 16 May 2019 0 Comments  7952 Views
Here Mudassar Ahmed Khan has explained with an example, how to remove HyperLink when exporting GridView to Excel in ASP.Net using C# and VB.Net.

When the GridView TemplateField columns contain controls like HyperLink, TextBox, Button, LinkButton, RadioButton or CheckBox controls then such controls need to be replaced with Literal control and then the GridView is exported to Excel file in ASP.Net using C# and VB.Net.
11 Feb 2019 18 Feb 2019 0 Comments  5779 Views
Here Mudassar Ahmed Khan has explained with an example, how to export HTML Table to Excel file using jQuery in ASP.Net MVC Razor.

The HTML Table will be exported (converted) to Excel file using the jQuery table2excel plugin in ASP.Net MVC Razor.
Results 1 - 5 of 99