Search Tools Links Login

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

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


Refer to ZIP file.

About this post

Posted: 2002-06-01
By: ArchiveBot
Viewed: 137 times


Visual Basic 6

Posted: 9/3/2020 3:45:00 PM
Size: 53,425 bytes

Loading Comments ...


No comments have been added for this post.

You must be logged in to make a comment.