Export to Excel without MS Office installed

[UdoScheuvens]

Hi,

I want to create files in Excel format from a VB application. Of course I read all the threads treating this issue, but I need something different.

I'm looking for a technique that works without Microsoft Excel being installed on the target system. My application should be able to generate such files, but it runs on multiple systems that don't need office for anything else so we would like to save the money for all the office licences.

I also looked for ActiveX controls for this job, but all the one's I found require MS Excel in the background.

Any idea?
Udo

 

[ADoozer]

you could search

http://www.wotsit.org

or a similar site for one of the many excel formats.

[search "xls" and have a read of the following file "Microsoft Excel File Format (versions 2, 3, 4, 5, 95, 97, 2000, XP) [Daniel Rentz]" - 222kb)

good luck!

If somethings hard to do, its not worth doing - Homer Simpson
------------------------------------------------------------------------

http://www.climateprediction.net/index.php

come on... get involved!
To get the best response to a question, please check out FAQ222-2244 first
A General Guide To Excel in VB FAQ222-3383

 

[UdoScheuvens]

This article is quite interesting.

But honestly - I didn't want to spend the next 2 years in understanding and trying to implement an export function myself. Isn't there any further support available somewhere?

 

[ADoozer]

maybe... but i doubt it!

ive not seen one so far!

good luck!

If somethings hard to do, its not worth doing - Homer Simpson
------------------------------------------------------------------------

http://www.climateprediction.net/index.php

come on... get involved!
To get the best response to a question, please check out FAQ222-2244 first
A General Guide To Excel in VB FAQ222-3383

 

[paulbent]

Does the MS ODBC Driver for Excel support the creation of xls files? Just a wild thought, never used it myself.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[vladk]

Why not to create CSV files instead? Excel should read them.

 

[gpzcrasher]

Try looking at

http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=11898&lngWId=1

It will create a biff 2.1 file which can be read by Excel and is pretty simple to use, if a bit basic in formatting cells.

--------------------------------
Codito, ergo sum

 

[williamsenora2000]

how can i transfer data from access to excel using visual basic 6

 

[Swi]

williamsenora2000,

Dim CONN As New ADODB.Connection
Dim NUMOFRECORDS As Long
Screen.MousePointer = vbHourglass
DoEvents
CONN.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & "MDB_PATH_AND_NAME" & _
";"
CONN.Execute "SELECT * INTO [Excel 8.0;" & _
"Database=XL_PATH_AND_NAME].[Books] FROM " & _
"TABLE NAME", NUMOFRECORDS
CONN.Close
Set CONN = Nothing
Screen.MousePointer = vbDefault
MsgBox NUMOFRECORDS & " records copied!", vbInformation

Swi