to excel

Welcome to Wisej Support.
Questions, suggestions and plain old bugs - are all welcome here!
Answered
0
0

Hi, I need to export my datagridview to excel; is there something I can use for that? I installed AccessDatabaseEngine to use

interp.excel but the application not start with this reference.

  • roni neri
    I cannot copy the grid in clipboard; I would like to use some examples because it seems that the grid is not enabled to do so
  • You must to post comments
Best Answer
0
1

With the NPOI classes I managed to create a “stream” of datagridview and download it as xls file

  • You must to post comments
0
0

You can use ExcelLibrary.dll from  https://code.google.com/archive/p/excellibrary/downloads

and use code to export .xls file

string filename = HttpContext.Current.Server.MapPath(“export.xls”);

DataTable dt = new DataTable();
foreach (DataGridViewColumn col in dataGridView1.Columns)
{
dt.Columns.Add(col.HeaderText);
}

foreach (DataGridViewRow row in dataGridView1.Rows)
{
DataRow dRow = dt.NewRow();
foreach (DataGridViewCell cell in row.Cells)
{
if (cell.Value != null)
{
dRow[cell.ColumnIndex] = cell.Value.ToString();
}else
{
dRow[cell.ColumnIndex] = “”;
}
}
dt.Rows.Add(dRow);
}

DataSet ds1 = new DataSet();
ds1.Tables.Add(dt);
ds1.Locale = System.Threading.Thread.CurrentThread.CurrentCulture;

//Here’s the easy part. Create the Excel worksheet from the data set
ExcelLibrary.DataSetHelper.CreateWorkbook(filename, ds1);

Application.Download(filename);

ขอบคุณครับ

  • You must to post comments
0
0

You can use ClosedXML:

https://github.com/ClosedXML/ClosedXML

Lots of examples if you Google it. This will create actual Excel or Word documents.

 

  • You must to post comments
0
0

You can use the built-in DataGridView.GetClipboardContent(), it will return HTML that can be opened by Excel. Look also at ClipboardCopyMode:

http://wisej.com/docs/html/P_Wisej_Web_DataGridView_ClipboardCopyMode.htm

http://wisej.com/docs/html/M_Wisej_Web_DataGridView_GetClipboardContent.htm

Here is a video showing the same functionality copied to excel:

http://www.screencast.com/t/76izqzD8F

 

 

  • You must to post comments
Showing 4 results
Your Answer
Post as a guest by filling out the fields below or if you already have an account.
Name*
E-mail*
Attachment
File Name Size
There are currently no files uploaded.
Maximum number of files 5, maximum file size 3.9MB.
Supported file formats: zip pdf gif jpg bmp png cs vb theme json