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 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 3 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 1, maximum file size 3.9MB.
Supported file formats: zip pdf gif jpg bmp png cs vb theme json