Skip to content

Magenaut

  • Home
  • Topics
    • Notes
    • Tutorial
    • Bug fixing
    • Extension
    • Server
  • Q&A
  • Privacy Policy
  • About

excel

Excel like server side control for ASP.NET

August 25, 2022 by Magenaut

We have a requirement to increase the functionality of a grid we are using to edit on our webapp, and our manager keeps citing Excel as the perfect example for a data grid :/ He still doesn’t really get that a Spreadsheet like control doesn’t exist out of the box, but I thought I’d do a bit of searching nonetheless.

Categories ASP.NET, Q&A Tags asp.net, excel, servercontrols Leave a comment

Opening excel files from the internet opens a blank excel window

August 25, 2022 by Magenaut

A method in dumping a GridView to an Excel file to download/open from the internet was recently broken with new Windows Updates.

Categories ASP.NET, Q&A Tags asp.net, excel, intranet, vb.net Leave a comment

Why does excel remain open?

August 24, 2022 by Magenaut

Possible Duplicate:
How to properly clean up Excel interop objects in C#

Categories ASP.NET, Q&A Tags asp.net, c#, excel, interop Leave a comment

c# Excel skipping first row?

August 24, 2022 by Magenaut

I’m importing an xls file using OleDbCommand to a ds. Problem I’m having is during the foreach on my ds its skipping for first row. I can’t figure out why. Any suggestions?

Categories ASP.NET, Q&A Tags asp.net, c#, excel Leave a comment

Some data is missing in the Export to Excel using DataTable and Linq

August 24, 2022 by Magenaut

I am exporting three worked sheet in single XL file, but I am missing some user data in the second DataTable (Education Details sheet) and third DataTable (Employeement Details sheet).

Categories ASP.NET, Q&A Tags asp.net, c#, datatable, excel, linq Leave a comment

External table is not in the expected format.

August 24, 2022 by Magenaut

I am creating a small application to import excel data into my database, when i click the button it crashes with the error

Categories ASP.NET, Q&A Tags asp.net, c#, excel, oledb Leave a comment

Convert excel workbook to byte[]

August 24, 2022 by Magenaut

I have an “excel library” workbook and want to convert it to a byte[] so I could return the data with the File method exist in asp.net mvc controller.
There are “Save” and “SaveToStream” method, but no convert to byte[].

Categories ASP.NET, Q&A Tags asp.net, asp.net-mvc, asp.net-mvc-3, c#, excel Leave a comment

count number of rows in excel using c#

August 23, 2022 by Magenaut

i have the excel sheet with code like

Categories ASP.NET, Q&A Tags asp.net, c#, excel Leave a comment

How do I format my export to excel workbook in microsoft.office.interop.excel?

August 23, 2022 by Magenaut

I have this export function that allows me to export 2 grid views into 2 separated worksheets in one excel.

Categories ASP.NET, Q&A Tags asp.net, c#, excel, gridview Leave a comment

Unknown problem while exporting excel to System.DataTable

August 23, 2022 by Magenaut

I am trying to get data from Excel File to DataTable.

Here’s my code-snippet :

Categories ASP.NET, Q&A Tags asp.net, c#, datatable, excel, oledb Leave a comment
Older posts
Newer posts
← Previous Page1 … Page4 Page5 Page6 … Page9 Next →
  1. michealSmith07 on Is there a way to dynamically refresh the less command?August 21, 2022

    That is a very nice post. I like this post.

  2. anonymous on Fix libwacom9 dependency issue when upgrade DebianJune 27, 2022

    saved my day!! Thanks for the help…

  3. sreedhar on Fix libwacom9 dependency issue when upgrade DebianMay 10, 2022

    Thanks its working

  4. saintnick on Fix libwacom9 dependency issue when upgrade DebianMay 10, 2022

    remove libwacom2 worked for me as well

  5. ranafoul on Fix libwacom9 dependency issue when upgrade DebianApril 22, 2022

    apt remove libwacom2 helped on kali 2022.01. gr8

.net ajax asp.net asp.net-core asp.net-mvc asp.net-mvc-3 asp.net-mvc-4 asp.net-web-api bash c# command-line css custom-post-types custom-taxonomy dataframe dictionary django entity-framework functions gridview html iis javascript jquery json linux list matplotlib numpy pandas php plugin-development plugins posts python python-2.7 python-3.x security shell shell-script sql string vb.net webforms wp-query

© 2026 Magenaut • Built with GeneratePress