Search Tools Links Login

CSV File Viewer


Visual Basic 6, or VB Classic

This simple application will display CSV files (read-only) in a simple user-interface.
At my work we use hundreds of small CSV files daily. I created this to replace Microsoft Excel because: it loads quicker, reads the CSV files with multiple double-quotes per column correctly, and doesn't reformat dates.
This DOES NOT use the built-in Visual Basic features for parsing the CSV files, either. The biggest problem with the Visual Basic methods is that you can't tell when you reach the end of the line and therefore can't effectively tell how many columns there are in each line. So, a complete (and thoroughly tested) CSV parser was created from scratch.
Great care has been taken to make this a complete application. Within this code you'll also find how to do proper window-position saving, including when the application is closed while maximized, and more.
Let me know what you think!
Kody

Original Author: Kody Brown

Side Effects

On my Athlon 1800 (1GB RAM), I can load a file of 30 columns, with about 4,000 lines, in just a few seconds. But, I've noticed on the slower machines at work it can really slow down depending on the number of columns/rows. That is why I added the MAXLINES feature just in case. Set it appropriately for the speed/ram of your system.

About this post

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

Categories

Visual Basic 6

Attachments

CSV_File_V883295302002.zip
Posted: 9/3/2020 3:45:00 PM
Size: 10,689 bytes


Loading Comments ...

Comments

No comments have been added for this post.

You must be logged in to make a comment.