Comment on Tutorial - How to export from DataGridView to excel using VB.net By Issac
Comment Added by : Alphin
Comment Added at : 2012-07-06 10:57:07
Comment on Tutorial : How to export from DataGridView to excel using VB.net By Issac
I am using VS 2010 Express and MS Excel 2007 wherein I am trying to export data from the DataGridView into an Excel file.
xlWorkSheet.SaveAs(“C:\ExportTagDetails.xlsxâ€)
the above line of code works for me. But if I again try to create a file, it obviously shows the Message : ‘A file named ‘C:\ExportTagDetails.xlsx’ already exists in this location. Do you want to replace it?’
When I press Yes it creates no problem and calmly replaces itself in place of the old file. But if I click on No or Cancel then it throws an exception stating : ‘System.Runtime.Interop.Services.COMException(0x800A03EC): Exception from HRESULT: 0x800A03EC’
Here is the entire block of code :
Private Sub cmd_export_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmd_export.Click
Dim xlApp As Microsoft.Office.Interop.Excel.Application = New Microsoft.Office.Interop.Excel.Application
Dim xlWorkBook As Excel.Workbook
Dim xlWorkSheet As Excel.Worksheet
Dim misValue As Object = System.Reflection.Missing.Value
Dim i As Integer
Dim j As Integer
Dim row As Long = 1
xlWorkBook = xlApp.Workbooks.Add(misValue)
xlWorkSheet = xlWorkBook.Sheets(“Sheet1″)
xlWorkSheet.Cells(1, 1).Font.Bold = True
xlWorkSheet.Cells(1, 1).Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red)
xlWorkSheet.Cells(1, 2).Font.Bold = True
xlWorkSheet.Cells(1, 2).Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red)
xlWorkSheet.Columns(1).ColumnWidth = 45
xlWorkSheet.Columns(2).ColumnWidth = 30
xlWorkSheet.Range(“A†& row).Value = “Tag Nameâ€
xlWorkSheet.Range(“B†& row).Value = “Start Valueâ€
row = row + 1
Try
For i = 0 To DataGridView1.RowCount – 2
For j = 0 To DataGridView1.ColumnCount – 1
xlWorkSheet.Cells(i + 2, j + 1) = DataGridView1(j, i).Value.ToString()
Next
Next
xlWorkSheet.SaveAs(“C:\ExportTagDetails.xlsxâ€)
Catch ex As Exception
MsgBox(ex.ToString)
End Try
xlWorkBook.Close()
xlApp.Quit()
releaseObject(xlApp)
releaseObject(xlWorkBook)
releaseObject(xlWorkSheet)
MsgBox(“You can find the file at C:\ExportTagDetails.xlsxâ€)
End Sub
Is there any way I can handle the issue.
Or can you provide me with a solution where the user can himself enter the name of the file and also specify the location.
Thanks in advance.
View Tutorial
- Data Science
- Android
- AJAX
- ASP.net
- C
- C++
- C#
- Cocoa
- Cloud Computing
- HTML5
- Java
- Javascript
- JSF
- JSP
- J2ME
- Java Beans
- EJB
- JDBC
- Linux
- Mac OS X
- iPhone
- MySQL
- Office 365
- Perl
- PHP
- Python
- Ruby
- VB.net
- Hibernate
- Struts
- SAP
- Trends
- Tech Reviews
- WebServices
- XML
- Certification
- Interview
categories
Related Tutorials
Java program to get location meta data from an image
Program using concept of byte long short and int in java
Update contents of a file within a jar file
Tomcat and httpd configured in port 8080 and 80
Count number of vowels, consonants and digits in a String in Java
Student marks calculation program in Java
Calculate gross salary in Java
Calculate average sale of the week in Java
Vector in Java - Sample Program
Archived Comments
1. ya its correct but tell me where is main method???
View Tutorial By: kashiNATH MOKASHI at 2011-08-20 05:33:19
2. this is WRONG!
your IF should be:
View Tutorial By: notnooblikeyou at 2013-01-29 15:11:30
3. I am running it within NetBeans. I set a breakpoin
View Tutorial By: PeteC at 2014-02-22 18:57:14
4. Hi sir, Your explain is very good sir,
View Tutorial By: Surendra Majji at 2013-02-14 04:55:49
5. its very good example explains what is an abstarct
View Tutorial By: sandeep at 2012-01-06 07:13:29
6. Hi
I have a USB bluetooth that plug in my c
View Tutorial By: Duong D. Thien at 2008-06-25 06:09:07
7. if time out at step 6*** Exception is occure
View Tutorial By: Bharat at 2011-08-17 10:42:23
8. when i am trying to compile your program one error
View Tutorial By: anindya at 2011-11-23 03:00:49
9. http://www.java-samples.com/showtutorial.php?tutor
View Tutorial By: Prab at 2009-04-13 11:54:17
10. can anyone tell me which type of device i need to
View Tutorial By: dhanunjay at 2009-04-01 00:31:17