Solved

how can i create excel file  using vb.net , but i did not install excel application in my system.

Posted on 2009-04-15
9
333 Views
Last Modified: 2012-05-06
how can i create excel file  using vb.net , but i did not install excel application in my system.
0
Comment
Question by:mseit
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 53

Expert Comment

by:Dhaest
ID: 24147557
Generate Excel files without using Microsoft Excel
http://www.codeproject.com/KB/office/biffcsharp.aspx
0
 
LVL 53

Accepted Solution

by:
Dhaest earned 500 total points
ID: 24147573
Reading and Writing Excel Spreadsheets Using ADO.NET C# DbProviderFactory
http://davidhayden.com/blog/dave/archive/2006/05/26/2973.aspx

Writing data to excel using oledb
http://p2p.wrox.com/c/1745-create-excel-file-without-excel-being-installed.html
0
 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 24147620
I'm not sure if it comes standard with Visual Studio, but on your References dialog, underneath the COM tab there should be a listing for Microsoft Excel [version #] Object Library, or similar. You can add a reference to that and create Excel applications/files.
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 53

Expert Comment

by:Dhaest
ID: 24147629
@Kaufmed --> this comes only if you have owc or excel installed on the pc !
0
 

Expert Comment

by:rdskill
ID: 24148010
This worked for me.

David
        Dim connectionStringTemplate As String = "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" & _
                                c_FileName & ";DefaultDir=" & My.Settings.SaveAttachmentTo & ";"
 
        Dim cn As String = connectionStringTemplate
        Dim sqlSelect As String = "SELECT * FROM [DigitraceExportqy$];"    ' The name of the worksheet followed by $.       
        ' Load the Excel worksheet into a DataTable      
        Dim workbook As DataSet = New DataSet()
        Dim excelAdapter As System.Data.Common.DataAdapter = _
                New System.Data.Odbc.OdbcDataAdapter(sqlSelect, cn)
        Try
            excelAdapter.Fill(workbook)
            Dim ws As DataTable = workbook.Tables(0)
            ' build table for converted data
            Dim tbl As New DataTable
            tbl.Columns.Add("Type")
            tbl.Columns.Add("Order")
            tbl.Columns.Add("Active?")
            tbl.Rows.Add(row)
 
        Catch ex As Exception
            MessageBox.Show(ex.Message, My.Settings.ProgramTitle, MessageBoxButtons.OK, MessageBoxIcon.Error)
 
        End Try

Open in new window

0
 

Expert Comment

by:rdskill
ID: 24148059
sorry.... goofed the snippet copy...  
        Dim connectionStringTemplate As String = "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" & _
                                FileName & ";DefaultDir=" & My.Settings.SaveAttachmentTo & ";"
 
        Dim cn As String = connectionStringTemplate
        Dim sqlSelect As String = "SELECT * FROM [DigitraceExportqy$];"    ' The name of the worksheet followed by $.       
        ' Load the Excel worksheet into a DataTable      
        Dim workbook As DataSet = New DataSet()
        Dim excelAdapter As System.Data.Common.DataAdapter = _
                New System.Data.Odbc.OdbcDataAdapter(sqlSelect, cn)
        Try
            excelAdapter.Fill(workbook)
            Dim ws As DataTable = workbook.Tables(0)
            ' build table for converted data
            Dim tbl As New DataTable
            tbl.Columns.Add("Type")
            tbl.Columns.Add("Order")
            tbl.Columns.Add("Active?")
  
            For Each wsRow As DataRow In ws.Rows
                Dim row As DataRow = tbl.NewRow
                row(0) = wsRow.Item(1).ToString.ToUpper         
                row(1) = wsRow.Item(13).ToString.ToUpper        
                row(2) = wsRow.Item(2).ToString.ToUpper         
	        tbl.Rows.Add(row)
	    next
 
        Catch ex As Exception
            MessageBox.Show(ex.Message, My.Settings.ProgramTitle, MessageBoxButtons.OK, MessageBoxIcon.Error)
 
        End Try

Open in new window

0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 24148172
0
 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 24148509
@Dhaest -- Yeah I wasn't sure about that, but I could have sworn I saw a download for an Office SDK that was independent of the suite. But I can't find it now. No visit from the SDK fairy this time  :(
0
 

Author Closing Comment

by:mseit
ID: 31570417
Good
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question