VBA-CSV-interface
stdVBA
Our great sponsors
VBA-CSV-interface | stdVBA | |
---|---|---|
44 | 67 | |
57 | 244 | |
- | - | |
6.7 | 8.5 | |
12 days ago | 15 days ago | |
VBA | VBA | |
GNU General Public License v3.0 only | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
VBA-CSV-interface
-
Meet a library member: CSVTextStream, the king of performance.
To prove that we are capable to unlocks some performance limitations from traditional file processing approach, I decided to develop the CSVTextStream to gain advantage over native VBA's I/O functionalities, boosting the efficiency of text file reading up to 2 GB in size by use a buffered text stream technique. You can download the latest version from here.
-
A tool to empower VBA
This is by no means all the functionality that CSV Interface can provide. If you want to know more details, I invite you to read the documentation.
Welcome to this community, whose main objective is to serve as a help channel for CSV Interface users. Since its creation, the CSV Interface library, which came to light when it was announced in r/vba and r/excel, has been well accepted by many users around the world. Nowadays, there are NGOs and agencies with solutions programmed to facilitate the work of their collaborators. Working with CSV files, from VBA, has never been so easy.
-
Advanced CSV filtering through VBA
After this publication, which details the reason why VBA Expressions turned out to be the most feasible option to solve the problem of integrating an expression evaluator with CSV Interface, it is time to address the process of integrating the evaluation capabilities and the ease with which this goal was achieved.
-
Evaluating expressions from strings in VBA
In spite of what I discovered, I was convinced that I could incorporate the referred library to CSV Interface, so I dedicated myself to study the methodology with which variables are handled in stdLambda. I found it difficult to understand why the variables must be passed in terms of a pre-established order ($1 refers to the first value passed as parameter of the evaluate function, $4 the fourth... and so on). Thus, the user is forced to write the expressions taking into account the order in which the values will be passed.
-
Good Projects
If you want to do something really useful, you can contribute to one of the many amazing libraries around like stdVBA (you can see the backlog here), CSV Interface or VBCorLib
-
A new year, a new tool to work with CSV files. Happy holidays!
The new release of CSV interface includes substantial improvements and changes to the way users interact with the tool, as well as fixing some programming bugs. What's new in the latest version?
-
[EXCEL] Basic VBA - Send array value as plaintext
Here are the two procedures that solve your problem in a simple way using CSV files and the CSV interface. Note that if in the column where the file name is taken there is a repeated name, the contents of the array will be appended to the existing CSV file. Here is a link with the solution and the 2 outputs after execute it.
This is a great scenario to use CSV interface. With few lines of code, all files will be made by applying a simple for loop through the rows. You just need to encode the data copy to an array and the filename generator, the CSV job will be done by the interface. Reply to this if the issue is not solved yet.
-
Best way to read .csv to both VBA-array and table
If the performance still isn't acceptable then /u/ws-garcia has a dedicated CSV parser that they've worked hard at making very high performance.
stdVBA
-
Why do people still use VBA?
Honestly, this is something I've been wanting to do for a while... Last I looked though, I couldn't find many good resources on how WASI (or the byte code) worked... And VBA being single threaded might make things difficult too...
I have already built my own code interpreter in VBA to make Lambda syntax possible: https://github.com/sancarn/stdVBA/blob/master/src/stdLambda.... so I know it's definitely possible, just haven't figured out WASM yet...
I do RPA from VBA personally using IAccessiblity. See stdAcc (https://github.com/sancarn/stdVBA/blob/master/src/stdAcc.cls) and an example (https://github.com/sancarn/stdVBA-examples/tree/main/Example...)
I have invested copious amounts of time into building VBA libraries (https://github.com/sancarn/stdVBA) and as much as I love vba there are some highly limiting actual problems with VBA (https://sancarn.github.io/vba-articles/issues-with-vba.html) which really hurt the language. But yes a large portion of the hate VBA gets is from the state of VBA projects (https://sancarn.github.io/vba-articles/why-is-vba-most-dread...)
-
Writing a Compiler is Surprisingly Easy (part 1)
I have an open source compiler-interpreter for VBA here: https://github.com/sancarn/stdVBA/blob/master/src/stdLambda....
In case you were interested :P
You could have just treated everything as variant correct? That's what we do here: https://github.com/sancarn/stdVBA/blob/master/src/stdLambda....
-
How long have you been using VBA? What do you use it for at your job? Or for personal reasons
Sometimes, though more of a library / tool developer here. See stdVBA or stdVBA-examples
-
Bulk Structured Spreadsheet Extractor
Otherwise this library poses as an example of how to use stdVBA libraries. Libraries used in this project: stdEnumerator, stdArray, stdCallback, stdCOM, stdICallable, stdLambda, stdRegex.
-
A Fast and Simple Settings Management Module. Automatically sets everything up and works for PC or MAC
If you want a solution though see stdSettings. There are both system and user settings. Users are bound by their domain, so should work across organisations :)
- Creating a bot for automation.
-
Worst and best of VBA
Aha motivations for stdVBA which is a library I made. It resolves some of these points in some ways. E.G. stdLambda acts as a Lambda syntax for VBA. stdCallback allows you to ripe the benefits of first class functions, without those functions existing.
What are some alternatives?
ECPTextStream - ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
VBAChromeDevProtocol - VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium
Rubberduck - Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).
Export-MS-Project-to-MS-Excel - Export tasks, Gantt chart and resources from MS Project to MS Excel. No additional software or installation required. Using build-in MS Project features (VBA).
geo_vba - A geographic toolkit/library for VBA, excel etc.
QueryCsvToExcel - Provides VBA code for executing a SQL query on a CSV file to import data into a worksheet in Excel
VBA-Better-Array - An array class for VBA providing features found in more modern languages
VBA-Unit-Tester
VBCorLib - The VBCorLib framework brings many of the powerful .NET classes to VB6.
csvdecoder - Go library for parsing and deserialising CSV files into Go objects
VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.