Category - Excel
Results 1 - 5 of 100
08 May 2020 08 May 2020 0 Comments  610 Views
Here Mudassar Ahmed Khan has explained with an example, how to read Excel File (xls & xlsx) data in ASP.Net using C# and VB.Net.

When the Excel file is uploaded, the Excel File data is available in the InputStream property of the FileUpload control.

Using ClosedXml library, the Excel file data can be easily read from the InputStream property and displayed on Web Page using GridView in ASP.Net using C# and VB.Net.
06 Sep 2019 06 Sep 2019 0 Comments  12033 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  7441 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  3332 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  9563 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.
Results 1 - 5 of 100