sdkn104 / vba-csv Goto Github PK
View Code? Open in Web Editor NEWCSV Parser and Writer as VBA functions
License: MIT License
CSV Parser and Writer as VBA functions
License: MIT License
Currently, I am improving the CSVinterface
class to make it RFC4180 standard fully compliant. As you know, your well developed project is used by me as a reference.
I test your code using the following CSV text and the returned value by your ParseCSVToArray
function is null
:
"Field with
multiple lines" , "Another field
with some
line breaks inside" , "Include some comma, for test" , Normal field here
1, 2, 3 ,4
"Field 1", "Field 2" , Field 3 , "Field 4"
The above CSV complies the RFC4180 standard.
Would it be possible to implement a function that returns a Dictionary where either the first column is used for the key or you can provide a column number that would be used as the key. Most of the time the data I am working with needs to be obtained using a key in my code so I end up creating a Collection/Array and using that to create the Dictionary so it would be nice to just get a Dictionary.
I currently work on a CSV-VBA interface that I suposses'll to allow users exchange data between VBA arrays and CSV files, like your project do, but at really high speed. You claim your code is able to read CSV data at about 5.33 MB/sec., but in my test, on a fairly outdated laptop, the performance of it is frustrating. Some suggestion?
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.