Skip to content

Tag Archives: Excel

Import Data from Excel using C# – Part 2

16-Feb-10

In my web application, we used to import data from MS Excel file. Few days before one of the client representative posted an issue that he can’t import data from XLSX (MS Excel 2007 File Format) files. Previously we were using OLE DB provider to import data from Excel file (Checkout my previous post regarding [...]

Filed in .Net, .Net 3.0 / 3.5, ASP.Net, Windows Forms | Also tagged , , , | Comments (0) »

Import / export data in MS Excel using C#

23-Sep-09

Sometimes we may require to generate Excel file from our reports,read from excel files to import data etc. This can be achieved using Office Interop (Office Automation) assemblies, but Office Automation in Web servers,got some issues;(More details: http://support.microsoft.com/kb/257757). The alternative is using OleDb provider. You may need to add one more attribute to connection string [...]

Filed in .Net, .Net 3.0 / 3.5, ASP.Net | Also tagged , , , , , , | Comments (1) »