×Welcome aboard! We are happy you are here and wish you good net-raft!



Together We Can Simplify The World

the current number of solutions:  2304
 (1x)    .htaccess (1x)    AJAX (13x)    ANGULARJS (157x)    ASP (1x)    ASP.NET (4x)    BACKBONE.JS (47x)    BOOTSTRAP (12x)    C# (216x)    COFFEESCRIPT (28x)    CSS (71x)    HTML (47x)    JADE (32x)    JAVA (51x)    JAVASCRIPT (426x)    JQUERY (377x)    JQUERY MOBILE (5x)    JSON (5x)    LARAVEL (23x)    MYSQL (9x)    NODEJS (155x)    ORACLE SQL (19x)    PERL (1x)    PHP (293x)    PYTHON (9x)    REACT (61x)    RUBY (23x)    RUBY ON RAILS (1x)    SHELL (1x)    SQL (90x)    SQL SERVER (3x)    TYPESCRIPT (50x)    VB.NET (26x)    W3.CSS (6x)    W3.JS (40x)    
join us

click to create your account

create excel file c#

(c# create excel file )

- C#

 viewed 26

Comment:
C#

0

// check MS excel object library in Reference Manager

using System;
using System.Windows.Forms;
using System.Runtime.InteropServices;
using Excel = Microsoft.Office.Interop.Excel;

namespace WindowsFormsApplication3
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
if (xlApp == null)
{
MessageBox.Show("MS Excel is not properly installed!");
return;
}

Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlWorkBook = xlApp.Workbooks.Add(misValue); // create new Workbook
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); // sheet1

xlWorkSheet.Cells[1, 1] = "Name";
xlWorkSheet.Cells[1, 2] = "Age";
xlWorkSheet.Cells[2, 1] = "Jack";
xlWorkSheet.Cells[2, 2] = "25";
xlWorkSheet.Cells[3, 1] = "Peter";
xlWorkSheet.Cells[3, 2] = "32";

xlWorkBook.SaveAs("d:\\myexcelfile.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); // save the file
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();

Marshal.ReleaseComObject(xlWorkSheet);
Marshal.ReleaseComObject(xlWorkBook);
Marshal.ReleaseComObject(xlApp);
MessageBox.Show("MS Excel file successfully created!");

}
}
}

     

created: 13 days ago

The power of the user (%)

1%

Do you know a little more effective code ? Feel free to optimize ...


haven't you found what you're looking for ?
Write us your question ...
Login is not needed.


The most helpful C# solutions
Likes Solution Technology
678 detect ie C#C#
129 Get real client ip address using C# ?C#
119 get real user country C#C#
106 get hostname using C#C#
104 how to initialize a connection to mysql database using C# ?C#
Check out all of C# ...
The most viewed C# solutions by country
Solution Country
Get real client latitude and longitude using C# ?Cinque Terre
Get real client latitude and longitude using C# ?Cinque Terre
get current url using C#Cinque Terre
Get real client latitude and longitude using C# ?Cinque Terre
Get real client latitude and longitude using C# ?Cinque Terre