|7 months ago||about 2 months ago|
|GNU General Public License v3.0 only||GNU General Public License v3.0 only|
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.
Converting xlxs to csv without losing zeros
1 project | reddit.com/r/excel | 17 May 2022
Use VBA CSV interface, with it you can export worksheet data to CSV without any further data transformation.
Performing complex CSV data wrangling tasks with ease
1 project | reddit.com/r/vba | 27 Mar 2022
Compute 3P%. The first stage of our solution will be completed using the File System Object (FSO), so that we can indicate the path to the folder containing the data we wish to analyze. The desired goal can be achieved with very simple code. To complete the second stage, we will need to use a library that allows us to import, filter and handle results from different queries on CSV files; we will use for this purpose the CSV Interface library. Finally, we must compute the effectiveness of three-point shots made by LeBron James. It is clear that the task described is far from simple, but we will show that it can be achieved with readable, concise and extensible VBA code.
Advanced CSV filtering through VBA
2 projects | reddit.com/r/vba | 6 Mar 2022
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.
Fastest way to compare several hundred rows of data? [EXCEL]
1 project | reddit.com/r/vba | 22 Feb 2022
Maybe CSV Interface can help you. With this library you can read and import files in chunks (reducing memory usage). As well you can import one record at a time and perform your logic in order to determine which ones you want to append to memory.
Evaluating expressions from strings in VBA
4 projects | reddit.com/r/vba | 20 Feb 2022
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.
3 projects | reddit.com/r/vba | 23 Dec 2021
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!
1 project | reddit.com/r/excel | 23 Dec 2021
If it's not too much to ask, I hope you will make this project your own and that it can support current and future members of this wonderful community and many others! Your recommendations, suggestions and constructive criticisms are welcome (I hope there will be many in this post), and you can also give stars in GitHub!2 projects | reddit.com/r/vba | 23 Dec 2021
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?
VBA Import of CSV to Excel Sheet
1 project | reddit.com/r/excel | 15 Nov 2021
Use VBA CSV interface. The DumToSheet method can do the work. Here an example:
[EXCEL] Basic VBA - Send array value as plaintext
2 projects | reddit.com/r/vba | 27 Jul 2021
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.
What are some alternatives?
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
QueryCsvToExcel - Provides VBA code for executing a SQL query on a CSV file to import data into a worksheet in Excel
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
VBA_personal - Library with VBA, used in multiple projects.
csvdecoder - Go library for parsing and deserialising CSV files into Go objects
crypto_vba - An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
SFDX-Data-Move-Utility - The advanced Salesforce Data Loader SFDX Plugin (SFDMU) will assist you to populate your org (scratch/development/sandbox/production) with data imported from another org or CSV files. Supports Delete, Insert, Update and Upsert for multiple related sObjects.
EasyQuickImport - EasyQuickImport — Import transactions, invoices and bills into QuickBooks Desktop from Excel or CSV
ECPTextStream - ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
geo_vba - A geographic toolkit/library for VBA, excel etc.
VBCorLib - The VBCorLib framework brings many of the powerful .NET classes to VB6.