WTD: Simple Function to Export DataGridView to Excel

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Mike Wilson

    #1

    WTD: Simple Function to Export DataGridView to Excel

    Dear all,

    I'm sure someone has already done this, so as not to wish to re-invent the
    wheel - and Google not turning up anything I can use, does anyone have a
    suitable function into which I can pass a DataGridView - and have all the
    columns and rows parsed and an Excel Workbook created with the DataGridView
    contents and column headers transposed onto the first Worksheet?

    Many thanks in advance!

    Mike

  • mnadeem.abbasi@gmail.com

    #2
    Re: WTD: Simple Function to Export DataGridView to Excel

    On Apr 5, 6:04 pm, "Mike Wilson" <liddlefeeshSor ryNoS...@gmail. com>
    wrote:
    Dear all,
    >
    I'm sure someone has already done this, so as not to wish to re-invent the
    wheel - and Google not turning up anything I can use, does anyone have a
    suitable function into which I can pass a DataGridView - and have all the
    columns and rows parsed and an Excel Workbook created with the DataGridView
    contents and column headers transposed onto the first Worksheet?
    >
    Many thanks in advance!
    >
    Mike
    Check this article
    http://www.codeguru.com/forum/archiv.../t-411456.html

    --NA

    Comment

    • Mike Wilson

      #3
      Re: WTD: Simple Function to Export DataGridView to Excel

      <mnadeem.abbasi @gmail.comwrote in message
      news:1175782215 .623582.150940@ n59g2000hsh.goo glegroups.com.. .
      On Apr 5, 6:04 pm, "Mike Wilson" <liddlefeeshSor ryNoS...@gmail. com>
      wrote:
      >Dear all,
      >>
      >I'm sure someone has already done this, so as not to wish to re-invent
      >the
      >wheel - and Google not turning up anything I can use, does anyone have a
      >suitable function into which I can pass a DataGridView - and have all the
      >columns and rows parsed and an Excel Workbook created with the
      >DataGridView
      >contents and column headers transposed onto the first Worksheet?
      >>
      >Many thanks in advance!
      >>
      >Mike
      >
      Check this article
      http://www.codeguru.com/forum/archiv.../t-411456.html
      Many thanks - helpful article.

      M

      Comment

      Working...