by Paul Squires (1 Submission)
Category: Data Structures
Compatability: Visual Basic 3.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: 
(77 Votes)
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.
Inputs
Refer to ZIP file.
Download Excel Class write to an XLS file without DLL's or Excel automation (49 KB)
No comments have been posted about Excel Class write to an XLS file without DLL's or Excel automation. Why not be the first to post a comment about Excel Class write to an XLS file without DLL's or Excel automation.
VBcoders