Skip to content

ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.

License

Notifications You must be signed in to change notification settings

ws-garcia/ECPTextStream

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

68 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ECPTextStream

GitHub GitHub release (latest by date)

Introductory words

ECPTextStream is an easy-to-use class module developed to enable buffered text stream on VBA. In other words, ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications.

Advantages

  • The fastest way for I/O operations over "big" text files from VBA (up to 600 MB/sec.).
  • Supports files up to 2 GB of size.
  • Supports streams delimited by CRLF, LF and CR characters. This is useful when working with structured files like CSVs.
  • No memory overloads. Text files being read using a buffer, small enough to hold a single data line.
  • Minimal CPU overheat.
  • Configurable buffer size.
  • Coded in pure VBA. The module hasn’t reference to any external API library.

Getting started

If you don't know how to get started with ECPTextStream class, visit the documentation repo. If you don't know if this tool can help you, take a look to the popular CSV Interface repo or to this sample project.

Contributing

In order to contribute with in this project, please see the guidance for contributing.

Benchmark

The benchmark results for ECPTextStream are available at this site.

Limitations

Visit this site in order to known around file size considerations.

License

Copyright (C) 2021-2023 W. García.

This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program. If not, see https://www.gnu.org/licenses/gpl-3.0.html.