Autoit csv file to array

Takes Excel object and sheet name for parameters and then:. This one I had also picked up from forums, but reworked. It turns giant string into actual two-dimensional array:. Using native Windows paths is often more convenient and bulletproof.

But for specific cases bit of specialized code can give program excellent speed boost. PS method also turned out useful to get data out of spoiled file Excel file overflowing with weird embedded objects for some reason. Workaround I had tried to work around it and turns out simply copying sheet into clipboard and processing from there into array takes much less time at the price of writing some code.

It is broken into several functions. It's easy! Already have an account? Sign in here. CSV file to multidimensional array. Recommended Posts. Posted May 14, Link to post Share on other sites. Juvigy 50 Posted May 14, All that is available in the excel udf. ProgAndy 88 Posted May 14, Here are my CSV-functions. Posted May 14, edited. Then you should look at the CSV Editor by funkey. It contains the simpler function, too. Edited May 14, by ProgAndy. It assumes 1 based arrays. George Question about decompiling code?

Read the decompiling FAQ and don't bother posting the question in the forums. Connect and share knowledge within a single location that is structured and easy to search. As TeamKiller said your question is quite vague but here is a sample code that should give you an idea of how to read a CSV file. As for parsing a CSV file, you are likely better off using a library called user-defined functions in AutoIt , especially if you e. You can then do everything you want with this array. Originally posted as an answer here , which I consider a duplicate of this question.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow.

I was fortunate enough to remember I was told about AutoIt sometime ago, "a scripting language designed for automating the Windows GUI and general scripting". I created a simple GUI which contains an input text to enter the date to schedule the payments and a button responsible for calling the "goPay" function. AutoIt has built-in support for the Internet Explorer browser, it's not the best, but does the job.

You can see others commands here.