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?
-
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?
-
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.
-
As @JosephBywater said, you can export the excel file as a
.csv
(comma separated value ) file and use thecsv
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 ;)
-
Also check out https://automatetheboringstuff.com/chapter12/
-
@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
-
Thank you very much for the replies! I guess that will do the job.
-
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.
-
@MartinPacker read the link I provided above... It goes into detail how to achieve that.