Click here to Skip to main content
15,885,278 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionSetup Project won't build/re-build Pin
HamCoder22-Feb-07 0:52
HamCoder22-Feb-07 0:52 
AnswerRe: Setup Project won't build/re-build Pin
Johan Hakkesteegt22-Feb-07 21:07
Johan Hakkesteegt22-Feb-07 21:07 
QuestionPInvoke Imbalance Stack function Pin
sundar_mca22-Feb-07 0:39
sundar_mca22-Feb-07 0:39 
AnswerRe: PInvoke Imbalance Stack function Pin
Guffa22-Feb-07 0:54
Guffa22-Feb-07 0:54 
GeneralRe: PInvoke Imbalance Stack function Pin
sundar_mca22-Feb-07 1:24
sundar_mca22-Feb-07 1:24 
GeneralRe: PInvoke Imbalance Stack function Pin
Dave Kreskowiak22-Feb-07 3:16
mveDave Kreskowiak22-Feb-07 3:16 
QuestionExport DatagridView to Excel Pin
Socheat.Net21-Feb-07 22:40
Socheat.Net21-Feb-07 22:40 
AnswerRe: Export DatagridView to Excel Pin
Dave Kreskowiak22-Feb-07 4:44
mveDave Kreskowiak22-Feb-07 4:44 
You don't export the DataGridView. You export the data that the grid is bound to, like a DataTable or a DataSet object. In either case, the process is the same. The easy way is to create a normal Text file with a filename of something.CSV (comma seperated values) and iterate through your data tables, row-by-row, writing each column value, converted to a string, to the file with a comma between the values.

The harder way is to instantiate an Excel object, create a new workbook, then a new worksheet in the workbook, go through your data tables the same way you do for a CSV file, and place each value in the tables into a cell in the worksheet, saving the workbook when your done.

There's tons of examples out on the net. All you have to do is Google for "VB.NET export datagrid to excel".


Dave Kreskowiak
Microsoft MVP - Visual Basic


QuestionSet a column in datagrid to display a time. Pin
kendo1721-Feb-07 22:04
kendo1721-Feb-07 22:04 
AnswerRe: Set a column in datagrid to display a time. Pin
Christian Graus21-Feb-07 23:00
protectorChristian Graus21-Feb-07 23:00 
QuestionHow I add referense to? Pin
Agbaria Ahmad21-Feb-07 21:25
Agbaria Ahmad21-Feb-07 21:25 
AnswerRe: How I add referense to? Pin
teejayem27-Feb-07 15:16
teejayem27-Feb-07 15:16 
QuestionRemote port communication Pin
shreekar21-Feb-07 20:45
shreekar21-Feb-07 20:45 
AnswerRe: Remote port communication Pin
Dave Kreskowiak22-Feb-07 3:11
mveDave Kreskowiak22-Feb-07 3:11 
Questionchecking for a substring Pin
ArchaBhandare21-Feb-07 20:19
ArchaBhandare21-Feb-07 20:19 
AnswerRe: checking for a substring Pin
TwoFaced21-Feb-07 20:59
TwoFaced21-Feb-07 20:59 
GeneralRe: checking for a substring Pin
ArchaBhandare21-Feb-07 21:10
ArchaBhandare21-Feb-07 21:10 
GeneralRe: checking for a substring Pin
TwoFaced21-Feb-07 21:13
TwoFaced21-Feb-07 21:13 
GeneralRe: checking for a substring Pin
ArchaBhandare21-Feb-07 21:25
ArchaBhandare21-Feb-07 21:25 
QuestionHow to correct Email address in SMTP format instead of EX in GAL Pin
virendra patel21-Feb-07 17:04
virendra patel21-Feb-07 17:04 
AnswerRe: How to correct Email address in SMTP format instead of EX in GAL Pin
Christian Graus21-Feb-07 19:12
protectorChristian Graus21-Feb-07 19:12 
QuestionHow to set Email type EX to SMTP in outlook address book Pin
virendra patel21-Feb-07 16:56
virendra patel21-Feb-07 16:56 
QuestionFolder exists in VB Pin
ArchaBhandare21-Feb-07 16:49
ArchaBhandare21-Feb-07 16:49 
AnswerRe: Folder exists in VB Pin
Christian Graus21-Feb-07 19:12
protectorChristian Graus21-Feb-07 19:12 
AnswerRe: Folder exists in VB Pin
Dave Kreskowiak22-Feb-07 3:08
mveDave Kreskowiak22-Feb-07 3:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.