Bablosoft

CSV TO EXCEL

Support

  • A

    Excel errors in BAS

    Support
    0 Votes
    2 Posts
    650 Views
    m4zuperM

    This may be due to the file being used by two projects at the same time.
    In any case, I would like to ask you to attach the file and the projects so that I can look into your problem. You can attach the files here or in a private message on the forum.

  • DimokratorasD

    Read CSV Files

    Support
    0 Votes
    3 Posts
    1010 Views
    DimokratorasD

    @GaG Thank you for your help. Till now i found my way to manage easy csv tasks , since csv files are just text with comma for change column, and new lines for change row i can deal this on BAS by creating lists from "Read File to List" and then i can break each list item from "Parse string" with comma as separator. Then i use "Write File" for saving and i can live visualize the edited results on the csv file with a program called "Modern CSV". Thing is that on more advanced scripts i have big CSV files with a lots of rows and columns , sometimes i must to constant return to BAS the index position of partial value search terms on those files. I have found also an alternative way to manage by creating and executing a bat file with call for python for converting csv to xlsx and then i may use "module Excel" that haves all the actions im looking for, but Im wondering why BAS haves those actions only for xslx files, why not for csv also? Anyways till now im very satisfied to BAS but i might need more help in the future on this matter.

  • J

    Parse String Error Excel Module

    Support
    0 Votes
    4 Posts
    1063 Views
    J

    @GhostZ Thank you so much for your reply and help. Yes, I read the instructions. I saved as a list and all that and still got errors because I didnt know to use First Element instead of a regular list.

    This clarifies everything!

    And i get that it's an index but I dont understand why when all actions would definitely utilize the row so it requires an extra step.

    But i know nothing lol

    Thanks!

  • M

    Excel: Take First Line and Split columns into variables

    Support
    1 Votes
    3 Posts
    1291 Views
    M

    As this is way too complicated with BAS and no one has an idea how to solve it I simply built my needed bot with Zennoposter and finished it in no time.

  • D

    Help introducing data from Excel

    Support
    0 Votes
    7 Posts
    2846 Views
    D

    Awesome thanks a lot! will try it!