omz:forum

    • Register
    • Login
    • Search
    • Recent
    • Popular

    Welcome!

    This is the community forum for my apps Pythonista and Editorial.

    For individual support questions, you can also send an email. If you have a very short question or just want to say hello — I'm @olemoritz on Twitter.


    Can I use Pythonista to manipulate Excel files?

    Pythonista
    7
    10
    13877
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • franco
      franco last edited by ccc

      Hello there, i'm totally noob and desperately trying to figure out how to automate spreadsheet on excel for iphone. Is it possible to use Pythonista to handle some tasks partially like VBA does on desktop?

      Phuket2 1 Reply Last reply Reply Quote 0
      • lukaskollmer
        lukaskollmer last edited by

        Have a look at http://www.python-excel.org/

        They list some Python packages to read and modify Excel files.

        You can use pip in Stash to install the packages

        1 Reply Last reply Reply Quote 0
        • ?
          A Former User last edited by

          Have a look at this: http://omz-software.com/pythonista/docs/library/csv.html I think you may be able to read excel spreadsheets or maybe just spreadsheets exported in the CSV format.

          1 Reply Last reply Reply Quote 0
          • TutorialDoctor
            TutorialDoctor last edited by TutorialDoctor

            As @JosephBywater said, you can export the excel file as a .csv (comma separated value ) file and use the csv python module to manipulate or create csv files. These files should be able to be opened in excel. If you need any assistance, let me know.

            1 Reply Last reply Reply Quote 0
            • ?
              A Former User last edited by

              I didn't even notice, but the title says Phytonista instead of Pythonista ;)

              1 Reply Last reply Reply Quote 0
              • ccc
                ccc last edited by

                Also check out https://automatetheboringstuff.com/chapter12/

                1 Reply Last reply Reply Quote 0
                • Phuket2
                  Phuket2 @franco last edited by

                  @franco , sorry I can't remember the name of the package or if it is compatible with Pythonista. But I remember finding a python lib that exposed the excel object model well enough so you could code in Python rather than VB. Just to say it exists

                  1 Reply Last reply Reply Quote 0
                  • franco
                    franco last edited by

                    Thank you very much for the replies! I guess that will do the job.

                    1 Reply Last reply Reply Quote 0
                    • MartinPacker
                      MartinPacker last edited by

                      Funnily enough I'm playing with CSV manipulation as an array I call a "matrix" right now.

                      Nothing useful to report yet.

                      But I'd love to be able to read in a .xls(x) file in my program.

                      1 Reply Last reply Reply Quote 0
                      • ccc
                        ccc last edited by

                        @MartinPacker read the link I provided above... It goes into detail how to achieve that.

                        1 Reply Last reply Reply Quote 1
                        • First post
                          Last post
                        Powered by NodeBB Forums | Contributors