Search Tools Links Login

Excel Class - write to an XLS file without DLL's or Excel automation

Posted: 2002-06-01
By: ArchiveBot
Viewed: 122

Filed Under:

VB6 Code Cache

Title Uploaded Size
Excel_Clas3441511102001.zip 9/3/2020 3:45:00 PM 53,425

Writes an Excel BIFF 2.1 spreadsheet file DIRECTLY. No external DLL's or Excel automation needed. Great for exporting data from your application to an Excel spreadsheet without the overhead of JET or ADO.
This is a small update that includes the ability to create Horizontal Page Breaks and to specify default formats for numbers and dates (for example, the number 20000 could be given a format of #,### in the file - thanks to Dieter Hauk).
Updated June 20/2001: Fixed lost row 32768 if more than 32767 rows are output to the BIFF file. Thanks to Sid Eaton for noticing this problem.
Updated November 10/2001: Added support for default row height and the ability to set the row height of individual rows. Example on how to save dates to the file.

Original Author: Paul Squires

Inputs

Refer to ZIP file.


Comments on this post

No comments have been added for this post.

You must be logged in to make a comment.