Can I use Pythonista to manipulate Excel files?

franco

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?

lukaskollmer

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

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.

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.

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

ccc

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

Phuket2

@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

franco

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

MartinPacker

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.

ccc

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