VBA-CSV-interface
VBA-Expressions
Our great sponsors
VBA-CSV-interface | VBA-Expressions | |
---|---|---|
44 | 5 | |
59 | 18 | |
- | - | |
6.7 | 7.0 | |
about 1 month ago | 3 days ago | |
VBA | VBA | |
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.
VBA-CSV-interface
-
Creation of the CSV interface community
During this process, I also thought about how to offer the users of the tool a help channel where they can receive help, since the code project is currently maintained by a single person. This is why I decided to create the r/CSVinterface community, whose main objective is to serve as a help channel for CSV Interface users.
-
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.
- CSV Interface GitHub repo
-
Is there a way to specify format when reading CSV files? Specifically, I'm struggling with delimiters and qualifiers
Your requirements are according to RFC-4180 specifications. There is no standard CSV format. This situation has led to the proliferation of CSV variations such as DSV, TSV... Creating a custom library to solve your problem can be a solution, you can also use other already developed and well tested libraries such as CSV Interface, a library that supports CSV according to RFC-4180 specifications and also DSV files using the Unix style scape sequence.
-
suggest amazing uses of macros VBA
VBA can solve, literally, every problem you can face in your daily routine. You can automate repetitive task and also expand the language to create complete utilities and offer others a solution to a common issue. For example, I created VBA CSV Interface to help users deal with data from CSV files.
-
Finding a quicker method for Concatenate
With CSV Interface this task can be done with easy. The library has a MergeField method that performs this specific task. Also you can shift fields and rearrange them as you wish.
-
New version of VBA CSV Interface
As usual, at the end of the year, a new version of VBA CSV Interface is available. However, this time it is a major revision focused on refactoring code and increasing the usability of the tool.
-
Batch file to split CSV
This is a great use case of VBA CSV interface. Using the library you can split your file on related data and filter it out by column/field content.
-
Sorting data by values NOT being sorted?
Save your data as CSV and manage it from CSV Interface.
VBA-Expressions
-
Evaluate piecewise functions in VBA
So, if a Dominican needs to calculate the taxes that will be charged to them monthly, they should take pencil and paper, compute the annual amount of income and apply the corresponding formula, or they can use the following code in conjunction with VBA Expressions and get their result in a simple way.
-
Solving systems of linear equations with VBA
Systems of linear equations have been taught since high school, they are of utmost importance in mathematics. Although Excel is possible to solve, manually, equations using matrix inverse and matrix multiplication. Today we will show you a practical way to solve such problems using VBA Expressions.
-
Expression evaluator for VBA
Here is a direct GitHub link to VBA Expressions Best regards!
-
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
After a long search for something similar to the above, I decided to experiment and test the veracity of a warning that read: "... rather, it evaluates the infix expression directly. This approach is slightly more complicated than the traditional one". Then, I chose to develop an evaluator with its own grammar and a different approach to handle mathematical expressions. The solution I came up with is so called VBA Expressions. With VBA Expressions we can evaluate a variety of mathematical expressions, being able to work with arrays defined by text strings as in Java. A notorious feature is the ability to work with variables (Pi.e * 5.2Pie.1 + 3.1Pie), constants (3pi+ln(2e)), floating point numbers ((1.434E3+1000)*2/3.235E-5) and Boolean values (x>0 & Sqr(x-Ln(2))>=3 | tan(x)<0).
What are some alternatives?
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).
crypto_vba - An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
geo_vba - A geographic toolkit/library for VBA, excel etc.
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
ECPTextStream - ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
Code-Finds-Determinant-of-a-Array-in-C
Tiger - C++ Matrix -- High performance and accurate (e.g. edge cases) matrix math library with expression template arithmetic operators
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
csvdecoder - Go library for parsing and deserialising CSV files into Go objects
VBCorLib - The VBCorLib framework brings many of the powerful .NET classes to VB6.