Writing Excel Files W/O Existing Excel Application 
Author Message
 Writing Excel Files W/O Existing Excel Application

Hello!
I was wondering if anyone knows of a way to write Excel files without having
Excel installed on the computer.  I don't care about graphs or any kind of
other inserted object.  I just need text, numbers, formulas and fonts.  It
has to support multiple sheets though.  I have considered ODBC but I am
hoping there is another option.

Thanks!
Matthew Hanna



Tue, 12 Apr 2005 21:59:50 GMT  
 Writing Excel Files W/O Existing Excel Application
The only product I've seen recently that can create Excel workbooks without
Excel installed is....

SpeedGen for Microsoft? Excel
http://www.excelspeedgen.com/


--
Ken Halter - MS-MVP-VB - Please keep it in the groups..
http://www.vbsight.com - http://www.vbsight.com/MultiColumn.htm
http://www.vbsight.com/TBGDialogCTL.htm


Quote:
> Hello!
> I was wondering if anyone knows of a way to write Excel files without
> having Excel installed on the computer.  I don't care about graphs or
> any kind of other inserted object.  I just need text, numbers,
> formulas and fonts.  It has to support multiple sheets though.  I
> have considered ODBC but I am hoping there is another option.

> Thanks!
> Matthew Hanna



Tue, 12 Apr 2005 22:11:29 GMT  
 Writing Excel Files W/O Existing Excel Application
Wow!  Your right.  Pretty expensive.  Maybe the boss will still bite.
Thanks!


Quote:
> The only product I've seen recently that can create Excel workbooks
without
> Excel installed is....

> SpeedGen for Microsoft? Excel
> http://www.excelspeedgen.com/


> --
> Ken Halter - MS-MVP-VB - Please keep it in the groups..
> http://www.vbsight.com - http://www.vbsight.com/MultiColumn.htm
> http://www.vbsight.com/TBGDialogCTL.htm



> > Hello!
> > I was wondering if anyone knows of a way to write Excel files without
> > having Excel installed on the computer.  I don't care about graphs or
> > any kind of other inserted object.  I just need text, numbers,
> > formulas and fonts.  It has to support multiple sheets though.  I
> > have considered ODBC but I am hoping there is another option.

> > Thanks!
> > Matthew Hanna



Tue, 12 Apr 2005 22:42:38 GMT  
 Writing Excel Files W/O Existing Excel Application
Why not create one using DAO and the excel ISAM?


Quote:
> Hello!
> I was wondering if anyone knows of a way to write Excel files without
having
> Excel installed on the computer.  I don't care about graphs or any kind of
> other inserted object.  I just need text, numbers, formulas and fonts.  It
> has to support multiple sheets though.  I have considered ODBC but I am
> hoping there is another option.

> Thanks!
> Matthew Hanna



Wed, 13 Apr 2005 01:07:06 GMT  
 Writing Excel Files W/O Existing Excel Application
Hi,

If you are using Excel 2002, you can also consider XML format as an option:
INFO: Microsoft Excel 2002 and XML
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q288215

HOWTO: Use Visual Basic or ASP to Create an XML Spreadsheet for Excel 2002
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q285891

Regards,
Elan Zhou
This posting is provided "AS IS" with no warranties, and confers no rights.
Got .Net?  http://www.gotdotnet.com



Sat, 16 Apr 2005 14:33:46 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. Write a Excel File Without Excel App

2. Write to an Excel file from VB without Excel present

3. Writing Excel-files w/o Excel present?

4. Open Excel File (Excel.Application)

5. Detecting EOF for Excel file using Excel Application Object

6. Saving an excel WS

7. Saving Excel file to Excel file

8. ANNOUNCE : Platform independent toolkit for writing excel file format files

9. Problem opening Excel Addin with Excel application object

10. Excel Add-in and internal name of Excel Application

11. Excel Add-in and internal name of Excel Application

12. about Append the data into existing Excel File

 

 
Powered by phpBB® Forum Software