VBA-CSV-interface Alternatives

Similar projects and alternatives to VBA-CSV-interface

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better VBA-CSV-interface alternative or higher similarity.

Suggest an alternative to VBA-CSV-interface

Reviews and mentions

Posts with mentions or reviews of VBA-CSV-interface. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-07-27.
  • 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.
    2 projects | reddit.com/r/vba | 27 Jul 2021
    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
    2 projects | reddit.com/r/excel | 18 Jul 2021
    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.
    2 projects | reddit.com/r/excel | 18 Jul 2021
    With CSV interface you can solve this problem in three (3) different ways:
  • How to get Export to stop functioning like Save As?
    1 project | reddit.com/r/excel | 1 Jul 2021
    Use VBA CSV interface. With VBA you can copy the content of the sheet to an array and export it to a CSV file.
  • Importing TXT files with new lines as new rows
    1 project | reddit.com/r/excel | 27 Jun 2021
    Use VBA CSV interface.
  • New mayor release of VBA CSV interface [with test suite]
    1 project | reddit.com/r/vba | 27 Jun 2021
    I am very excited to announce the v3.1.0 of the VBA CSV interface library. This new major release make the library the only VBA CSV parser that adopted the Test Driven Development (TDD) path in VBA. At the moment, the interface passed 48 out of 48 test cases, but there is a great syntax that helps to introduce new tests no matter the difficulty.
  • Merge all CSVs contained in a folder [Excel]
    1 project | reddit.com/r/vba | 20 Jun 2021
    This post attempts to tackle the problem with a different approach. Like Ron, I will use a library, VBA CSV interface, but the data will be written directly to a master file and not to Excel spreadsheets. The purpose of this will be to provide a pure VBA solution to the CSV merge problem by exploiting some of the benefits and strengths of the VBA CSV interface.
  • Using VBA CSV interface to work with USA Cartographic Boundary Files (Shapefiles)
    2 projects | reddit.com/r/vba | 20 Apr 2021
    Working from Notepad++ gave me an idea of how the text strings should be manipulated from VBA. The first thing to do from the VBA CSV interface will be to import only the fields that contain the relevant data to solve the problem (the_geom and NAME). The files created in this step (temporary) will be saved in the same folder.
  • Around 1 GB .csv file in excel: I know what Column(s) I need, how do I proceed?
    1 project | reddit.com/r/excel | 11 Apr 2021
    You can use the VBA CSV interface in a smart way. The first step would be to create a new CSV with only the desired columns, then you can filter the information or subset the created CSV data into individual pieces of meaningful information. In my test, an input file with 12 columns (191 MB) is converted to a 4-column CSV (68.9 MB) and only European sales are retrieved from this file. The good news is that there is only 2 MB of data in memory when creating the 4-column CSV. Here is the file used in my test, set to C:\csv's\ folder to run the test on your own. Here is a clip showing the code in action.
  • Power query interprets comma in data as a separator erroneously
    1 project | reddit.com/r/excel | 31 Mar 2021
    Download this, follow this installation instructions add a new "normal" module an paste this code
  • Taking VBA to a new level when working with CSV files. Data subsetting.
    1 project | reddit.com/r/vba | 30 Mar 2021
    That mishap left me inoperative for a few days, until I decided to design a solution for the problem using VBA CSV interface, a tool much easier to program using code.
  • Parsing special text files from VBA
    1 project | reddit.com/r/excel | 19 Mar 2021
    u/cteno4, if you are reading this, you will be surprised to learn that you DO NOT NEED TO BROWSE THE WHOLE INTERNET to find a library that fits your needs. You can solve your problem with a few lines of code if you use VBA CSV interface.
  • Can Power Query's simple INNER JOIN CSV query be faster? [EXCEL]
    1 project | reddit.com/r/vba | 19 Mar 2021
    On the one hand there is a recorded macro to execute two queries and perform an operation similar to SQL INNER JOIN. The macro also sorts the result in ascending order in the "Country" field. The other contender is a procedure that will perform the same operations using the VBA-CSV interface* library.


Basic VBA-CSV-interface repo stats
8 days ago

ws-garcia/VBA-CSV-interface is an open source project licensed under GNU General Public License v3.0 only which is an OSI approved license.

SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
Find remote jobs at our new job board 99remotejobs.com.
There are 31 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.